MVSFORUMS.com

That's the beauty of DB2...no no changes have to be made for other columns, assuming there wasn't any funny business like redefines or anything. Always check programs closely, but no, there's no "rec ...

If you look in a higher post, there is a link posted which describes EXPLAIN results.

1 = I
4 = IV
5 = V
9 = IX
10 = X
(and so forth)

and so forth....you take your number, substitute and build the value using your STRING verb and then go from there...I suggest you store this as ...

Odds are the original poster may not have this capability, especially given what the person has posted. I'm not sure if 9(30) is valid for their compiler, but for computational purposes it seems like ...

To do a restart you add a statement to your SQL using a compare against your key fields (KEY1 > :KEY-FIELD). The cursor used to select the records to update must use ORDER BY as well. In this compar ...

Please describe in detail what you are wanting.

I would think you would be able to use STRING in COBOL and output a LRECL80 F file with your sort parms and then use that as input for your sort on a subsequent step. But it sounds like you got it un ...

You have your answer if it occupied 4 bytes in your file.

The ASCENDING clause does not sort the data, merely specifies to the system to expect the data to be sorted for purposes of the SEARCH ALL.

As long as you are using SEARCH (like I said, for other reasons it's good to use it instead of a perform), you should be fine on that area. Even with the perform you should be fine as long as you are ...

This is done through your JCL. You can define a report to be sent to file just as easily as it is sent to printer. Most reports are usually something like RECFM=FBA,LRECL=133 - if you define it like ...

SEARCH is a sequential search, which is the same as the perform you mention you are doing. Your sample data indicates multiple items in field-1 so this disqualifies using SEARCH ALL, if you want to g ...

I understand the difference between a subscript and an index. I'm just basically ranting on the difference showing up in COBOL and not in another language, and the difficulty in most situations of co ...

I'm writing this to try and describe one of the problems I have with how index handling is done in COBOL...the indexes and the subscripts aren't very interchangable...

The indexes are only good IMO ...

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IGY3PG00/4.2.6.1?DT=20011203125201#HDRDUP1875

There's the answer to your question. It's as I suspected (the FD's are clashing if you don' ...