IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

First character of every record not displayed!!??


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Bhagyalakshmi C

New User


Joined: 24 Jul 2007
Posts: 38
Location: Bangalore

PostPosted: Fri Aug 17, 2007 1:18 pm
Reply with quote

Hi,

I am trying to fetch all the reocrds from a table and writting it in a file(PS).
Both the records length of the PS and the length of the variable using which i write into the file are same.
But still the first character of each record is not displayed.
Couldn't find out the reason. icon_question.gif
Help me!!!!

Thanks!!!!
Back to top
View user's profile Send private message
Bhagyalakshmi C

New User


Joined: 24 Jul 2007
Posts: 38
Location: Bangalore

PostPosted: Fri Aug 17, 2007 1:24 pm
Reply with quote

Let me add this also to the above post..

The character is blank and i am getting all the other characters correctly.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India

PostPosted: Fri Aug 17, 2007 1:55 pm
Reply with quote

Hi there,

Try to display it before writing into the file and put hex on while checking the value in spool.
Let us know the outcome
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Fri Aug 17, 2007 2:20 pm
Reply with quote

If what you are selecting is a varchar type, you will have to CAST inorder to drop the length, which is the first 2 bytes of your result.

If it is not varchar, then ignore my post.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Fri Aug 17, 2007 2:33 pm
Reply with quote

What is the RECFM of the output file?
What language are you using to produce the output?
Back to top
View user's profile Send private message
Bhagyalakshmi C

New User


Joined: 24 Jul 2007
Posts: 38
Location: Bangalore

PostPosted: Fri Aug 17, 2007 3:00 pm
Reply with quote

Hi there,

Try to display it before writing into the file and put hex on while checking the value in spool.
Let us know the outcome



Hi,

I tried this also..
am getting the same out(what i get in the file) in the spool also.
When i display it by putting hex on, its still blank.
But i think if its blank then i should get '4' in that place..(if i am right)..

help me!!!!!
Back to top
View user's profile Send private message
Bhagyalakshmi C

New User


Joined: 24 Jul 2007
Posts: 38
Location: Bangalore

PostPosted: Fri Aug 17, 2007 3:06 pm
Reply with quote

dbzTHEdinosauer wrote:
If what you are selecting is a varchar type, you will have to CAST inorder to drop the length, which is the first 2 bytes of your result.

If it is not varchar, then ignore my post.



Hi,
Its a character type only.Sorry!! I am getting what you are asking me to do.Please tell me in detail..

Thanks!!!!!!
Back to top
View user's profile Send private message
Bhagyalakshmi C

New User


Joined: 24 Jul 2007
Posts: 38
Location: Bangalore

PostPosted: Fri Aug 17, 2007 3:11 pm
Reply with quote

William Thompson wrote:
What is the RECFM of the output file?
What language are you using to produce the output?




RECFM is FB. and the record length is same for the record and in the file.
I am using PLI..

Thank you!!!!
Back to top
View user's profile Send private message
Bhagyalakshmi C

New User


Joined: 24 Jul 2007
Posts: 38
Location: Bangalore

PostPosted: Fri Aug 17, 2007 6:09 pm
Reply with quote

Hi all,

I myself got that problem solved.
sorry for the inconvience caused.

I was getting a warning message(but,not related to the problem specified early).

when i corrected the prog to remove the warning the problem was solved.

Thank you all!!!!!!!!

Once again sorry for the inconvience caused.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 8
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts Validating record count of a file is ... DFSORT/ICETOOL 13
Search our Forums:

Back to Top