E
egidio landuzzo
Guest
Hello, I'm a consultant and I'm trying to use a trial of your DataDirect ODBC Wire Protocol to access to DB2 z/OS. In my test I'm using a simple COBOL (Fujitsu) program from a windows PC. I've a strange behaviour using a simple query (I don't know if I'm doing something wrong). The query is something like this: EXEC SQL SELECT * FROM MYTABLE WHERE COLUMN1 BETWEEN :HVMIN AND :HVMAX END-EXEC. the COLUMN1 is defined as CHAR(4) Host variable HVMIN and HVMAX are defined as PIC X(4). If I MOVE LOW-VALUE to HVMIN and HIGH-VALUE to HVMAX the SELECT returns 0 rows. if I MOVE "0000" to HVMIN and "9999" to HVMAX the SELECT returns 2 rows. Using HIGH-VALUE and LOW-VALUE on z/os the same COBOL program returns 2 rows. Could you help me? Many thanks Egidio
Continue reading...
Continue reading...