Kbase P141034: ESQL/C SELECT returns no data
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/02/2009 |
|
Status: Unverified
SYMPTOM(s):
ESQL/C SELECT returns no data
Return code 13 from SQL FETCH.
FACT(s) (Environment):
ESQL/C program connects to the database successfully.
Same SQL query executes successfully from SQL Explorer.
ESQL/C program migrated from 32-bit HP/UX running Progress 9.1E to 64-bit Linux running 64-bit OpenEdge 10.1C.
Same program runs successfully on 32-bit HP/UX running Progress 9.1E.
Executable program built with custom script that calls g++ compiler directly rather than through the esqlc command.
Red Hat Enterprise Linux 5
OpenEdge 10.1C
CAUSE:
Custom build script did not define the DH_OS_UNIX_64 environment variable.
FIX:
Define DH_OS_UNIX_64 using the -D command line parameter when compiling the C program generated by esqlc with a separate C compiler.