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

Substituting Spaces and writing to a PS


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
prodigy

New User


Joined: 15 May 2006
Posts: 28

PostPosted: Mon Jul 16, 2007 12:21 pm
Reply with quote

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
View user's profile Send private message
saiprasadh

Active User


Joined: 20 Sep 2006
Posts: 154
Location: US

PostPosted: Mon Jul 16, 2007 2:30 pm
Reply with quote

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
View user's profile Send private message
prodigy

New User


Joined: 15 May 2006
Posts: 28

PostPosted: Wed Jul 18, 2007 10:01 am
Reply with quote

Thanks matey
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 -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts Two input files & writing counter... DFSORT/ICETOOL 12
No new posts leading spaces can be removed in trai... DFSORT/ICETOOL 1
No new posts Cobol program with sequence number ra... COBOL Programming 5
No new posts AI writing DFSORT, REXX codes.. All Other Mainframe Topics 3
No new posts Writing the output file name from a p... JCL & VSAM 7
Search our Forums:

Back to Top