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: 2180
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 Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm


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