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: 11702

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: 35242

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: 35242

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: 24640

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: 13325

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: 35242

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: 35242

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: 35242

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: 7098

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: 29162

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: 3978

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: 13578

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: 24640

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: 9630

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: 24640

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...