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 5 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Download records from different partitions of the table
puneet kumar

Replies: 2
Views: 3147

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

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

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

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

PostForum: 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 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group