Oninit cdi / Archive
Talk to an expert →

Want to know the 'description-text' of SYSCOLUMNS.coltype

Posted in 2003

Topics: General Discussion

Bert Prins — — source: Usenet: comp.databases.informix

Hello In the SYSCOLUMNS-table you find the column 'coltype' with the values 0 - 31. But where o where can I find the 'description-text' of those types (ie. type 7 = Date or something like that)? Greetings Bert Prins

↪ replying to Bert Prins
rkusenet — — source: Usenet: comp.databases.informix

it is there in $INFORMIXDIR/incl/esql/sqltypes.h file. #define SQLCHAR 0 #define SQLSMINT 1 #define SQLINT 2 #define SQLFLOAT 3 #define SQLSMFLOAT 4 #define SQLDECIMAL 5 #define SQLSERIAL 6 #define SQLDECIMAL 5 #define SQLSERIAL 6 #define SQLDATE 7 #define SQLMONEY 8 #define SQLNULL 9 #define SQLDTIME 10 #define SQLBYTES 11 #define SQLTEXT 12 #define SQLVCHAR 13 #define SQLINTERVAL 14 #define SQLNCHAR 15 #define SQLNVCHAR 16 #define SQLINT8 17 #define SQLSERIAL8 18 #define SQLSET 19 #define SQLMULTISET 20 #define SQLLIST 21 #define SQLROW 22 #define SQLCOLLECTION 23 #define SQLROWREF 24 "Bert Prins" <prinsoft@hotmail.com> wrote in message news:3fba3996$0$58702$e4fe514c@news.xs4all.nl... > Hello > > In the SYSCOLUMNS-table you find the column 'coltype' with the values 0 - > 31. But where o where can I find the 'description-text' of those types (ie. > type 7 = Date or something like that)? > > Greetings > > Bert Prins > >

↪ replying to rkusenet
Bert Prins — — source: Usenet: comp.databases.informix

Thanks a lot!! This was a very fast answer! Bert Prins "rkusenet" <rkusenet@sympatico.ca> schreef in bericht news:bpde04$1ncl62$1@ID-75254.news.uni-berlin.de... > it is there in $INFORMIXDIR/incl/esql/sqltypes.h file. > > #define SQLCHAR 0 > #define SQLSMINT 1 > #define SQLINT 2 > #define SQLFLOAT 3 > #define SQLSMFLOAT 4 > #define SQLDECIMAL 5 > #define SQLSERIAL 6 > #define SQLDECIMAL 5 > #define SQLSERIAL 6 > #define SQLDATE 7 > #define SQLMONEY 8 > #define SQLNULL 9 > #define SQLDTIME 10 > #define SQLBYTES 11 > #define SQLTEXT 12 > #define SQLVCHAR 13 > #define SQLINTERVAL 14 > #define SQLNCHAR 15 > #define SQLNVCHAR 16 > #define SQLINT8 17 > #define SQLSERIAL8 18 > #define SQLSET 19 > #define SQLMULTISET 20 > #define SQLLIST 21 > #define SQLROW 22 > #define SQLCOLLECTION 23 > #define SQLROWREF 24 > "Bert Prins" <prinsoft@hotmail.com> wrote in message > news:3fba3996$0$58702$e4fe514c@news.xs4all.nl... > > Hello > > > > In the SYSCOLUMNS-table you find the column 'coltype' with the values 0 - > > 31. But where o where can I find the 'description-text' of those types (ie. > > type 7 = Date or something like that)? > > > > Greetings > > > > Bert Prins > > > > > >

Related threads