Embedded SQL for Suse Linux

UDA
N/A

Embedded SQL for Suse Linux

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.