include=() and include=()



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

include=() and include=()

Postby leon » Wed Jun 10, 2009 10:06 am

hi, I have a logical oprator "and" 2 condition. get the error message:" include invalid logical operator.
does anybody can help me? thx
..........
sysin:
 //  sort fields=copy
       outfil fnames=sortout,
                include=(13,2,bi,eq,x'305e') and
                include=(569,1,zd,eq,1)
//*
leon
 
Posts: 40
Joined: Tue Nov 25, 2008 7:39 pm
Has thanked: 0 time
Been thanked: 0 time

Re: include=() and include=()

Postby Frank Yaeger » Wed Jun 10, 2009 9:08 pm

The correct DFSORT syntax is:

//SYSIN DD *                             
  SORT FIELDS=COPY                       
  OUTFIL FNAMES=SORTOUT,                 
    INCLUDE=(13,2,BI,EQ,X'305E',AND,     
    569,1,ZD,EQ,1)                       


If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/servers/storage/supp ... tmpub.html
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: include=() and include=()

Postby leon » Thu Jun 11, 2009 7:58 am

works very well, thank you,Frank.
leon
 
Posts: 40
Joined: Tue Nov 25, 2008 7:39 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post