Search found 107 matches

Sat Sep 01, 2012 7:02 pm
Forum: JCL
Topic: how to get the count of records providing certain condidtion
Replies: 7
Views: 6045
William Collins -

Sorry, I didn't give much attention to that sample output order. Sorry for that
Sat Sep 01, 2012 1:29 pm
Forum: JCL
Topic: how to get the count of records providing certain condidtion
Replies: 7
Views: 6045
Hi Hima - This can be done thru SORT //R020 EXEC PGM=SORT //SYSOUT DD SYSOUT=* //SORTIN DD * ASS002 009878654 ASS002 998634664 ASS002 485781533 ARR003 346583746 AZZ987 346764766 ARR003 361764465 //SORTOUT DD SYSOUT=* //SYSIN DD * SORT FIELDS=(01,6,CH,A) INREC OVERLAY=(17:C'0000001') ...
Fri Aug 17, 2012 3:36 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT JCL - INREC OVERLAY
Replies: 7
Views: 10693
William - Thanks a lot for your time in this. Yes you are absolutely correct - This would mean that it is not only zero which will give you a problem, but anything less than 1,000 will, as that will not contain a comma either. I solved this with FINDREP in INREC.! //SYSIN DD * INREC IFTHEN=(WHEN...
Fri Aug 17, 2012 12:02 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT JCL - INREC OVERLAY
Replies: 7
Views: 10693
Thanks DickDude and William - Yes I was doing PARSE only in the OUTREC. But the thing is - my input will be having amount fields, when ever zeros coming as an amount value I will be getting that value as 0.00 but if it is greater than zero it will be "xxxxxx.00". In order to make the parse condition...
Thu Aug 16, 2012 10:12 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT JCL - INREC OVERLAY
Replies: 7
Views: 10693

SORT JCL - INREC OVERLAY

Hi, I am trying to do - INREC OVERLAY as follows //SYSIN DD * INREC IFTHEN=(WHEN=(25,04,CH,EQ,C'0.00'), OVERLAY=(5:5,20,C'"0.00"',29,35)), IFTHEN=(WHEN=(22,04,CH,EQ,C'0.00'), OVERLAY=(5:5,17,C'"0.00"',26,35)) SORT FIELDS=COPY // Input: ----+----1----+-...
Tue Aug 14, 2012 3:03 pm
Forum: COBOL
Replies: 18
Views: 19067
Venky,

Please let us know how exactly your input will be? and how exactly want the output to be?

Until unless getting the clear picture of your problem no one can provide the solution for that!
Fri Aug 10, 2012 12:08 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Doubt in where clause conditions ordering
Replies: 1
Views: 2231

Doubt in where clause conditions ordering

Hi, This may sound simple - But please do clarify me. I have some 4 conditions under where clause as follows Where table_column_1 = :ws-field1 and table_column_2 = :ws-field2 and table_column_3 = :ws-field3 and table_column_4 = 'abcd' In this case - Is that matters to give the conditions on the inde...
Sat Jul 21, 2012 2:41 pm
Forum: TSO, CLIST & REXX
Topic: Need a help on collecting SYSOUT details from abended jobs
Replies: 1
Views: 2329

Need a help on collecting SYSOUT details from abended jobs

Hello all, I am working on a task as follows, 1.Need to check what are the JOBs went down in SAR, 2.Collect the reason for the abend jobs - means SYSOUT information 3.format it and send it as mail. I could able to check the abened JOBs thru SARBCH util, but some one please suggest me how to get the ...
Mon Jun 11, 2012 12:00 pm
Forum: JCL
Topic: Doubt in Cataloged Procedure
Replies: 6
Views: 5627
Yes I accept.. Thanks Dikdude and NicC!!
Fri Jun 08, 2012 3:42 pm
Forum: COBOL
Topic: suggest me to buy one mainframe book
Replies: 3
Views: 3522
Hi Paramesh,

Welcome to the forum..

Are you looking for the mainframe programming language books like COBOL JCL SORT DB2 or mainframe architecture kind of books for admin level?
Fri Jun 08, 2012 2:44 pm
Forum: JCL
Topic: Doubt in Cataloged Procedure
Replies: 6
Views: 5627
Thanks Nic for your suggestion. I got one more suggestion as follow from one of my co-worker. That is, in Calling jcl Step01 exec caldproc , over ride the cond of step 3 as failing one, step02 exec sort step to back up the FileA step03 exec caldproc over ride the cond of step1 & 2 as failing and ste...
Thu Jun 07, 2012 3:32 pm
Forum: JCL
Topic: Doubt in Cataloged Procedure
Replies: 6
Views: 5627

Doubt in Cataloged Procedure

Hi, I am having a doubt in cataloged Proc, I have a cataloged Procedure which has 3 steps like 1. unloading a fileA, 2. COBBATDB - process using fileA, 3. Dummy out the fileA. moving dummy file to the fileA in order to make it as empty. Now what I need to know is that can I add a step in between the...
Thu Sep 08, 2011 8:15 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Comparing two feilds in a file - Sort
Replies: 5
Views: 8476
Gurugars, My job works fine with DFSORT. The WER messages indicate you're using Syncsort, not DFSORT. I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort. Thanks Frank.. I made s...
Mon Sep 05, 2011 3:26 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Comparing two feilds in a file - Sort
Replies: 5
Views: 8476
I tried the Above and i am getting OUTFIL : Syntax error. I verifed and the syntax seems to be fine . I am not sure what might be issue is. The actual length of the feild his 226 and not 192. so i increased it. Please advice. Error message: CTL1CNTL : OUTFIL FNAMES=OUT, IFOUTLEN=424, IFTHEN=(WHE...
Fri Sep 02, 2011 7:39 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Comparing two feilds in a file - Sort
Replies: 5
Views: 8476

Comparing two feilds in a file - Sort

Hi , I have a requirement in a project . I have a input file which his FB and lrecl of 424 . I have to use two fields in that file to check a condition say its sorted by address field. The starting position for the account his 1 and the length his 9 and for address feild his 66 and the length his 19...