Hi,

Im a newbie. I would like to know how can we get the data type of a column in c++.

I know DESCRIBE SELECT <column name> FROM <tablename>;

How about if writing it in c++ code?



Thanks

i don't know i helps or not just another way

describe select * from tabname


regds
Paul

thanks for the reply.

i have here the code:

*_pSession << "DESCRIBE SELECT COLNAME FROM TABNAME", into(info), now;


my prob is I dont know what type variable 'info' will be. that will hold the results after executing that statement.

You cannot DESCRIBE an inline statement: it must refer to a prepared statement. The information you are looking for is in the SYSCAT.COLUMNS catalog view:

yes i thought of that option too from syscat.columns but wht if user is not a superuser and everything is revoked from public, user cannot access system tables

regds
Paul

I have tried to execute the statement given by n_i but it returned nothing.

oh! n_i was right. I have missed to identify the tabschema. Thanks!

I have one more question, is the typename a string? because i encountered an assertion error after I executed the statement.


Here is my code:

where 'name' is a string variable.
This variable 'name' is supposed to hold the result after you execute the statement.

Sorry my bad.


I found the error.. The code a pasted above works fine. Thanks for the help!