MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 53 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: JCL to Pass Command REXX Program
jayram99

Replies: 2
Views: 2475

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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= ...
 
Page 1 of 4 Goto page 1, 2, 3, 4  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group