View previous topic :: View next topic
|
Author |
Message |
Bhagyalakshmi C
New User
Joined: 24 Jul 2007 Posts: 38 Location: Bangalore
|
|
|
|
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.
Help me!!!!
Thanks!!!! |
|
Back to top |
|
|
Bhagyalakshmi C
New User
Joined: 24 Jul 2007 Posts: 38 Location: Bangalore
|
|
|
|
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 |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
What is the RECFM of the output file?
What language are you using to produce the output? |
|
Back to top |
|
|
Bhagyalakshmi C
New User
Joined: 24 Jul 2007 Posts: 38 Location: Bangalore
|
|
|
|
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 |
|
|
Bhagyalakshmi C
New User
Joined: 24 Jul 2007 Posts: 38 Location: Bangalore
|
|
|
|
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 |
|
|
Bhagyalakshmi C
New User
Joined: 24 Jul 2007 Posts: 38 Location: Bangalore
|
|
|
|
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 |
|
|
Bhagyalakshmi C
New User
Joined: 24 Jul 2007 Posts: 38 Location: Bangalore
|
|
|
|
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 |
|
|
|