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
 

 

Selcopy of sort is useful for my query

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
sumany

New User


Joined: 26 Feb 2009
Posts: 1
Location: Bangalore

PostPosted: Sun Apr 12, 2009 1:56 pm    Post subject: Selcopy of sort is useful for my query
Reply with quote

Hi All,

Please help in which is better for my query -selcopy or sort utility

Prob is i have some data with some thing like (flat file)

2 111111111110 3-01-09 3-31-09001000P0020209821707641852200013W37941852
2 111111111130 04/16/2006 33,507 310
Code:
2          111111111110 3-01-09 3-31-09001000P0020209821707641852200013W37941852
2          111111111130               04/16/2006        33,507            310 

i want to do a select for all the things related to record type 10(mentioned in blue) and also '9'(mentioned in red)

My objective is by seeing the above conditions it must read all occurances of that number 1111111111 into output file.
If possible please provide the code.

Looking for your guidance.

Thanks
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2276
Location: @my desk

PostPosted: Mon Apr 13, 2009 9:15 am    Post subject:
Reply with quote

Quote:
i want to do a select for all the things related to record type 10(mentioned in blue) and also '9'(mentioned in red)
Hi sumany,

Welcome to the forums.

But I dont see anything mentioned in RED above. Have I become color blind? icon_lol.gif
Quote:
it must read all occurances of that number 1111111111 into output file
Neither your sample data nor your explanation seems to be sufficient to make your requirement clear to others. Please post some 5-10 records of input and make sure you cover all the possible scenarios. Also mention the input/output RECFM/LRECL etc.
Back to top
View user's profile Send private message
Nick Jones

New User


Joined: 28 Apr 2009
Posts: 13
Location: UK

PostPosted: Wed Apr 29, 2009 3:22 pm    Post subject: Selcopy of sort is useful for my query
Reply with quote

Sumany,

As Arun said, we need a little more information about the input and output records. Some more samples of both please (include positions of important fields within the records).

This looks like it would be a relatively simple SELCOPY task. I will post some code pending your spec and sample data.
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 -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to change 'K' or 'M' use Sort vice_versa DFSORT/ICETOOL 5 Thu May 18, 2017 7:11 am
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. SORT trick needed bshkris SYNCSORT 6 Tue May 02, 2017 4:35 am
No new posts SORT JSON type of data maxsubrat DFSORT/ICETOOL 8 Wed Apr 19, 2017 6:01 pm
No new posts Sort Large record length cmsmoon DFSORT/ICETOOL 14 Tue Apr 11, 2017 5:49 pm


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