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: 1607
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: 1369
- Thu Dec 08, 2016 2:32 pm
- Forum: Introduce Yourself and Share Your IT Experience.
- Topic: Robert Sample.
- Replies: 6
- Views: 4304
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: 690
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: 2184
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: 3247
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: 700
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: 529
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: 861
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: 491
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: 491
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: 1198
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: 872
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: 1198
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: 2752
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: 618
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: 2752
- Wed Aug 17, 2016 11:39 pm
- Forum: Interview Questions.
- Topic: Execute a specific step in a JCL.
- Replies: 14
- Views: 2752
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: 817
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: 873
Re: This is Harsimran Sing working in IBM from 2011.
Welcome to Forum Richie