MVSFORUMS.com

Think i just answered my own post. I can use SUBSTR(fieldname,start,length) in my SQL to point to the portion of the string that i want to use.

I am passing a character string to a cobol program. A query is then going to be done on this string.

The max size is 40 characters. I need to size of the field used in the query to match the size ...

I am wondering if it is possible to read/write to a flat file from a DB2 stored procedure? I read something that implied its possible. But it didnt go into any details about how.

My experience ...

This is for a Cobol program so the solution you gave would work. But to add some more difficulty to it, what if I do not know the actual number of table entries. If Table is set up for 100 occurs, b ...

Table looks like this: 3 rows of data with 4 columns

abc xyz n 12345 12345
abc xyz y 56789 56789
abc ooo n 2468 2468

And I would li ...

I am working with a table of data that I need to String together to send to another process. If my table has 5 columns and 4 rows, how would I use the String command to put all the data in this table ...

Kinda lost me here. Are you basically saying that because of the E35 rtn, OUTFIL is ignored, thus it doesnt know where to write the new output from the E35 rtn? So it just ends up nowhere.

This is what the trailer record looks like.

1 02 STATDB-LS-CTL-REC REDEFINES STATDB-LS-DETAIL-REC.
1 05 STATDB-LS-CTL-REC-TYPE PIC X(2).
3 05 ...

You may dare to ask. I'm not familar with the report features, so I didnt even consider them an option. I'm looking at them now. But i guess in the long term, I see the exit rtn as a more durable s ...

I have one input that i am splitting into 3 outputs. I would like the put a header and trailer record on each output. I have an exit rtn that does this, but I cannot get it to work with multiple out ...

One last question if you have the time...

whats the difference here between the OUTREC control statement
OUTREC FIELDS=(1,153,
X'00',
(155,8,PD,ADD,2 ...

Thanks. There's alot of stuff in there I've never seen before. I'm gonna have to go through it and figure out the details. But from your description i get the basic idea.

Unfortunately, the coun ...

I really don't see the use of an exit in here unless you are doing some complex programming logic.

I need to update the trailer record with the new record count. if records will end up being comb ...

Here is my situation:

I am concatenating 5 datasets as input. Each is of the same format.

Header record
Detail record
Trailer record

I need to put these through a syncsort that will ...

Thats what i tried (see above). But in my testing, that only seems to work if add colons to the copybook. I can't modify the copybook.