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

 

First character of every record not displayed!!??

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: First character of every record not displayed!!??
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    Post subject:
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: 1187
Location: Bangalore,India

PostPosted: Fri Aug 17, 2007 1:55 pm    Post subject:
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: 6967
Location: porcelain throne

PostPosted: Fri Aug 17, 2007 2:20 pm    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Fri Aug 17, 2007 2:33 pm    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    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 Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm
No new posts Format record to remove Leading zeroes Learncoholic DFSORT/ICETOOL 14 Wed Apr 05, 2017 2:43 pm
No new posts Record Not found in AlX but record re... mukun264 COBOL Programming 7 Fri Mar 24, 2017 9:28 am


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