Author |
Message |
Topic: JCL to Pass Command REXX Program |
jayram99
Replies: 2
Views: 2475
|
Forum: TSO and ISPF Posted: Fri Sep 03, 2021 9:07 am Subject: JCL to Pass Command REXX Program |
Thanks Kolusu . |
Topic: JCL to Pass Command REXX Program |
jayram99
Replies: 2
Views: 2475
|
Forum: TSO and ISPF Posted: Wed Sep 01, 2021 8:23 pm Subject: JCL to Pass Command REXX Program |
Hi ,
I need help from REXX Experts to Automate Script since this is first time I'm working on the REXX.
We got REXX Programs from Vendor and need to execute the Program by passing export com ... |
Topic: Parameterize Dataset Name |
jayram99
Replies: 9
Views: 9420
|
Forum: Job Control Language(JCL) Posted: Tue Dec 10, 2019 1:34 pm Subject: Parameterize Dataset Name |
Thanks Kolusu for all your help.
Jayaram |
Topic: Parameterize Dataset Name |
jayram99
Replies: 9
Views: 9420
|
Forum: Job Control Language(JCL) Posted: Mon Dec 09, 2019 8:22 am Subject: Parameterize Dataset Name |
This topic was initiated by me 5 years ago and both are related. Thought of continuing .
Please let me know if you want to start new topic and it is not JCL Question and it should be part of UTILI ... |
Topic: Parameterize Dataset Name |
jayram99
Replies: 9
Views: 9420
|
Forum: Job Control Language(JCL) Posted: Sun Dec 08, 2019 11:01 pm Subject: Parameterize Dataset Name |
Hi Kolusu,
We receive Files as below every week and The job should automatically pick the latest Dataset and copy to new Dataset.
The below Files are in TAPE.
ABC.DEF.D1191130
ABC.DEF.D11912 ... |
Topic: Sorting Timestamp |
jayram99
Replies: 1
Views: 1530
|
Forum: Utilities Posted: Fri Jul 13, 2018 9:35 am Subject: Sorting Timestamp |
Hi All,
I need to sort duplicate records and keep the latest one record. The format of timestamp DDMMMYYYY:HH:MM:SS:NNNNNN
1234567 ABCDEF 1.00000000 . 13APR2017:00:01:43.89 ... |
Topic: Convert IMS Data Formats to DB2 Formats |
jayram99
Replies: 4
Views: 4383
|
Forum: IMS Posted: Wed Mar 29, 2017 2:42 pm Subject: Convert IMS Data Formats to DB2 Formats |
Thanks Kolusu for your reply.
Initially, This is how we did analysis and made changes to our programs.
IMS FM COBOL DB2 LENGTH
P 004 S9(6) COMP- ... |
Topic: Convert IMS Data Formats to DB2 Formats |
jayram99
Replies: 4
Views: 4383
|
Forum: IMS Posted: Tue Mar 28, 2017 9:25 pm Subject: Convert IMS Data Formats to DB2 Formats |
I am correcting Below IMS Datatypes.
Ex: N 009.
P 004.
P 003.05.
What is the max digits P 004 can store(6 or 7 or 8 Digits) and also want to know help me to find equivalent ... |
Topic: Convert IMS Data Formats to DB2 Formats |
jayram99
Replies: 4
Views: 4383
|
Forum: IMS Posted: Tue Mar 28, 2017 8:44 pm Subject: Convert IMS Data Formats to DB2 Formats |
What is the correct process to convert Segment Datatype to Table Structure.
IMS Datatype.
Ex: ZD09.
PD04.
PD03.05
What is the max value PD04 Can store and also convert ... |
Topic: Purge 60 Days of Old Data |
jayram99
Replies: 4
Views: 3801
|
Forum: Job Control Language(JCL) Posted: Thu Oct 27, 2016 1:10 pm Subject: Purge 60 Days of Old data |
Thanks Kolusu for you help.
The first part is working and could delete the data.
I couldn't delete and commit for every 5000 records.
My company DB2 version is not supporting the DELETE Stat ... |
Topic: Purge 60 Days of Old Data |
jayram99
Replies: 4
Views: 3801
|
Forum: Job Control Language(JCL) Posted: Tue Oct 25, 2016 11:24 am Subject: Purge 60 Days of Old Data |
Hi,
I need to delete 60 Days of Old Data from 42 Different Tables. Delete Query has below.
DELETE FROM DB2D.TABLE_PURGE WHERE DATE(DT_LST_UPDT) <= CURRENT DATE - 60 Days;
Everyday we rece ... |
Topic: Volume has no space. |
jayram99
Replies: 5
Views: 5258
|
Forum: Job Control Language(JCL) Posted: Wed Sep 21, 2016 12:22 pm Subject: Volume has no free space |
The Job is writing to a Dataset as below.
Output File writing to TAPE.
//OFILE1 DD,DSN=&ENV.MIS.PCWD1231.BWI0010S.OFILE1(+1),,
// DISP=(NEW,CATLG,DELETE),
// LABEL= ... |
Topic: Volume has no space. |
jayram99
Replies: 5
Views: 5258
|
Forum: Job Control Language(JCL) Posted: Wed Sep 21, 2016 10:00 am Subject: Volume has no space. |
The SAS Job while processing 4141363 records got messages as below.
ACC20210-E,REDUCES FOR DD=WORK DSN=SYS16264.T234819.RA000.PCWD1231.R1781240 VOL=WRK109,POOL=POOL9 EXT=13
ACC20502-E VOLUME HAS N ... |
Topic: Merging multiple input files |
jayram99
Replies: 3
Views: 2129
|
Forum: Utilities Posted: Wed May 11, 2016 10:17 am Subject: Merging multiple input files |
Thanks Kolusu. |
Topic: Merging multiple input files |
jayram99
Replies: 3
Views: 2129
|
Forum: Utilities Posted: Mon May 09, 2016 12:41 pm Subject: Merging multiple input files |
Please see the below details.
//JS20 EXEC PGM=SORT,REGION=0M,
// PARM='CORE=MAX,DYNALLOC=(SYSDA,25)'
//*
//SORTIN DD DSN=MIS.EXTRACT.ABCD2060.CZT,
// DISP= ... |
|