Hi
Is there any way to get the list of the programs and DB2 table columns used in that program by using catalog table?
Like example:
PGM1 - EMPNO
PMG1 - EMPNAME
PGM2 - EMPNO
PGM2 - EMP-ADD
PGM2- EMP-SAL
Thanks
Search found 15 matches
- Tue Dec 10, 2013 2:25 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: DB2 tables PROGRAM VS Table COLUMNS used
- Replies: 0
- Views: 2112
- Fri Jun 01, 2012 11:46 am
- Forum: TSO, CLIST & REXX
- Topic: How to disable unwanted PF keys in panel
- Replies: 5
- Views: 8931
- Wed May 30, 2012 5:22 pm
- Forum: TSO, CLIST & REXX
- Topic: How to disable unwanted PF keys in panel
- Replies: 5
- Views: 8931
How to disable unwanted PF keys in panel
I want to disable all the keys except PF3 & PF4 in my panel. How to do this using keylist?
Thanks
Thanks
- Tue Aug 25, 2009 6:20 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT - COUNT
- Replies: 10
- Views: 18227
- Tue Aug 25, 2009 12:14 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT - COUNT
- Replies: 10
- Views: 18227
Hi Kolusu, Thank you for reply. Header consists of not only 3 records and these records not in one after the other. In between, there may be another file names. So, whenever file1 found in the file2, counts need to be copied to the next line at the same position. For the previous example, I'm gettin...
- Sat Aug 22, 2009 5:11 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT - COUNT
- Replies: 10
- Views: 18227
Ok. Lets say I got all the counts of the files and I need to format it now like this. File1 contains the file names and its count information. File2 is report, it contains the formatted input file1 information. I want to take the 1st 5 chars from the input file1 and then put the 23 chars (from 7th c...
- Fri Aug 21, 2009 11:48 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT - COUNT
- Replies: 10
- Views: 18227
Thank you frank for the reply. I am changing the requirement to make it clear: I have 100 files. I want to get the record counts from each file and write the count along with the file name in the output file. Do I need to code many steps to get the counts from each file? or any simple method by usin...
- Tue Aug 18, 2009 8:01 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT - COUNT
- Replies: 10
- Views: 18227
SORT - COUNT
Hi, I have the input file RECL=80 that contains the file name and type-2 constant, and type-3 constant. I need to read the file name between positions 1 and 21 and count the number of '2' 's in that file at position 4 and write the count of type-2 after TYPE-2= and similar way write the count of typ...
- Thu Aug 13, 2009 11:37 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT COMPARE 2 VOLUME FILES
- Replies: 3
- Views: 5578
I read the link, but I didnt get the exact scenario which I want. My requirement is like this: File1 has the 10mn records with length of 50 bytes FB. Due to some problem in the input file, I created the file again as File2. And there are no duplicates in the file. 1.Now I want to know the records th...
- Thu Aug 13, 2009 10:09 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT SUM
- Replies: 9
- Views: 16714
- Wed Aug 12, 2009 5:21 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT SUM
- Replies: 9
- Views: 16714
- Wed Aug 12, 2009 4:36 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT SUM
- Replies: 9
- Views: 16714
- Wed Aug 12, 2009 3:57 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT COMPARE 2 VOLUME FILES
- Replies: 3
- Views: 5578
SORT COMPARE 2 VOLUME FILES
Hello,
I have two files each having 50mn records. I want to compare these two, but out put should contain only the mismatch records. Can some one suggest a way?
I have two files each having 50mn records. I want to compare these two, but out put should contain only the mismatch records. Can some one suggest a way?
- Wed Aug 12, 2009 3:44 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT SUM
- Replies: 9
- Views: 16714
Thank you arcvns for qucik reply. This is working fine. My field declaration is S9(9)V99. So the out put is displaying without decimal. Can I get with decimal out put with sign like +123.45 or -123.45. And does this sysntax is valid for packed data also? for packed I'm not getting correct output. Fi...
- Wed Aug 12, 2009 12:37 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: SORT SUM
- Replies: 9
- Views: 16714
SORT SUM
I want to sum the amounts that are at position 10,12,ZD. I want to sum all the amounts. And out should contain only the total amount. I tried with the below statement, but I'm not getting the sum, it is only displaying all the records in the output. Please help me. OPTION COPY SUM FIELDS=(10,12,ZD)