Many open systems products used by clients today do not provide detail level data manipulation capabilities. In some cases, this can limit the products' ability to see "nonrelational" data as relational columns.
For example, a CA Datacom/DB table has a column defined as:
02 MONTH-SALES OCCURS 12 TIMES PIC S9(6)V99
An SQL view of this table includes the field MONTH_SALES as a CHAR(96) column. If the product viewing this column cannot redefine the data item, this data becomes unusable to the end user. If this data is important, a External Procedure could be written (in COBOL) to use SQL to retrieve the CHAR(96) column and move it to working storage, where the program language could be used to extract the 12 distinct values and place them in 12 columns SQL can use. These columns with other data items would be returned as part of the output variable list.
|
Copyright © 2014 CA.
All rights reserved.
|
|