Search found 805 matches
- 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...
- 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 ...
- Fri Mar 23, 2007 9:24 pm
- Forum: JCL
- Topic: JCL SORT - Count number of records in a file
- Replies: 9
- Views: 93757
- Tue Mar 13, 2007 10:41 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: sort and merge
- Replies: 2
- Views: 8611
- Thu Mar 08, 2007 9:58 pm
- Forum: JCL
- Topic: can we comment any data in sysin dd *
- Replies: 1
- Views: 11524
- 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
http://www.ibm.com/servers/eserver/zser ... opics.html
- Sun Feb 18, 2007 10:54 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT HELP
- Replies: 2
- Views: 7109
- 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...
- Wed Jan 17, 2007 3:17 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Reg DFSORT utility.
- Replies: 5
- Views: 30082
- 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...
- 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...
- 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
- 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...
- 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...
- 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...