|
|
|
Forum Newbie
Group: Forum Members
Last Login: 4/10/2007 12:33:00 PM
Posts: 1,
Visits: 1
|
|
I'm porting a program from an NCR platform to SUSE Linux that reads in a select statement from a file and outputs a delimited flat file. The code opens the connections, prepares the statement and does a describe to get the field information:
/* Log on. Prepare and describe the statement. */
EXEC SQL LOGON :LOGON_STRING;
if (SqlCA.SqlCode != 0)
return(8);
/********** PREPARE */
EXEC SQL PREPARE SEL_STMT FROM :SQL_STATEMENT;
if (SqlCA.SqlCode != 0) {
EXEC SQL LOGOFF;
exit(2);
}
/********** DESCRIBE */
strncpy (MYSQLDA.sqldaid, "SQLDA ", 8);
MYSQLDA.sqldabc = 0;
MYSQLDA.sqln = MAX_FIELDS - 1;
EXEC SQL DESCRIBE SEL_STMT INTO MYSQLDA;
What's happening is that the describe is coming back with a return code of zero but is not returning any data. The code and compile option (-g is the only option) are the same on both platforms so that's not the issue. Has anyone else encountered similar problems with using Suse Linux and embedded sql? Thanks in advance.
|
|
|
|