Author |
Message |
Topic: Download records from different partitions of the table |
puneet kumar
Replies: 2
Views: 3147
|
Forum: Database Posted: Sun Jan 12, 2003 4:40 am Subject: Download records from different partitions of the table |
Hi All,
I want to use DSNTIAUL program to download the records from the specific partitions of the table , when i give the syntax like
SELECT * FROM
TABLE NAME
WHERE COND = 1
PART 01,02;
... |
Topic: How to skip a step in the proc ?? |
puneet kumar
Replies: 4
Views: 5849
|
Forum: Job Control Language(JCL) Posted: Sat Dec 07, 2002 11:18 am Subject: How to skip a step in the proc ?? |
Hi Kolusu,
This just wanted to know whether this kind of option exists. I can very well use other options (IF or condition code check).
Thanks,
Puneet |
Topic: Calculate DB2 date 100 days prior to current date. |
puneet kumar
Replies: 16
Views: 18167
|
Forum: Database Posted: Sat Dec 07, 2002 11:06 am Subject: Calculate DB2 date 100 days prior to current date. |
Hi Kolusu,
I really appreciate for the quick response for the queries.
I tested out the queries , but it seems that the first query is working fine where we are fetching minimum date.
But the sec ... |
Topic: Calculate DB2 date 100 days prior to current date. |
puneet kumar
Replies: 16
Views: 18167
|
Forum: Database Posted: Sat Dec 07, 2002 6:38 am Subject: Calculate DB2 date 100 days prior to current date. |
Hi Kolusu,
My requirement is kind of extension to this topic.
The way we are selecting the date, 100 days prior to the current date. What will be the query if we try to get the max date and min ... |
Topic: How to skip a step in the proc ?? |
puneet kumar
Replies: 4
Views: 5849
|
Forum: Job Control Language(JCL) Posted: Sat Dec 07, 2002 5:55 am Subject: How to skip a step in the proc ?? |
Hi All,
Is there any parameter which we can specify in JCL to skip a step, just like we give for restarting from a step.
I know we can use IF statements or Return codes conditional parameters to ... |
|