So the questions is if I want to use ODBC and do a bind of C data types to the statement results how do I determine what the column data types will be in the disk_storage table for example ?
std::string statement("SELECT * FROM disk_storage WHERE storage_usage ILIKE '%data%' ORDER BY rank;");
...ret = SQLExecDirect( hdlStmt, (SQLCHAR*)statement.c_str(), SQL_NTS );
ret = SQLBindCol(hdlStmt, 1, SQL_C_???????, ....;
What is the secret way to determine what SQL_C_???????,would be for the system tables?
Thanks,
Karl