Author |
Message |
Topic: JCL to see discarded duplicate records during load |
AD7
Replies: 4
Views: 3074
|
Forum: Job Control Language(JCL) Posted: Fri Dec 15, 2006 4:00 am Subject: JCL to see discarded duplicate records during load |
I tried using ICETOOL to sort the input file and look for the duplicates - but our shop doesn't seem to have it installed, also since the number of records is HUGE, it would really be difficult to loo ... |
Topic: JCL to see discarded duplicate records during load |
AD7
Replies: 4
Views: 3074
|
Forum: Job Control Language(JCL) Posted: Fri Dec 15, 2006 12:14 am Subject: JCL to see discarded duplicate records during load |
Hi Kolusu,
Thanks for the quick reply.
I am using the following job for my load, the job loads two tables subsequently -
000017 //************************************************************ ... |
Topic: JCL to see discarded duplicate records during load |
AD7
Replies: 4
Views: 3074
|
Forum: Job Control Language(JCL) Posted: Thu Dec 14, 2006 6:38 am Subject: JCL to see discarded duplicate records during load |
Hi All,
I am trying to execute a load onto a table using DSNUTILB, however,
I am getting unique index violation errors for the load for a few records.
I need to find the records for which th ... |
Topic: Abend SB37, S04E |
AD7
Replies: 2
Views: 4914
|
Forum: Database Posted: Tue Oct 31, 2006 2:55 am Subject: Abend SB37, S04E |
@BAUER
Thank you so much!
The first load abended because the space allocated for the temporary data sets was insufficient, I had increased the parameters and re-ran the JCL.
The second abend ... |
Topic: Abend SB37, S04E |
AD7
Replies: 2
Views: 4914
|
Forum: Database Posted: Mon Oct 30, 2006 2:26 am Subject: Abend SB37, S04E |
Hi all,
I am running a load JCL for a few tables using the DSNUPROC utility.
The JCL started running properly and even loaded 2 of the tables, however when the load step for the third table came ... |
Topic: Funny Storage Group - Vanished ? What Happened? |
AD7
Replies: 0
Views: 896
|
Forum: Database Posted: Thu Oct 26, 2006 1:59 am Subject: Funny Storage Group - Vanished ? What Happened? |
Hi all,
I am trying to create a tablespace T in database D using a storagegroup G.
When I ran the DDL I got an SQL error saying that the Storage Group object did not exist.
When I chkd on t ... |
Topic: Delete a Tape Data Set ( HOW? ) |
AD7
Replies: 5
Views: 9844
|
Forum: Utilities Posted: Thu Oct 26, 2006 12:23 am Subject: Delete a Tape Data Set ( HOW? ) |
Also, can we use HDELETE for deletion of data from a tape and subsequent rewriting data onto the same tape ( I'm not sure if I am using the right terms).
Let me rephrase my question -
What does H ... |
Topic: Delete a Tape Data Set ( HOW? ) |
AD7
Replies: 5
Views: 9844
|
Forum: Utilities Posted: Wed Oct 25, 2006 11:47 pm Subject: Delete a Tape Data Set ( HOW? ) |
@Mervyn @Bill Dennis
Hey guys!
Thanks a Lot!
I wrote a jcl with the IDCAMS utility (from one of the ibm.pulib manuals).
With instream as - delete tape.data.set
so does this mean - tha ... |
Topic: Delete a Tape Data Set ( HOW? ) |
AD7
Replies: 5
Views: 9844
|
Forum: Utilities Posted: Wed Oct 25, 2006 3:23 am Subject: Delete a Tape Data Set ( HOW? ) |
Hi all,
I need to delete my tape datasets.
1. The online manuals say that I should'nt use IEFBR14 ( says it can only be used for DASD based data sets). Why?
2. It also goes onto suggest tha ... |
|