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.
Search found 109 matches
- Mon Apr 16, 2007 10:53 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Updating a Table?
- Replies: 4
- Views: 11702
- Sun Apr 15, 2007 11:18 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Set Return Code using DFSORT
- Replies: 12
- Views: 35242
- 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...
- Sun Apr 15, 2007 12:34 am
- Forum: COBOL
- Topic: SORT verb - help
- Replies: 12
- Views: 24640
- 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...
- 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...
- 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 ...
- 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...
- 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...
- 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...
- 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.
REXX ROUTINE for GDG files create date Vs Curr Date
http://www.ibmmainframeguru.com/Mainfra ... =3924#3924
Thanks,
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...
- Thu Apr 12, 2007 1:24 am
- Forum: COBOL
- Topic: SORT verb - help
- Replies: 12
- Views: 24640
- 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...
- 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...