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
 

 

Substituting Spaces and writing to a PS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
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    Post subject: Substituting Spaces and writing to a PS
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    Post subject:
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    Post subject: Re: Substituting Spaces and writing to a PS
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    IBMMAINFRAMES.com Support Forums -> CLIST & REXX All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Writing on to GSAM variable length rohanthengal JCL & VSAM 6 Fri Mar 03, 2017 7:46 pm
No new posts Count Trailing Spaces in variable str... Virendra Shambharkar SYNCSORT 10 Thu Feb 02, 2017 12:23 pm
No new posts Problem in writing Output file vickey_dw COBOL Programming 5 Mon Nov 14, 2016 11:14 pm
No new posts To trim spaces in a pipe delimited da... Nish84 COBOL Programming 16 Mon Oct 10, 2016 1:54 pm
No new posts Easytrieve - Report writing - Only 1 ... Abhi Nature CA Products 2 Wed Sep 14, 2016 11:40 am


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