Join this group to access featured content and participate in discussions related to DMX.

149 Members
Join Us!

DTL /FILTER question

I am trying to build a DTL file that sorts a file based on it's first 8 chars.  When done, there will be over 100 possibilities and I plan to have a script build the DTL based on a dynamic input. My problem is the /FILTER line is not being honored.  If I have before the first /OUTFILE, it becomes a source filter and shows up.  If I put it after an /OUTFILE, no error is generated but it does not show up.  If I try to use anything other than the RETAINIF option, I get an error that target filters can only use the RETAINIF option so I believe I have it in the right place.  I have tried moving the /CONDITION lines but that made no difference.

My DTL file is

/DTL RUNTIMEVARIABLES ON
    /TASKTYPE COPY
    /INFILE c:\somepath\racf.txt STREAM CRLF ENCODING ASCII LAYOUT racf_layout
    /RECORDLAYOUT racf_layout  {
       tid 8,
       rest 5500
     }
    /OUTFILE c:\somepath\jobinit.txt STREAM CRLF OVERWRITE ENCODING ASCII
    /FILTER RETAINIF some_cond1
    /CONDITION some_cond1 racf_layout.tid='JOBINIT '
    /OUTFILE c:\somepath\access.txt STREAM CRLF OVERWRITE ENCODING ASCII
    /FILTER RETAINIF some_cond2
    /CONDITION some_cond2 racf_layout.tid='ACCESS  '
  /END

Thanks!

You need to be a member of Syncsort Community to add comments!

Join Syncsort Community

Email me when people reply –

Replies

  • I have found that if I run this directly via dmexpress, it works correctly.  It is only when I import it via the GUI and tried to run it there that it did not work.

This reply was deleted.

To access Syncsort Knowledge Base, visit:

My Support