Search found 26 matches

by amolpawar
Wed Jun 29, 2016 4:30 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Migrate PDS member to DB2 structure
Replies: 0
Views: 2879

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...
by amolpawar
Wed Jun 29, 2016 4:30 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Migrate PDS member to DB2 structure
Replies: 0
Views: 1318

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...
by amolpawar
Fri Apr 11, 2014 10:37 am
Forum: DFSORT , ICETOOL & Utilities
Topic: NEED HELP IN SORT
Replies: 8
Views: 5948

Hi William,

I am trying same, by increasing the record lenth for record type 5 and sorting on extended data and as per requirement , it should work. Thank you !
by amolpawar
Fri Apr 11, 2014 10:09 am
Forum: DFSORT , ICETOOL & Utilities
Topic: NEED HELP IN SORT
Replies: 8
Views: 5948

Yes Nicc, i dont want to sort other record ( other than record type 5) on bytes 1-4.

Regards,
Amol
by amolpawar
Thu Apr 10, 2014 2:15 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: NEED HELP IN SORT
Replies: 8
Views: 5948

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...
by amolpawar
Wed Apr 09, 2014 12:08 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: NEED HELP IN SORT
Replies: 8
Views: 5948

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 ...
by amolpawar
Thu Aug 05, 2010 1:54 pm
Forum: JCL
Topic: How to generate a report.
Replies: 7
Views: 7456

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...
by amolpawar
Tue Aug 03, 2010 3:56 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Generate a report.
Replies: 2
Views: 3031

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
by amolpawar
Tue Aug 03, 2010 3:53 pm
Forum: JCL
Topic: How to generate a report.
Replies: 7
Views: 7456

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
by amolpawar
Tue Aug 03, 2010 2:01 pm
Forum: JCL
Topic: How to generate a report.
Replies: 7
Views: 7456

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
by amolpawar
Tue Aug 03, 2010 7:03 am
Forum: DFSORT , ICETOOL & Utilities
Topic: how to split file
Replies: 9
Views: 9777

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...
by amolpawar
Mon Aug 02, 2010 5:05 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: how to split file
Replies: 9
Views: 9777

Hi,

Thank You !

I have done with spliting of file using a specific keyword, but in a file instead of
' %TIMESTAMP%', I want ' current timestamp' . Is it possible using JCL?

Please help me.

Thanks,
Amol Pawar
by amolpawar
Mon Jul 26, 2010 11:21 am
Forum: DFSORT , ICETOOL & Utilities
Topic: how to split file
Replies: 9
Views: 9777

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...
by amolpawar
Fri Jul 23, 2010 3:16 pm
Forum: JCL
Topic: GENERATE IN IEBGENER
Replies: 1
Views: 2708

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...
by amolpawar
Fri Jul 23, 2010 9:28 am
Forum: DFSORT , ICETOOL & Utilities
Topic: how to split file
Replies: 9
Views: 9777

Below is the format of file. i want to seperate the file by using "table" keywords. seperate file is for each table. Table01 tablename INSERT INTO tablename( 4, 200, 'MY', '); SQLend Table02 tablename2 SQLstart INSERT INTO Vtablename2 VALUES ( 4, '2', 'P ', 200, ); SQLend SQLstart UP...