A few years back, I tested the output received from GET SQL DESCRIPTOR for SQL statements.

Here are all the output columns available from GET SQL DESCRIPTOR:

FLD1 = DATETIME_INTERVAL_CODE
FLD2 = DB2_BASE_CATALOG_NAME
FLD3 = DB2_BASE_COLUMN_NAME
FLD4 = DB2_BASE_SCHEMA_NAME
FLD5 = DB2_BASE_TABLE_NAME
FLD6 = DB2_CCSID
FLD7 = DB2_COLUMN_CATALOG_NAME
FLD8 = DB2_COLUMN_GENERATED
FLD9 = DB2_COLUMN_GENERATION_TYPE
FLD10 = DB2_COLUMN_HIDDEN
FLD11 = DB2_COLUMN_NAME
FLD12 = DB2_COLUMN_ROW_CHANGE
FLD13 = DB2_COLUMN_SCHEMA_NAME
FLD14 = DB2_COLUMN_TABLE_NAME
FLD15 = DB2_COLUMN_UPDATABILITY
FLD16 = DB2_CORRELATION_NAME
FLD17 = DB2_LABEL
FLD18 = DB2_PARAMETER_NAME
FLD19 = DB2_SYSTEM_COLUMN_NAME
FLD20 = INDICATOR
FLD21 = KEY_MEMBER
FLD22 = LENGTH
FLD23 = LEVEL
FLD24 = NAME
FLD25 = NULLABLE
FLD26 = OCTET_LENGTH
FLD27 = PARAMETER_MODE
FLD28 = PARAMETER_ORDINAL_POSITION
FLD29 = PARAMETER_SPECIFIC_CATALOG
FLD30 = PARAMETER_SPECIFIC_NAME
FLD31 = PARAMETER_SPECIFIC_SCHEMA
FLD32 = PRECISION
FLD33 = RETURNED_LENGTH
FLD34 = RETURNED_OCTET_LENGTH
FLD35 = SCALE
FLD36 = TYPE
FLD37 = UNNAMED
FLD38 = USER_DEFINED_TYPE_CATALOG
FLD39 = USER_DEFINED_TYPE_CODE
FLD40 = USER_DEFINED_TYPE_NAME
FLD41 = USER_DEFINED_TYPE_SCHEMA

Jim

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].