Search found 109 matches

by Veera
Mon Apr 16, 2007 10:53 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Updating a Table?
Replies: 4
Views: 8646

SPUFI should handle all SQL DB operations provided the user has access.
not sure on other tools never been there. But i guess others should
also be able to handle.

Thanks,
Veera.
by Veera
Sun Apr 15, 2007 11:18 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Set Return Code using DFSORT
Replies: 12
Views: 27497

Thanks Frank , Ok so with ICETOOL it can be handled with EMPTY file thru COUNT and by setting the RC appropriately we can achieve the solution of setting RC = 1234 or any userdefined value with combination of ICETOOL and a DUMMY COBOL PGM. Rest is upto Raveendra how he goes about it. Thanks, Veera.
by Veera
Sun Apr 15, 2007 12:47 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Set Return Code using DFSORT
Replies: 12
Views: 27497

Raveendra, Just a taught .... If u r sure that file will never be empty , i.e file will atleast contain the hearder and trailer even if it doesnt contain any records then u can set the rc to empty file condition and then run the cobol dummy step..Well even if u code a complete cobol pgm and if the f...
by Veera
Sun Apr 15, 2007 12:34 am
Forum: COBOL
Topic: SORT verb - help
Replies: 12
Views: 18555

Dani

You can post in Utilities and please note that put ur code and your
requirement clearly. Also give details about ur file attributes
layouts and the fields postion you want to merge.

Thanks,
Veera.
by Veera
Fri Apr 13, 2007 11:23 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 table -selective download to a flat file
Replies: 4
Views: 10144

Rinu, I have Agent DB2 table& a Transaction file. The transaction file has a field Agent No. I have to query the AGENT table which consists of both agent no& Employee no, to get the Employee no corresponding to the Agent no.s in the transaction file. Is this Possible? yes it is possible. SELECT EMPO...
by Veera
Fri Apr 13, 2007 10:48 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Set Return Code using DFSORT
Replies: 12
Views: 27497

Raveendra, Here is what i have done to acheive what you said, STEP1 -> ICETOOL COUNT FROM(INPFILE) EQUAL(2) RC4 STEP2 -> DUMMY COBOL PGM WHICH WILL EXECUTE ONLY IF RC = 4. NOTE : I HAVE SET 4 , YOU CAN SET 4/ 12/16 AND YOU NEED TO BE CAREFUL AND ENSURE THAT YOU WILL NOT GET THOSE RETURN CODES IN ANY...
by Veera
Fri Apr 13, 2007 8:20 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Set Return Code using DFSORT
Replies: 12
Views: 27497

Raveendra, As u said in ur first post looks like RC Can be used to set RC=12, RC=4 or RC=0. I am not sure if we can set user defined RC. Well i will try to get back if there is any means to do it. STEP001 EXEC PGM=ICETOOL ************************************************** TOOLMSG DD SYSOUT=* DFSMSG ...
by Veera
Fri Apr 13, 2007 7:51 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Set Return Code using DFSORT
Replies: 12
Views: 27497

Raveendra, Do you just want to set the RETURN-CODE if the record count = 2 , Assumption: ********** you does not want to check if the 2 records are header and trailer. Ok lets assume the file always contians header and trailer. So if we have 2 records then it means only header and trailer. And do yo...
by Veera
Fri Apr 13, 2007 1:58 am
Forum: JOB DISCUSSION
Topic: career option ?
Replies: 2
Views: 5737

Richard, Well you are an Applications Programmer. Database Administrator profilewill be different in terms of the nature of the job one performs.Like mostly DB Administrators will be resposible for handling the database of the system. I mean DDL(DATA DEFINIATION ) it involves creating TABLES , TRIGG...
by Veera
Thu Apr 12, 2007 2:40 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: PACKAGE VS PLAN ?
Replies: 7
Views: 22467

Chandra, When you say bind package into a plan to make packages executable, only those executable gets stored in a plan. only those executable gets refreshed and stored in a plan apart from the other executables without any change. I mean it has all the executables old and latest for which updations...
by Veera
Thu Apr 12, 2007 1:44 am
Forum: TSO, CLIST & REXX
Topic: REXX ROUTINE for GDG files create date Vs Curr Date
Replies: 0
Views: 3069

REXX ROUTINE for GDG files create date Vs Curr Date

The below post is in JCL forum something related to REXX, so i taught could be useful for some one if they have similar requirement.

REXX ROUTINE for GDG files create date Vs Curr Date

http://www.ibmmainframeguru.com/Mainfra ... =3924#3924


Thanks,
Veera.
by Veera
Thu Apr 12, 2007 1:37 am
Forum: JCL
Topic: Is there an IEB utility or some trick in JCL to examine. . .
Replies: 4
Views: 10591

acevedo -> Yes i accept what you said is correct. Using REXX it can be done.My Intention of quoting reg the LISTCAT was i taught there is a way to hadnle using it nothing else :) Well seagreg, Here is the code for acheving what you have asked for using REXX. Before that few points to be noted , as i...
by Veera
Thu Apr 12, 2007 1:24 am
Forum: COBOL
Topic: SORT verb - help
Replies: 12
Views: 18555

Yeah Dave , lets wish his assignment goes well.

Thanks,
Veera.
by Veera
Wed Apr 11, 2007 5:08 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: VSAM LDS used in DB2
Replies: 1
Views: 7459

Chandra, For DB2 tablespace why LDSS vsam is used because of Extent consolidation i guess. At the physical level, in DB2 each tablespace is stored in a pageset, which consists of one or multiple VSAM ESDS data sets or LDSs. Extent consolidation z/OS consolidates adjacent extents for VSAM SMS managed...
by Veera
Wed Apr 11, 2007 4:32 am
Forum: COBOL
Topic: SORT verb - help
Replies: 12
Views: 18555

laifas, prof is not good at explaining things :) :) :) , Well we cant blame them. Here is the code. 000100******************************************************************00000100 000010 IDENTIFICATION DIVISION. 000300******************************************************************00000300 000400...