COBOL OCCURS clause and PL/I arrays

Start of change CICS® VT generates multiple columns for OCCURS clauses and arrays. For example, a copybook field defined as PAY-MONTH OCCURS 12 would become 12 columns in DB2® called PAY_MONTH_001, PAY_MONTH_002, and so on up to PAY_MONTH_012. End of change

If the OCCURS field name is longer than 26 characters, the column names generated by CICS VT exceed the DB2 30-byte limit when the 3-byte sequence number is added. In this case the status for the first field will be set to Name shortened, but the status for the remaining fields in the group will be blank.

You should be aware of the implications of variable length VSAM records and how they potentially affect your DB2 table design. This topic is covered in Variable length records in VSAM.


Information Information

Feedback


Timestamp icon Last updated: Monday, 10 February 2014


http://pic.dhe.ibm.com/infocenter/cicsts/v5r1/topic/com.ibm.cics.vt.doc//topics/cvtug_occurs_clause.html