I have DB2 (V10.1) installed on Linux redhat 2.6.32 and DB2 (V9.7) on AIX 188.8.131.52
When I execute DB2 PREP on my .SQC file on the Linux system, it completes no errors, creates the package and the program executes as designed.
If I take the same .SQC file to my AIX system and run DB2 PREP, I get multiple SQL0307N errors,( Host variable "XXXXXX" is already defined). No package ergo program does not run. Any ideas on the different behavior of Linux vs AIX?
The original program is COBOL with embedded SQL. I have a program that generates the .SQC file (c code).
thanks in advance