Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 2285
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 sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts HEX value search in a DB2 query maxsubrat DB2 2 Wed Oct 04, 2017 3:04 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us