midrange.com -- midrange-l mailing list

Re: Wrapped message queue during

Michael_Schutte — 2010-03-22T08:31:50-05:00

Use either a null indicator or use COALESCE function to replace null value with some other value. Such as D Field1 s 10 D Field1NullInd s 5I 0 declare c1 cursor for select b.field1 from file1 a left join file2 b on keyfield open c1 fetch c1 into :field1 :...

Wrapped message queue during

Tomasz SkorÅa — 2010-03-22T08:21:52-05:00

Hi I have some program SQLRPGLE which enter data into one file. When I call this program in batch I get message that message queue ais wrapped and then if I looking to job que I see that there are maaany messages: Additional Message Information Message ID...

Re: Best Path to Follow First With Web Service.

eftimios pantzopoulos — 2010-03-22T04:06:01-05:00

Thanks Scott, I've taken your advice and downloaded HTTPAPI, and will invest time in that first of all. I hadn't realized that IWS enabled communication in both directions, which was why it seemed a bit confusing to me. All the references I had seen were ...

Re: Best Path to Follow First With Web Service.

Scott Klement — 2010-03-21T22:58:48-05:00

RE: Best Path to Follow First With Web Service.

eftimios pantzopoulos — 2010-03-21T17:41:23-05:00

Thank you so much for the advice. I realized early on that the learning curve would be huge when all I really want to do is send and receive! (or put and get, or write and read). As I'm just taking baby steps, I didn't want to spend lots of time and then ...

Re: Best Path to Follow First With Web Service.

Scott Klement — 2010-03-21T13:41:58-05:00

RE: Best Path to Follow First With Web Service.

Neill Harper — 2010-03-21T08:01:12-05:00

Its taken me a while but I am starting to make good progress with XML4PR now. I have had to wrap most of the API methods myself to make it usable. But it is very fast and very flexible. However it is only an XML processor and validator, it cannot make HTTP...

Re: Best Path to Follow First With Web Service.

Chamara Withanachchi — 2010-03-21T03:46:03-05:00

Hi, I'm using Scott Klement's HTTP API Open Source routines to consume web services (from RPG), it is straight forward thing, currently I'm looking in to RPG-XML suit which is a handy tool for me.

Best Path to Follow First With Web Service.

eftimios pantzopoulos — 2010-03-21T02:21:53-05:00

We've encountered a need to consume a web service, and I've been immersing myself in the net trying to work out what the best long term solution is. I'm aware of 4 ways of approaching this. There may be more and I may have these groupings wrong. Forgive m...

Re: Debugging an SQL Function

CRPence — 2010-03-20T19:34:21-05:00

Although a moderated forum, there is no /rule/ as such. It is IMO just a courtesy to make the discussion match the subject; not just for those who might choose to follow the current thread, but even more importantly for searching the archives. Why frustra...

Re: Debugging an SQL Function

eftimios pantzopoulos — 2010-03-20T17:43:27-05:00

Thanks Chuck & Birgitta. I’ll draw this to a close, but what are the rules for posting when a topic takes a different path from the original subject line? I had a vague feeling that an SQL function which is implemented through another language was just a ...

Re: Save while active on 6.1

CRPence — 2010-03-20T13:32:35-05:00

An object having a flag indicating that SWA is active on the object when in fact SWA is not active against that object is referred to as "logical damage"; i.e. by the given description, the object was in an inconsistent\illogical state, and therefore the ...

Re: Why i??? NEED YOUR INPUT

CRPence — 2010-03-20T13:13:33-05:00

Presumably "abends" means an "abnormal end" from the perspective of the OS [code] itself <<SNIP>> <<SNIP>> if the message about "object may be damaged" due to an internal OS sfw error having led to the SWA failure was issued, then the message is probably ...

Re: 57##SS1 option 42 Journal caching

DrFranken — 2010-03-20T12:54:39-05:00

Re: Debugging an SQL Function

CRPence — 2010-03-20T12:43:06-05:00

The above is an "External User Defined Function" for SQL which is not the same as a "SQL User Defined Function". The SQL UDF is written in the SQL, not in another language like RPGLE or even SQLRPGLE; i.e. the source must indicate t;LANGUAGE SQL". That th...

Re: PDM vs. Rdi

Joe Pluta — 2010-03-20T11:46:45-05:00

You know what happens when you assume! For me, either! It took several minutes to set them up. I almost quit using the tool because of it. Joe

RE: 57##SS1 option 42 Journal caching

Don — 2010-03-20T10:11:53-05:00

Hmmm...I hear the Fast/400 guys thinking again.... DR2 ------ -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of DrFranken Sent: Saturday, March 20, 2010 8:56 AM To: midrange-l@xxxxxxxxxx...

RE: 57##SS1 option 42 Journal caching

Richard Schoen — 2010-03-20T09:52:19-05:00

I didn't know there were 5 and 10gb disk units in the 60's :-) Regards, Richard Schoen RJS Software Systems Inc. "Get the information you need. Now!" Document Management, Workflow, Report Delivery, Forms and Business Intelligence Email: richard@xxxxxxxxxxx...

Re: PDM vs. Rdi

Vern Hamberg — 2010-03-20T09:04:12-05:00

I happily use my PDM user actions in RSE every day. --buck

Re: PDM vs. Rdi

Joe Pluta — 2010-03-20T08:48:16-05:00

You copy and paste the PDM action from SEU. The syntax for user actions supports all the same variables (and more). The user actions in the GUI tools are definitely designed to extend the existing functionality in PDM. Joe I happily use my PDM user actions...