Search found 805 matches
- Thu Aug 04, 2011 9:58 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: problem in sort
- Replies: 7
- Views: 7359
Sigh. How do you expect anyone to help you when you reject the answer to your problem with a statement like "I used this in the past, case was never a problem.". I don't know what you think you did in the past, but CASE MATTERS! DFSORT does NOT treat A (X'C1') and a (X'61') the same - they are NOT E...
- Wed Aug 03, 2011 10:40 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: comparing files with icetool
- Replies: 6
- Views: 7953
Yes, it is possible with DFSORT's JOINKEYS. For complete information on DFSORT's JOINKEYS, see: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA50/5.0?DT=20100630155256 For specific examples, see the "Create files with matching and non-matching records" Smart DFSORT trick at: http:/...
- Fri Jul 29, 2011 9:58 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Assigning values to fields using SORT
- Replies: 2
- Views: 3932
- Fri Jul 29, 2011 2:05 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comparing Two Records in the same file & Replacing Value
- Replies: 1
- Views: 3254
Here's a DFSORT job that will do what you asked for. Notice that the input file is used twice (for IN1 and IN2). I assumed the input file has RECFM=FB and LRECL=80, but the job can be changed appropriately for other attributes. //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //IN1 DD DSN=... input file (...
- Thu Jul 28, 2011 12:41 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comapare Two Records in the same File
- Replies: 27
- Views: 32453
Sorry, but I don't understand your rules as described. Perhaps a larger set of input records (with different variations of two customer id records, three customer id records, four customer id records) and expected output records would help. At any rate, I'm locking this thread since you seem to be u...
- Wed Jul 27, 2011 10:32 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Merging & Joining REcords in Five Files
- Replies: 5
- Views: 8466
Raul, If the ICE604A message marker is really pointing between TO(OUT) and USING(CTL1), then the character between them must not be a space (X'40'). Try typing a space over that character or look at it in hex. Same for the second ICE604A message. If that doesn't help, then please post the complete J...
- Tue Jul 26, 2011 1:37 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Matrix logic using ICETOOL.
- Replies: 1
- Views: 2687
You can use a DFSORT job like the following to do what you asked for: //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //IN1 DD * 100 MUM-A 200 DEL-B 200 DEL-C 300 COI-A 300 COI-B 300 COI-C 400 KOL-P 400 KOL-Q 600 CHE-Z //IN2 DD * 100 MUM-P 100 MUM-Q 200 DEL-R 300 COI-S 300 COI-T 300 COI-U BECKY 300 COI-V 40...
- Tue Jul 26, 2011 1:21 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Is it possible to add timestamp in the Header Record?
- Replies: 11
- Views: 15706
You can't use CTL as the symbol name in PARM. You have to use JPn (e.g. JP1). Here's a DFSORT/ICETOOL that will do what I think you're asking for: //STEP2 EXEC PGM=ICETOOL, // PARM='JP1"DPSIT4B.&MLQ..TAB002.D&ODATE..UNLOAD"' //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //IN DD DSN=DBRDB.ABPDB.RMS.TAB0...
- Tue Jul 26, 2011 1:03 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comapare Two Records in the same File
- Replies: 27
- Views: 32453
- Fri Jul 22, 2011 10:32 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT - Ifthen, when group question
- Replies: 2
- Views: 7867
You just need to use BEGIN for the XXX record. You don't need END. You can use a DFSORT job like the following. I assumed your input file has RECFM=FB and LRECL=80, but you can change the job appropriately for other attributes. //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD * XXX 08 DATA1 DATA2...
- Fri Jul 22, 2011 10:26 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comapare Two Records in the same File
- Replies: 27
- Views: 32453
- Fri Jul 22, 2011 1:34 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Merge two files with no join keys
- Replies: 1
- Views: 4630
I hope I didn't make it to confusing It's confusing to me. Are you using DFSORT or Syncsort? Please show an example of the records in each input file (relevant fields only) and what you expect for output. Explain the "rules" for getting from input to output. Give the starting position, length and f...
- Fri Jul 22, 2011 1:31 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comapare Two Records in the same File
- Replies: 27
- Views: 32453
- Thu Jul 21, 2011 12:28 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Is it possible to add timestamp in the Header Record?
- Replies: 11
- Views: 15706
If you can set up the dsname as a SET or PROC symbol, then you can use a DFSORT job like the following: // SET DSN1=data_set_name //S1 EXEC PGM=SORT,PARM='JP1"&DSN1"' //SYSOUT DD SYSOUT=* //SORTIN DD DSN=&DSN1,DISP=SHR //SORTOUT DD SYSOUT=* //SYSIN DD * OPTION COPY OUTFIL REMOVECC,NODETAIL, TRAILER1...
- Wed Jul 20, 2011 10:27 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Comapare Two Records in the same File
- Replies: 27
- Views: 32453