Search found 26 matches
- Wed Jun 29, 2016 4:30 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Migrate PDS member to DB2 structure
- Replies: 0
- Views: 6086
Migrate PDS member to DB2 structure
Hi, I want to migrate mainframe Assembler program from ZOS to Zlinux as Zos does not support Assembler. The Assembler modules call PDS member structure as Db2 tables( Used as Db2 tables before Db2 invention). My question : Is there any way to Run Assembler on Zlinux ? as the number of PDS members us...
- Wed Jun 29, 2016 4:30 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Migrate PDS member to DB2 structure
- Replies: 0
- Views: 4480
Migrate PDS member to DB2 structure
Hi, I want to migrate mainframe Assembler program from ZOS to Zlinux as Zos does not support Assembler. The Assembler modules call PDS member structure as Db2 tables( Used as Db2 tables before Db2 invention). My question : Is there any way to Run Assembler on Zlinux ? as the number of PDS members us...
- Fri Apr 11, 2014 10:37 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: NEED HELP IN SORT
- Replies: 8
- Views: 9469
- Fri Apr 11, 2014 10:09 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: NEED HELP IN SORT
- Replies: 8
- Views: 9469
- Thu Apr 10, 2014 2:15 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: NEED HELP IN SORT
- Replies: 8
- Views: 9469
Hi, I have a file having length 80. The file contains records with several record types i.e. 1,2,---8( One byte field only) input 1000 1 Amol 1000 2 Amit 2000 3 Sumit 2000 5 Supriya 1000 5 Rakesh 2000 6 Sarita 1000 6 satish I want above file to be sorted only for record type 5 for first 4 bytes , re...
- Wed Apr 09, 2014 12:08 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: NEED HELP IN SORT
- Replies: 8
- Views: 9469
NEED HELP IN SORT
Hi, I have a file having length 80. The file contains records with several record types i.e. 1,2,---8( One byte field only) Sample Layout 1000 1 abcd ----- 1000 2 hjaskdjk ---- 2000 3 dfjkdjf dfgfg 2000 5 abcd ----- 1000 5 hjaskdjk ---- 2000 6 dfjkdjf dfgfg 1000 6 dfjkdjf dfgfg I want above file to ...
- Thu Aug 05, 2010 1:54 pm
- Forum: JCL
- Topic: How to generate a report.
- Replies: 7
- Views: 11385
HI, I am having a cobol program in which one table gets updated. Query UPDATE ABC SET APP_CDE = '200', ROW_TM = '%TIMESTAMP%' UID = '%USER_ID%', WHERE BUS_CDE = 200; This program runs daily with different update queries I want to create a report on the basis of this query. How to get all the details...
- Tue Aug 03, 2010 3:56 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Generate a report.
- Replies: 2
- Views: 4620
Generate a report.
I am having one cobol program which executes some queries ( values hardcoded)
after execution and table updation I want to create a report which contains the query details and what all are the changes that made by query.
Please help me,
Thanks,
Amol Pawar
after execution and table updation I want to create a report which contains the query details and what all are the changes that made by query.
Please help me,
Thanks,
Amol Pawar
- Tue Aug 03, 2010 3:53 pm
- Forum: JCL
- Topic: How to generate a report.
- Replies: 7
- Views: 11385
- Tue Aug 03, 2010 2:01 pm
- Forum: JCL
- Topic: How to generate a report.
- Replies: 7
- Views: 11385
How to generate a report.
HI,
Using a cobol program i am updating some tables, I want to create a report which contains the changes made.
Please help me.
Thanks.
Amol Pawar
Using a cobol program i am updating some tables, I want to create a report which contains the changes made.
Please help me.
Thanks.
Amol Pawar
- Tue Aug 03, 2010 7:03 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: how to split file
- Replies: 9
- Views: 13431
Hi, below is my input file. Table01 table1 SQLstart INSERT INTO table1 VALUES ( 4000100, 200, '%TIMESTAMP%', '%TIMESTAMP%', 0 ), SQLend Table02 table2 SQLstart INSERT INTO table2 VALUES ( '2010', 200, '%TIMESTAMP%', '%TIMESTAMP%', ' ', '300 ', 'N', 'N'); SQLend SQLstart UPDATE table3 SET name = 'amo...
- Mon Aug 02, 2010 5:05 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: how to split file
- Replies: 9
- Views: 13431
- Mon Jul 26, 2010 11:21 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: how to split file
- Replies: 9
- Views: 13431
Hi, below is my input file. Table01 table1 SQLstart INSERT INTO table1 VALUES ( 4000100, 200, '%TIMESTAMP%', '%TIMESTAMP%', 0 ), SQLend Table02 table2 SQLstart INSERT INTO table2 VALUES ( '2010', 200, '%TIMESTAMP%', '%TIMESTAMP%', ' ', '300 ', 'N', 'N'); SQLend SQLstart UPDATE table3 SET name = 'amo...
- Fri Jul 23, 2010 3:16 pm
- Forum: JCL
- Topic: GENERATE IN IEBGENER
- Replies: 1
- Views: 4241
GENERATE IN IEBGENER
I want to split a file into varius members for certain condition. At the time of using GENERATE in IEBGENER gives following error IEB311I CONFLICTING DCB PARAMETERS Code: DATA SET UTILITY - GENERATE GENERATE MAXNAME=3,MAXGPS=2 MEMBER NAME=TAB00 RECORD IDENT=(7,'Table01',1) MEMBER NAME=TAB01 RECORD I...
- Fri Jul 23, 2010 9:28 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: how to split file
- Replies: 9
- Views: 13431