MVSFORUMS.com

pzmohanty

Hi all,

I am facing a problem while querying a DB2 table and populating the query data to a file using COBOL program.

detail desription of problem :

I am working on Z/OS environment with COBOL 360 & DB2 Ver 7.

One of my cobol program is quering data from db2 table using select statement and writing the data to a file .

My problem arised when one of the DB2 CHAR(30) field name CUST_NAME have data like 'P.MOHANTY' , when this data is being moved to file the PERIOD(.) in CUST_NAME field is converted to some special character having HEX code of 53 in file.

Can anyone please explain me the reason of this & can please let me know how to overcome this problem.

Thanks
P.R.mohanty
_________________
Priya Ranjan Mohanty
Consultant
Kanbay Software (I) pvt. Ltd.
Hyderabad

kolusu · Posted: Wed Feb 09, 2005 10:58 am Post subject:

pzmohanty,

I guess there is a CCSID encoding defined on the table or the codepage used by your program.

The default CCSID 1140 is an equivalent of CCSID 37 (EBCDIC Latin-1, USA) but includes the Euro symbol.

check this link for CCSID

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNSQH11/1.16?DT=20010718164132

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

pzmohanty · Posted: Thu Feb 10, 2005 2:04 am Post subject:

hi Kolusu,

Thanks for the reply , but I am still in the trouble.

Can you plz let me know how to get out of the problem
_________________
Priya Ranjan Mohanty
Consultant
Kanbay Software (I) pvt. Ltd.
Hyderabad

kolusu · Posted: Thu Feb 10, 2005 8:20 am Post subject:

pzmohanty,