Author |
Message |
Topic: Please explain what this query will do |
esaccy
Replies: 6
Views: 3711
|
Forum: Database Posted: Tue Jun 07, 2011 4:36 am Subject: Please explain what this query will do |
Hi
Moreover X is a pre-defined condition and it is correct only.This is running for years successfully |
Topic: Please explain what this query will do |
esaccy
Replies: 6
Views: 3711
|
Forum: Database Posted: Tue Jun 07, 2011 4:30 am Subject: Please explain what this query will do |
Hi
This is running successfully.
Moreover region names are there
GDB2DW2.DVDCCAR DVDCCAR
GDB2DW2.ARXIP ARXIP etc |
Topic: Please explain what this query will do |
esaccy
Replies: 6
Views: 3711
|
Forum: Database Posted: Tue Jun 07, 2011 12:44 am Subject: Please explain what this query will do |
Hi Can anybody please explain how the following db2 query works(Please mention step by step execution process)
Table names
DVDCCAR
ARXIP
IPGRP
DVDCSMY
DVDPRD1
LSPI001
GDB2DW2 is Db2 regi ... |
Topic: Delete the input file after copy |
esaccy
Replies: 3
Views: 1718
|
Forum: Utilities Posted: Wed Jun 01, 2011 5:33 am Subject: Delete the input file after copy |
I want to copy the file into an GDG.thats what i didnt go for renaming |
Topic: Delete the input file after copy |
esaccy
Replies: 3
Views: 1718
|
Forum: Utilities Posted: Wed Jun 01, 2011 4:12 am Subject: Delete the input file after copy |
Hi
I had a input file of LRECL 300 and FB type.
I want to copy this to another file of same length and after copy i want to delete the source file.
Can i do it in a ICETOOL step? |
Topic: Abend the job when trailer count is incorrect |
esaccy
Replies: 2
Views: 1712
|
Forum: Utilities Posted: Tue May 31, 2011 2:59 am Subject: Abend the job when trailer count is incorrect |
Hi
My job is having 3 steps.
My input file is of FB type and (LRECL=300)having detail records and trailer record
Trailer record is like this
TRAILER-ID X(7)
RECORD-COUNT X( ... |
Topic: Explain what ICETOOL will do for trailer count |
esaccy
Replies: 2
Views: 1942
|
Forum: Utilities Posted: Tue May 31, 2011 2:55 am Subject: Explain what ICETOOL will do for trailer count |
Hi,
Can you please explain what this JCL will do
Code:
STEP0010 EXEC PGM=ICETOOL,COND=(0,NE)
*
INCLUDE MEMBER=SLBDFSR ... |
|