Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in


Varchar problem

Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message

New User

Joined: 06 Mar 2006
Posts: 76
Location: Chennai

PostPosted: Mon Mar 13, 2006 8:03 pm    Post subject: Varchar problem
Reply with quote


I am trying to unload one table using DSNTIAUL utility in Jcl which (Table) has varchar field.

While browsing the unloaded file, varchar field has been populated with hex value inspite of spaces. Even i declared my cobol copybook as

03 varchar
49 varchar-len s9(4) comp
49 varchar-text x(80)

For length it is showing properly. But varchar-text is not coming properly. means if varchar-text is 'hallo' only hallo is coming properly the remaining 75 bites is coming hex value.

Can any one of you tell me should i need to incorporate any Keyword for Varchar field to select it?

Thanks in advance

Back to top
View user's profile Send private message


Active User

Joined: 01 Mar 2006
Posts: 287
Location: Basel, Switzerland

PostPosted: Tue Mar 14, 2006 3:00 pm    Post subject:
Reply with quote

hy noor,

if you define the length as 80,
then the following characters will be space,
if you put spaces into the text field.
means: in a varchar you define exactly the
needed length for a field.
in your case: 'hallo' is five bytes,
therefore it makes sense to give a length of 5.
if you read this field now, you will only get
the length in a proper way, the rest of the field,
(not stored in db), will be set to hex'00'.

note: you should always determine the length field first,
because, if you have length = zero, the field is empty,
and empty means really empty, all is hex'00'.

all clear, just ask more...

Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1


Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Low values Results from VARCHAR FORMAT balaji81_k DB2 10 Thu Oct 20, 2016 1:18 am
No new posts Problem in Running Query via JCL vickey_dw DB2 3 Tue Oct 18, 2016 11:11 pm
No new posts DB2 Streaming Batch Processing Problem Manshadi DB2 4 Sat Sep 24, 2016 12:14 pm
No new posts Problem with GETMAIN command amitc23 CICS 6 Thu Sep 01, 2016 1:01 pm
No new posts TXT2PDF problem - printing @ in PDF vipul65 All Other Mainframe Topics 9 Thu Aug 25, 2016 12:48 am

Back to Top
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us