All Forums Database
SSS 1 post Joined 11/04
14 Mar 2008
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...ThanksSSS

joedsilva 505 posts Joined 07/05
15 Mar 2008

There's sort of a round about waySELECT TYPE(MYTABLE.COL1);Type(COL1)-----------INTEGER

You must sign in to leave a comment.