View previous topic :: View next topic
|
Author |
Message |
prodigy
New User
Joined: 15 May 2006 Posts: 28
|
|
|
|
Hi,
i have a small work of preparing error reports. i have to query a table and write it to a dataset and FTP the dataset.. i have written a REXX to query and write to a PS. But there are some VARCHAR columns which comes NULL sometimes... in this case, the columns following the VARCHAR column is getting appended to this column... is there any way to substitute something else instead of null while writing it to PS? |
|
Back to top |
|
|
saiprasadh
Active User
Joined: 20 Sep 2006 Posts: 154 Location: US
|
|
|
|
Hi prodigy,
You can use the following command to fill some spaces for the varchar fields.
For Ex:
Code: |
VAR_CHAR = LEFT(QUERY_FIELD,' ',60) |
Where the Query_field is the varchar value you got from the query
Thanks
Sai |
|
Back to top |
|
|
prodigy
New User
Joined: 15 May 2006 Posts: 28
|
|
|
|
Thanks matey |
|
Back to top |
|
|
|