Page 2 of 2

Re: COBOL DB2 Compiler options

PostPosted: Thu Apr 24, 2014 11:35 pm
by NicC
If by SE you mean the line command in SDSF then use SET HEX ON to display the output in hex - and put the field boundaries (><) into your DISPLAY statement so that you can see the full extent of the value.

Re: COBOL DB2 Compiler options

PostPosted: Fri Apr 25, 2014 12:30 am
by dick scherrer
Hello,

I suspect this depends on local definitions. . .
Neither of those hex values shows anything "printable" on my system . . .

Re: COBOL DB2 Compiler options

PostPosted: Fri Apr 25, 2014 1:54 am
by Terry Heinze
ß is not printable in Reflection either but ALT+225 (using the numeric keypad will display it in Word or Notepad or here. I'm looking at the Extended ASCII Chart.

Re: COBOL DB2 Compiler options

PostPosted: Fri Apr 25, 2014 7:32 am
by SMRAO123
the problem is the - while going the data in the cobol host variables to sql query ( insert/update) data is converting ( to EBCIDIC I think ). And in the same way while retrieving the data from sql query to host variables data is converting.

So for the above sql select query value Y is displayed ( in spool edit mode) as ß

DEC HEX EBCDIC ASCII
089 59 ß Y

I would like to know why the data is converting?

Re: COBOL DB2 Compiler options

PostPosted: Fri Apr 25, 2014 11:35 am
by SMRAO123
Seems problem is with CCSID's. Any idea what values need to be used to avoid conversion?

Re: COBOL DB2 Compiler options

PostPosted: Fri Apr 25, 2014 1:38 pm
by NicC
Only your support can tell that as it is country specific and may even depend on company if processing for clients in other countries.

Re: COBOL DB2 Compiler options

PostPosted: Fri Apr 25, 2014 6:52 pm
by SMRAO123
In my precompile, CCSID(500) was used, but in bind I can see 'ENCODING UNICODE(01208)'. I overrided CCSID in bind with - ENCODING#500# now data is populating during & retrieving in select statements correctly.

Thanks

Re: COBOL DB2 Compiler options

PostPosted: Tue Jul 15, 2014 11:28 pm
by seenaiah
Can somebody please explain what ill happend if there is no plan and package?

Re: COBOL DB2 Compiler options

PostPosted: Sat Oct 25, 2014 1:05 am
by seenaiah
Hai,
[deleted as not relevant to the topic and answers could be found using the search facility]

Re: COBOL DB2 Compiler options

PostPosted: Sat Oct 25, 2014 2:50 am
by Terry Heinze
Please start a new topic instead of adding onto an unrelated one.