coltype

Hi, Can someone help me to interpret coltype in syscolumns system catalog table. I have coltype=0 coltype=1 coltype=2 coltype=4 coltype=5 coltype=6 coltype=7 coltype=10 coltype=11 coltype=12 coltype=256 coltype=258 coltype=259 coltype=261 coltype=262 Thanks Roger XU Database Administrator Dr Pepper Bottling Company of Texas 2304 Century Center Blvd. Irving, TX 75062 (972)721-8337

Check out the header file $INFORMIXDIR/incl/esql/sqltypes.h or $INFORMIXDIR/incl/tools/sqltypes.h if you have either ESQL-C/SDK or 4GL installed. Types number > 255 are NOT NULL columns just subtract 256 to determine the actual type. See also the code in my dbschema replacement utility, myschema, in the file myschema.ec for complete type and resolution (for variable length and configurable types like VARCHAR, DECIMAL, and DATETIME) interpretation sample code. Art S. Kagel Roger Xu wrote: > > Hi, > > Can someone help me to interpret coltype in syscolumns system catalog table. > I have coltype=0 > coltype=1 > coltype=2 > coltype=4 > coltype=5 > coltype=6 > coltype=7 > coltype=10 > coltype=11 > coltype=12 > coltype=256 > coltype=258 > coltype=259 > coltype=261 > coltype=262 > > Thanks > > Roger XU > > Database Administrator > Dr Pepper Bottling Company of Texas > 2304 Century Center Blvd. > Irving, TX 75062 > > (972)721-8337