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
 
how omit works exacty???

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
ram_vizag

New User


Joined: 21 Aug 2008
Posts: 94
Location: hyd

PostPosted: Tue Nov 05, 2013 5:17 pm    Post subject: how omit works exacty???
Reply with quote

Hi freinds,

I'm analysing the code and i have to rewrite the same code in informatica.
Please someone explain the below querry.

Code:

SORT FIELDS=(47,37,CH,A)   
SUM  FIELDS=(84,6,                           
             90,6,                           
             96,6,                           
             102,6,                         
             108,6,                         
             114,6,                         
             120,6,                         
             126,6,                         
             132,6,                         
             138,6,                         
             144,6,                         
             150,6,                         
             156,6,                         
             162,6,                         
             168,6,                         
             174,6,                         
             180,6),FORMAT=PD               
OUTFIL OMIT=(38,6,CH,EQ,X'00000000000C',AND,
             44,6,CH,EQ,X'00000000000C',AND,
             50,6,CH,EQ,X'00000000000C',AND,
             56,6,CH,EQ,X'00000000000C',AND,
             62,6,CH,EQ,X'00000000000C',AND,
             68,6,CH,EQ,X'00000000000C',AND,
             74,6,CH,EQ,X'00000000000C',AND,
             80,6,CH,EQ,X'00000000000C',AND,
             86,6,CH,EQ,X'00000000000C',AND,
             92,6,CH,EQ,X'00000000000C',AND,
             98,6,CH,EQ,X'00000000000C',AND,
             104,6,CH,EQ,X'00000000000C',AND,
             110,6,CH,EQ,X'00000000000C',AND,
             116,6,CH,EQ,X'00000000000C',AND,
             122,6,CH,EQ,X'00000000000C',AND,
             128,6,CH,EQ,X'00000000000C',AND,
             134,6,CH,EQ,X'00000000000C')   
OUTREC FIELDS=(1:47,403) 
END                       

Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1777
Location: Bloomington, IL

PostPosted: Tue Nov 05, 2013 5:32 pm    Post subject:
Reply with quote

It is hardly a "query"; it is a *sort control deck. I may be missing some subtleties in my early-morning fog, but it seems badly written to me. Do you have any idea of what's supposed to happen?
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7315

PostPosted: Tue Nov 05, 2013 5:59 pm    Post subject: Reply to: how omit works exacty???
Reply with quote

It is not fog.

The logical order is

SORT
SUM
OUTREC
OUTFIL

OUTREC is chopping the records down. Which means the full records have been SORTed, for no reason.

Anyway, you're getting rid of it. Just bear in mind that it is inefficient, if someone compares it to how the new job runs.

The OUTFIL OMIT= is getting rid of any records in which 17 packed-decimal fields which at least in the main line up with those that have been summed (I haven't checked all the positions) are a positive packed-decimal zero.

What do you mean by "re-writing it in informatica"?
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Nov 05, 2013 8:31 pm    Post subject:
Reply with quote

Hi Bill,

Quote:
What do you mean by "re-writing it in informatica"?
Changing the process to use Informatica code rather than the sort.
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Include/omit with "ALL" pa... mgl DFSORT/ICETOOL 6 Wed Jun 14, 2017 2:31 pm
No new posts How Adabas works in Mainframe ranujn Java & MQSeries 5 Sat Jun 04, 2016 11:20 am
No new posts Join and Omit records- Master File no... shajeeth DFSORT/ICETOOL 5 Tue Jan 26, 2016 8:16 pm
No new posts OMIT other unsatisfied records in OUT... tvinodkumar7 DFSORT/ICETOOL 6 Thu Jan 08, 2015 1:33 pm
No new posts How to avoid/Omit Addtional qualifer ... cmsmoon TSO/ISPF 2 Thu Nov 27, 2014 6:31 pm

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