Search found 64 matches
- Wed Oct 31, 2018 1:46 pm
- Forum: IBM DFSort, ICETOOL, ICEMAN, ICEGENER.
- Topic: omit 2 days old data from current date in Sort.
- Replies: 3
- Views: 1606
Re: omit 2 days old data from current date in Sort.
If you are doing a table unload , why can't you exclude the records during unload itself by tweaking the DB2 query to select only last 2 days data?
- Thu Jun 01, 2017 1:50 pm
- Forum: IBM DFSort, ICETOOL, ICEMAN, ICEGENER.
- Topic: Adding the counts of duplicates while keeping the duplicate.
- Replies: 3
- Views: 1343
- Thu Dec 08, 2016 2:32 pm
- Forum: Introduce Yourself and Share Your IT Experience.
- Topic: Robert Sample.
- Replies: 6
- Views: 4273
Re: Robert Sample.
Totally Agree with Anuj.. Having Robert Sample on this forum is big big asset for forum. I am seeing Robert's pots on various forum for quite some time and feels my self lucky to have interaction ( not one to one but through posts) with this great person. Much appreciate your time for spreading your...
- Tue Dec 06, 2016 6:05 pm
- Forum: Introduce Yourself and Share Your IT Experience.
- Topic: vasanthz
- Replies: 4
- Views: 678
Re: vasanthz
Welcome Vasanth.. Nice to see you here..
- Tue Nov 08, 2016 11:20 am
- Forum: IBM DB2 and IMS DB/DC
- Topic: Updating Cursor row withour using FOR UPDATE
- Replies: 1
- Views: 2179
Updating Cursor row withour using FOR UPDATE
Hi All, My cursor query is as below EXEC SQL DECLARE CUR2 CURSOR FOR SELECT COL1, COL2 FROM TABLE1 WHERE COL3 = 'ABC' END-EXEC. For table has only 1 row satisfying above criteria with COL1 = 'XYZ' Below are the steps I am following 1. Open the cursor 2. Fetch the cursor which will eventually give on...
- Wed Oct 26, 2016 4:11 pm
- Forum: Interview Questions.
- Topic: Call COBOL-DB2 program from pure COBOL program?
- Replies: 12
- Views: 3206
Re: Call COBOL-DB2 program from pure COBOL program?
Nice to see you here Arun..
- Tue Oct 04, 2016 9:34 am
- Forum: Interview Questions.
- Topic: Handling SQLCODE -811.
- Replies: 3
- Views: 688
Re: Handling SQLCODE -811.
It should not happen. Can you please post your SQL and cursor declaration where you are getting -811
Thanks,
Chandan
Thanks,
Chandan
- Wed Sep 21, 2016 2:18 pm
- Forum: IBM DFSort, ICETOOL, ICEMAN, ICEGENER.
- Topic: INCLUDE on INREC, which comes first?
- Replies: 1
- Views: 519
Re: INCLUDE on INREC, which comes first?
Refer this for Sort control card execution sequence
http://publibz.boulder.ibm.com/cgi-bin/ ... FIGSTMTSEQ
http://publibz.boulder.ibm.com/cgi-bin/ ... FIGSTMTSEQ
- Wed Sep 21, 2016 1:38 pm
- Forum: IBM DFSort, ICETOOL, ICEMAN, ICEGENER.
- Topic: Keep the SORT order in output as input while removing the duplicates.
- Replies: 2
- Views: 855
Re: Keep the SORT order in output as input while removing the duplicates.
I can think of a two step solution here 1. Remove the duplicates using your key and in INREC add the sequence number at the end and create output file with sequence number 2. Sort the output file from step 1 on sequence number and write the outpur file. Remove the sequence number in OUTREC Thanks, C...
- Sun Sep 11, 2016 1:28 pm
- Forum: IBM DFSort, ICETOOL, ICEMAN, ICEGENER.
- Topic: Pick the latest record using SORT.
- Replies: 3
- Views: 484
Re: Pick the latest record using SORT.
Ok..Thanks Mangesh..
[ Post made via Android ]
[ Post made via Android ]
- Sat Sep 10, 2016 6:38 pm
- Forum: IBM DFSort, ICETOOL, ICEMAN, ICEGENER.
- Topic: Pick the latest record using SORT.
- Replies: 3
- Views: 484
Re: Pick the latest record using SORT.
Yes..it can be done using sort.. You need to group the records on each key in INREC and assign sequence number for each group.. Sort the records using your key and sequence number descending to get the latest record first then eliminate the duplicates in next step I don't have access to system now s...
- Wed Sep 07, 2016 11:17 pm
- Forum: IBM DFSort, ICETOOL, ICEMAN, ICEGENER.
- Topic: Merge records from two file, one by one.
- Replies: 14
- Views: 1197
Re: Merge records from two file, one by one.
You might have missed first BEGIN record in your testing, but still if you have a solution without having first begin statement, then you are good. Regards, Magesh Yup you are correct..my bad..I overlooked the first begin statement [ Post made via Android ] http://zmainframes.com/ext/sniper/mobiled...
- Wed Sep 07, 2016 5:03 pm
- Forum: Interview Questions.
- Topic: When the DCLGEN variable are used?
- Replies: 5
- Views: 859
Re: When the DCLGEN variable are used?
All the copy books mentioned with INCLUDE taken into consideration during per-compilation and all the copy books mentioned with COPY are taken into consideration during compilation
- Wed Sep 07, 2016 2:10 pm
- Forum: IBM DFSort, ICETOOL, ICEMAN, ICEGENER.
- Topic: Merge records from two file, one by one.
- Replies: 14
- Views: 1197
Re: Merge records from two file, one by one.
10701 Imran Lamba, Assuming LRECL=80. //SORT010 EXEC PGM=SORT //SORTIN DD * BEGIN // DD DSN=FIRST.FIL,DISP=SHR // DD * BEGIN // DD DSN=SECOND.FIL,DISP=SHR //SORTOUT DD SYSOUT=* //SYSOUT DD SYSOUT=* //SYSIN DD * INREC IFTHEN=(WHEN=GROUP,BEGIN=(1,5,CH,EQ,C'BEGIN'), PUSH=(81:SEQ=8)) SORT FIELDS=(81,8,...
- Mon Aug 22, 2016 10:21 pm
- Forum: Interview Questions.
- Topic: Execute a specific step in a JCL.
- Replies: 14
- Views: 2659
Re: Execute a specific step in a JCL.
10543 COND=(0,LE) is like, if the RC of the previous step is less than 0 don't execute "step13", which is not possible. So agree step13 would execute but rest of the steps will also execute. I was not supposed to execute step15, step15... As Robert mentioned When I mention COND on JOB par...
- Mon Aug 22, 2016 9:38 am
- Forum: Introduce Yourself and Share Your IT Experience.
- Topic: Rohit Umarjikar-Introduction :-)
- Replies: 4
- Views: 610
Re: Rohit Umarjikar-Introduction :-)
Welcome Rohit and Nice to see you here..you will find quite familiar names here
You had a good exposure and surely it will be a help to people here
Thanks,
Chandan
You had a good exposure and surely it will be a help to people here
Thanks,
Chandan
- Fri Aug 19, 2016 5:51 pm
- Forum: Interview Questions.
- Topic: Execute a specific step in a JCL.
- Replies: 14
- Views: 2659
- Wed Aug 17, 2016 11:39 pm
- Forum: Interview Questions.
- Topic: Execute a specific step in a JCL.
- Replies: 14
- Views: 2659
Re: Execute a specific step in a JCL.
Hi,
Just adding one more way to Akatsukami..
Codeon Job card
Just adding one more way to Akatsukami..
Code
Code: Select all
Restart =STEP13,COND=(0,LE)
- Wed Jul 27, 2016 11:46 am
- Forum: Interview Questions.
- Topic: Code a step in a JCL so that it actually never executes.
- Replies: 4
- Views: 804
Re: Code a step in a JCL so that it actually never executes.
Having COND=(0,LE) on corresponding step will suffice for bypassing the step
Thanks and regards,
Chandan
Thanks and regards,
Chandan
- Fri Jul 15, 2016 12:39 am
- Forum: Introduce Yourself and Share Your IT Experience.
- Topic: This is Harsimran Sing working in IBM from 2011.
- Replies: 10
- Views: 869
Re: This is Harsimran Sing working in IBM from 2011.
Welcome to Forum Richie