CODEWITHSUNDEEP
sqldb2cobol
Rex
Rex

Reputation: 23

DB2 to COBOL String Losing Line Feed and Carriage Returns

i'm trying to grab some data out of a table. The Variable is VARCHAR 30000 and when I use COBOL EXEC SQL to retrieve it, the string is returned but without the necessary (hex) Line Feeds and Carriage Returns. I inspect the string one character at a time looking for the Hex Values of 0A or 0D but they never come up.

The LF and CR seem to be lost as soon as fill the string into my cobol variable.

Ideas?

Upvotes: 0

Views: 1233

Answers (3)

LarryN
LarryN

Reputation: 1

Well, I believe this could be dialect dependent (both COBOL and DB2) but if it were me I would be using FOR BIT DATA on the VARCHAR in the table definition. Your issue could also relate to the code page defined for the database in which the table resides.

I routinely store all kinds of binary, EBCDIC and Unicode data mixed within the same VARCHAR FOR BIT DATA column with no problems, and all you are trying to do is include CR & LF. My approach works in both DB2 z/OS and DB2 LUW.

I hope this helps.

Upvotes: 0

Bruce Martin
Bruce Martin

Reputation: 10543

If the data is stored / converted to ebcdic when retrieved on the mainframe, you should get the EBCDIC New-Line characters x'15' decimal=21 rather than 0A or 0D.

It is only if you are retrieving the data in ASCII / UTF-8 that you would get 0A or 0D.

Most java editors can edit EBCDIC (with the EBCDIC New-Line Character x'15') just as easily as ASCII (with \n), not sure about Eclipse though.

Upvotes: 1

Kennah
Kennah

Reputation: 497

I have seen situations where CR and LF were in data in the database. These are valid characters so it's possible for them to be stored there.

Have you tried to confirm that there really are CR and LF characters in the database using some other tool or method? My Z-Series experience is quite limited, so I'm unable to suggest options. However, there must be some equivalent of SSMS and SQL Server on the Z-Series to query the DB2 database.

Check out this SO link on querying DB2 and cleaning up CR and LF characters.

DB2/iSeries SQL clean up CR/LF, tabs etc

Upvotes: 0

Related Questions