I have some questions about the columns in the resultset that is returned from this method.
Column (3, PARAMETER_NAME): Will this be NULL in the return value row?
Column (8, PRECISION): GPC returns non-NULL for all SQL types. Should it return NULL for some types?
Column (9, LENGTH): GPC uses TypeDescriptor.getMaximumWidthInBytes(). When running in ij, this returns 256 for VARCHAR(128), and it looks like it will return 256 for CLOB and BLOB. That does not seem right to me...
Column (11, RADIX): GPC returns 10 for all types, except REAL, FLOAT and DOUBLE. Should it not be NULL for some types, e.g. VARCHAR, CLOB?
Column (12, NULLABLE):
a) GPC always returns procedureNullable. Should GFP return functionNullable for all types? (TypeDescriptor.isNullable() exists but is not used)
b) Should this column be NULL for the return value row?
Column (14, CHAR_OCTET_LENGTH) a) How can we identify the char/binary types in Derby? Can we use DataTypeDescriptor.isBinary() and isCharacter()?
b) How to get the true max for the type? (Don't think getMaximumWidthInBytes() will work as it returns maximumWidth for these types.
Column (16, IS_NULLABLE a) Is this a String equivalent of column 12?
b) Does YES in quotes mean String s = "YES" or String s = "'YES'"?