Search found 805 matches

by Frank Yaeger
Fri Mar 23, 2007 10:27 pm
Forum: JCL
Topic: JCL SORT - Count number of records in a file
Replies: 9
Views: 93757

Veera, I'm happy to hear you tested your solution before posting it. I guess you just have to be more careful doing the copy and paste. COUNT without editing is fine if the result happens to be what's needed, but COUNT with editing is more flexible. Peace. P.S. In the future, I'd suggest using BBCod...
by Frank Yaeger
Fri Mar 23, 2007 9:57 pm
Forum: JCL
Topic: JCL SORT - Count number of records in a file
Replies: 9
Views: 93757

well can u tell me the reason as why it will not work ??? You will get a syntax error for: SORT FIELDS=COPY, Also, SYSPRINT isn't needed and BLKSIZE=0 isn't needed. How to display the count i mean =(M11,LENGTH=8) can be tailored.. I don't understand this. What are you trying to say? Are you asking ...
by Frank Yaeger
Fri Mar 23, 2007 9:24 pm
Forum: JCL
Topic: JCL SORT - Count number of records in a file
Replies: 9
Views: 93757

Girish, Veera's job won't work. Here's a DFSORT job that will: //S1 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD DSN=... input file //SORTOUT DD DSN=... output file //SYSIN DD * SORT FIELDS=COPY OUTFIL REMOVECC,NODETAIL, TRAILER1=('No of records: ',COUNT=(M11,LENGTH=8)) /* SORTOUT ...
by Frank Yaeger
Tue Mar 13, 2007 10:41 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: sort and merge
Replies: 2
Views: 8611

You haven't given enough information about your input files and records, the criteria for removing records, etc. And why did you post this in the DFSORT Forum when you say you want to use a COBOL program?
by Frank Yaeger
Thu Mar 08, 2007 9:58 pm
Forum: JCL
Topic: can we comment any data in sysin dd *
Replies: 1
Views: 11524

It depends on the program you're using. The program defines the rules for what it considers comments in //SYSIN. And the records you show in //SYSIN don't look like control statements for any standard program.
by Frank Yaeger
Thu Feb 22, 2007 1:57 am
Forum: DFSORT , ICETOOL & Utilities
Topic: z/OS Hot Topics Newsletter
Replies: 1
Views: 5289

z/OS Hot Topics Newsletter

The latest issue (#16) of the z/OS Hot Topics Newsletter has two articles on DFSORT. You can access all of the Newsletters from:

http://www.ibm.com/servers/eserver/zser ... opics.html
by Frank Yaeger
Sun Feb 18, 2007 10:54 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT HELP
Replies: 2
Views: 7109

Here's a DFSORT job that will do what you asked for: //S1 EXEC PGM=ICEMAN //SYSOUT DD SYSOUT=* //SORTIN DD * David David David XXXXXXXXXXXXXX David David /* //SORTOUT DD SYSOUT=* //SYSIN DD * * Sort descending on description to make it the first record, * if present. SORT FIELDS=(7,14,CH,D) ...
by Frank Yaeger
Sat Feb 03, 2007 9:14 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: 2 input files sorted into 1 output file
Replies: 2
Views: 10479

If you want fields from each file in the same output record, you can use the technique discussed in the "Join fields from two files on a key" Smart DFSORT Trick at: http://www.ibm.com/systems/support/storage/software/sort/mvs/tricks/ If you need more specific help, please show an example of the reco...
by Frank Yaeger
Wed Jan 17, 2007 3:17 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Reg DFSORT utility.
Replies: 5
Views: 30082

Glad I could help.
by Frank Yaeger
Tue Jan 16, 2007 10:12 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Reg DFSORT utility.
Replies: 5
Views: 30082

That's a very indirect way to get a trailer record with the count, and the way it's set up it won't give you any output records when there are no input records. You can use the more direct method of using DFSORT's TRAILER1 and COUNT parameters, which will give you a record with a count of 0 when the...
by Frank Yaeger
Sat Jan 13, 2007 10:24 pm
Forum: JCL
Topic: How to copy a file by inserting quotes?
Replies: 1
Views: 6777

It's not clear what you want to do so you need to answer some questions to clarify things. I assume you have input records something like this: text1,text2,text3 Do you want the output to be: 'text1','text2','text3' or 'text1,text2,text3' Can some of the text fields have embedded blanks? For example...
by Frank Yaeger
Wed Dec 20, 2006 1:53 am
Forum: DFSORT , ICETOOL & Utilities
Topic: compare two files and write duplicate records to file no dup
Replies: 4
Views: 24602

We just need to change the DFSORT/ICETOOL job a little to handle files with those attributes and the 13-byte key as follows: //S2 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //FILEA DD DSN=... input fileA (FB/150) //FILEB DD DSN=... input fileB (FB/13) //T1 DD DSN=&&T...
by Frank Yaeger
Tue Dec 19, 2006 10:33 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: compare two files and write duplicate records to file no dup
Replies: 4
Views: 24602

Here's a DFSORT/ICETOOL job that will do what you asked for. I assumed your "key" was in positions 1-6, and your input files have RECFM=FB and LRECL=80. You can change the job appropriately if those assumptions are incorrect. //S1 EXEC PGM=ICETOOL //TOOLMSG DD SYSOUT=* //DFSMSG DD SYSOUT=* //FILEA D...
by Frank Yaeger
Tue Dec 12, 2006 10:36 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Repeat Report Headers at the top of the page
Replies: 1
Views: 8201

DFSORT's OUTFIL statement lets you use three types of headers for reports as follows: HEADER1 - report header. Appears once at the start of the report. HEADER2 - page header. Appears at the top of every page. HEADER3 (in SECTIONS) - section header. Appears at the top of every section. So you can use...
by Frank Yaeger
Sat Dec 09, 2006 9:59 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SYNCSORT - questions
Replies: 1
Views: 9840

I am using syncsort because I am not familiar with DFSORT. Is this even available? How can I determine which one to use. I know that syncsort is used here. Not sure about DFSORT If your site uses Syncsort, then it's probable it doesn't also have DFSORT. Most sites have one or the other. It is possi...