Author |
Message |
Topic: Access Split Databases using Easytrieve |
Siva Kumar Sunku
Replies: 0
Views: 1163
|
Forum: IMS Posted: Mon May 16, 2005 9:07 pm Subject: Access Split Databases using Easytrieve |
Hi,
I have 3 PCBs defined for same database in a PSB.
Let the Database be (DB#1),PSB(PSB#1) and PCBs be (PCB#1,PCB#2 and PCB#3).
Depending on one field in the input file, I need to use the particul ... |
Topic: Combine Different Records with Sort |
Siva Kumar Sunku
Replies: 8
Views: 5067
|
Forum: Utilities Posted: Thu May 05, 2005 8:53 pm Subject: Combine Different Records with Sort |
Hi Kolusu/Phantom/Frank,
Thanks for the support.
Thanks
Siva |
Topic: Combine Different Records with Sort |
Siva Kumar Sunku
Replies: 8
Views: 5067
|
Forum: Utilities Posted: Wed May 04, 2005 7:48 pm Subject: Combine Different Records with Sort |
Hi Kolusu/Frank,
LRECL = 80
RECFM = FB
There is no common key between the type of records. What I know is I will get 'A' type record first and 'B' type record last. Intermediate record types I ... |
Topic: Combine Different Records with Sort |
Siva Kumar Sunku
Replies: 8
Views: 5067
|
Forum: Utilities Posted: Wed May 04, 2005 2:45 am Subject: Combine Different Records with Sort |
Hi,
I have an input file, which will have different types of records. Each record type is identified from 1st Digit of the record. Record types can be 'A','F','E' and 'B'. First A - Type record will ... |
Topic: Find Character Double byte or Not |
Siva Kumar Sunku
Replies: 2
Views: 1987
|
Forum: Utilities Posted: Fri Apr 15, 2005 6:38 am Subject: Find Character Double byte or Not |
Hi,
I have a file of 360 bytes length. All these 360 characters are supposed to be Japanese Double Characters. I want to write the record if any of the character in the input is not a double byte cha ... |
Topic: SQL & Linked List Challenge |
Siva Kumar Sunku
Replies: 3
Views: 2056
|
Forum: Database Posted: Thu Mar 24, 2005 4:03 am Subject: SQL & Linked List Challenge |
#1. I have the following table, I want the result to be perculated down the hierarchy.
Table Contents
EMP_ID EMP_NAME SUPERIOR_ID
------ -------- -----------
0001 PQR NULL
0002 XYZ 0001
... |
Topic: Deletion of Datasets |
Siva Kumar Sunku
Replies: 4
Views: 6615
|
Forum: Job Control Language(JCL) Posted: Fri Nov 12, 2004 4:16 am Subject: Deletion of Datasets |
Hi,
I have a requirement to delete the Datasets which are not referenced in recent 90 days. I am using the following JCL to delete the datasets.
//STEP0100 EXEC PGM=ADRDSSU ... |
Topic: Deletion of Datasets |
Siva Kumar Sunku
Replies: 4
Views: 6615
|
Forum: Job Control Language(JCL) Posted: Thu Oct 14, 2004 11:38 pm Subject: Deletion of Datasets |
Hi Kolusu,
The following utility is working fine for Datasets on DASD.
This is not deleting the datasets which either reside on Tape or which are migrated. It just deletes the datasets on DASD.
Can ... |
Topic: Using Same GSAM Database for 10 Jobs |
Siva Kumar Sunku
Replies: 2
Views: 2155
|
Forum: IMS Posted: Thu Oct 14, 2004 9:15 am Subject: Using Same GSAM Database for 10 Jobs |
Hi,
I am using GSAM files. But According to some constraints in our system, DBA has defined only 10 Databases which we need to use as GSAM databases. Let these Databases be DDB0001,DDB0002 ..... DDB0 ... |
Topic: Selective Creation of a GDG |
Siva Kumar Sunku
Replies: 1
Views: 1383
|
Forum: Job Control Language(JCL) Posted: Mon Oct 11, 2004 7:51 am Subject: Selective Creation of a GDG |
Hi,
I have to achieve the following functionality.
1. Read a PS file. (There will be a number in the first Record of this PS file).
2. I need to write the contents of the PS file into next version ... |
Topic: GSAM datasets for datasets allocated in TAPE |
Siva Kumar Sunku
Replies: 10
Views: 6691
|
Forum: IMS Posted: Thu Oct 07, 2004 11:59 pm Subject: GSAM datasets for datasets allocated in TAPE |
Hi Kolusu,
I was unable to use BMPPROC, so I allocated the dataset using IEHPROGM.
Now my Job is running fine.
Thanks for your reply.
-Siva. |
Topic: GSAM datasets for datasets allocated in TAPE |
Siva Kumar Sunku
Replies: 10
Views: 6691
|
Forum: IMS Posted: Wed Oct 06, 2004 9:09 am Subject: GSAM datasets for datasets allocated in TAPE |
Hi,
I have a program which uses GSAM datasets. These GSAM datasets are used for output purpose only. So what I did is, in 2nd step I allocated the GSAM datasets and in the 3rd step I used them.The jo ... |
Topic: Current Position after GN/GNP calls |
Siva Kumar Sunku
Replies: 2
Views: 1862
|
Forum: IMS Posted: Thu Sep 30, 2004 11:49 am Subject: Current Position after GN/GNP calls |
Hi Bithead.
The code is working very fine.
Thanks a lot.
-Siva. |
Topic: Obtain missing Sequence# using Sort |
Siva Kumar Sunku
Replies: 1
Views: 1184
|
Forum: Utilities Posted: Wed Sep 29, 2004 8:52 am Subject: Obtain missing Sequence# using Sort |
Hi,
I have both DFSORT and SYNCSORT in my shop.
Now my requirement is I have following contents in Input File.
001ABCD
002ABCE
005MNCS
008MLKK
From positions 1 - 3 is the Serial# .
If we o ... |
Topic: Current Position after GN/GNP calls |
Siva Kumar Sunku
Replies: 2
Views: 1862
|
Forum: IMS Posted: Wed Sep 29, 2004 1:15 am Subject: Current Position after GN/GNP calls |
Hi,
I have following Requirement
Extract all the records of SDELNQCY and SFNCLTRN segments for a patricular SFNCLSUM Segment.
Database structure is as follows.
1 DBD-CMDDCYC1 SACCOUNT
2 ... |
|