Search found 15 matches

by SRI123
Tue Dec 10, 2013 2:25 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 tables PROGRAM VS Table COLUMNS used
Replies: 0
Views: 2112

DB2 tables PROGRAM VS Table COLUMNS used

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
by SRI123
Fri Jun 01, 2012 11:46 am
Forum: TSO, CLIST & REXX
Topic: How to disable unwanted PF keys in panel
Replies: 5
Views: 8931

I created a panel thru rexx. In that I want to do some process for PF4 and PF3. And I dont want any other key to be enabled. And even if I take this code to other system, same result should come.

I want to disable the keys in the rexx program itself.

Can some one help?
by SRI123
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
by SRI123
Tue Aug 25, 2009 6:20 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT - COUNT
Replies: 10
Views: 18227

I have SYNCSORT FOR Z/OS 1.2.3.1R
by SRI123
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...
by SRI123
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...
by SRI123
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...
by SRI123
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...
by SRI123
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...
by SRI123
Thu Aug 13, 2009 10:09 am
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT SUM
Replies: 9
Views: 16714

Thank you Frank
by SRI123
Wed Aug 12, 2009 5:21 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT SUM
Replies: 9
Views: 16714

FIELD format is ==> SV99 PD 15 2
data is like this
05
1C

06
5C
by SRI123
Wed Aug 12, 2009 4:36 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: SORT SUM
Replies: 9
Views: 16714

Thank you.
And does this sysntax is valid for packed data also? for packed I'm not getting correct output. Field declaration is S9(9).
by SRI123
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?
by SRI123
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...
by SRI123
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)