that should mark the input field as containing null, by writing '?' in the first column.
the first 10 bytes are the data field and the 11th is the according indicator field as in db2.
Now i have a char field with length 60.
is there a facility to write the in= and out= string in a shorter way?
i know there is the '9X' for nine blanks.
but i need '9X' !! C'0' !! C'?'.
Is there a way to concatenate char expressions?
Joined: 09 Aug 2008 Posts: 1631 Location: Mumbai, India
Posted: Wed Sep 14, 2011 5:04 pm Post subject:
I believe it can be done, however, I'm not very sure how your input looks like. It'd be nice if you show at least one example of sample records for us to have a better idea of input and the expected output from that. _________________ Regards,
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum