Column_Type Description

Database
SSS
N/A

Column_Type Description

I am able to find the column type from dbc.columns.columnType (Ex: DA, AT, CF, CV, I.. etc), but I would like to know where can I find the description of these types in DBC database (I know what DA (Date), CF (Character Fixed length), CV (Character Variable Length)) and use that DBC.XXXX.YYYY in my programming rather than writing a case statement to resolve the definition of column type. Please help me...

Thanks
SSS
1 REPLY
Enthusiast

Re: Column_Type Description

There's sort of a round about way

SELECT TYPE(MYTABLE.COL1);

Type(COL1)
-----------
INTEGER