IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

how omit works exacty???


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ram_vizag

Active User


Joined: 21 Aug 2008
Posts: 112
Location: hyd

PostPosted: Tue Nov 05, 2013 5:17 pm
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: 1788
Location: Bloomington, IL

PostPosted: Tue Nov 05, 2013 5:32 pm
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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Tue Nov 05, 2013 5:59 pm
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

Moderator Emeritus


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

PostPosted: Tue Nov 05, 2013 8:31 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Use input file with OMIT rcd keys? DFSORT/ICETOOL 15
No new posts How to OMIT Records older than the cu... DFSORT/ICETOOL 15
No new posts OMIT first and last column of a pipe-... DFSORT/ICETOOL 1
No new posts Create Dynamic Sort card with Omit co... DFSORT/ICETOOL 9
Search our Forums:

Back to Top