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 17 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: 1st day of the next month for a given date
satya_mn_99

Replies: 2
Views: 1580

PostForum: Database   Posted: Mon Apr 03, 2006 3:03 pm   Subject: 1st day of the next month for a given date
Thanks much !!! for your help ....

It's working perfectly fine.....
  Topic: 1st day of the next month for a given date
satya_mn_99

Replies: 2
Views: 1580

PostForum: Database   Posted: Mon Apr 03, 2006 2:43 pm   Subject: 1st day of the next month for a given date
Hi

I would like to find the 1st day of next month for any given date using SQL. Please help me in this.

Ex :
Input : 2006-03-20

Output should be : 2006-04-01.


Thanks.
  Topic: Control break totals using SYNCSORT
satya_mn_99

Replies: 4
Views: 3303

PostForum: Utilities   Posted: Thu Feb 16, 2006 9:28 am   Subject: Control break totals using SYNCSORT
Hi Kolusu,

Could you please help on this.


Thanks in advance.
  Topic: Control break totals using SYNCSORT
satya_mn_99

Replies: 4
Views: 3303

PostForum: Utilities   Posted: Wed Feb 15, 2006 4:54 pm   Subject: Control break totals using SYNCSORT
Hi Kolusu,

this is really wonderful solution. But we have the final Data like this and there is a small change in output.



The Data finally looks like this :

PLATFORM -C 40906 20 ...
  Topic: Control break totals using SYNCSORT
satya_mn_99

Replies: 4
Views: 3303

PostForum: Utilities   Posted: Tue Feb 14, 2006 3:05 pm   Subject: Control break totals using SYNCSORT
Hi I have the data in the following format, using SORT is it possible to get the required o/p?

Platform1 Market-A 2005-01-01
Platform1 Market-A 2005-01-01
Platform1 Market-A 2005-01-01
Platform ...
  Topic: Build Include based on input parameters
satya_mn_99

Replies: 13
Views: 5454

PostForum: Job Control Language(JCL)   Posted: Thu Jan 26, 2006 3:59 pm   Subject: Build Include based on input parameters
Hi Kolusu,

It's wonderful, awesome solution you gave us. It really unbeleivable !!!!

Thanks and sorry about the confusion.
  Topic: Build Include based on input parameters
satya_mn_99

Replies: 13
Views: 5454

PostForum: Job Control Language(JCL)   Posted: Tue Jan 24, 2006 9:31 am   Subject: Build Include based on input parameters
Here is the actual scenario :

I will give the GDG base and using LIST CAT and other SORT steps I extract few GDG version based on the date criteria. Those GDG versions will be saved in a output dat ...
  Topic: Build Include based on input parameters
satya_mn_99

Replies: 13
Views: 5454

PostForum: Job Control Language(JCL)   Posted: Mon Jan 23, 2006 11:49 am   Subject: Build Include based on input parameters
Hi,

We can now forget about the Date. I have successfully extracted the required GDG's and I want to concatenate the date into a single Dateset.

Is that clear now ? Please advise.
  Topic: Build Include based on input parameters
satya_mn_99

Replies: 13
Views: 5454

PostForum: Job Control Language(JCL)   Posted: Mon Jan 23, 2006 11:30 am   Subject: Build Include based on input parameters
Hi Kolusu,

It is working perfectly as I wanted it. Thanks a lot for your help on this.

I have another question here.


I have a step like this :

//STEP0600 EXEC PGM=SORT ...
  Topic: Build Include based on input parameters
satya_mn_99

Replies: 13
Views: 5454

PostForum: Job Control Language(JCL)   Posted: Mon Jan 23, 2006 10:37 am   Subject: Build Include based on input parameters
Yes it is part of the Data.
  Topic: Build Include based on input parameters
satya_mn_99

Replies: 13
Views: 5454

PostForum: Job Control Language(JCL)   Posted: Mon Jan 23, 2006 10:23 am   Subject: Build Include based on input parameters
Input File 1:

BKUP.G0001V00 IS CREATED ON: 2005-08-12
BKUP.G0002V00 IS CREATED ON: 2005-10-02
BKUP.G0003V00 IS CREATED ON: 2005-10-02
BKUP.G0004V00 IS CR ...
  Topic: Build Include based on input parameters
satya_mn_99

Replies: 13
Views: 5454

PostForum: Job Control Language(JCL)   Posted: Mon Jan 23, 2006 10:12 am   Subject: Build Include based on input parameters
Hi,

I have a input file having 2 dates( From Date & To Date), I need to select the data based on these two dates using Include Statement. Please help on this.

Thanks.
  Topic: CA-7 schedule problem
satya_mn_99

Replies: 18
Views: 12238

PostForum: Job Control Language(JCL)   Posted: Tue Dec 06, 2005 5:30 pm   Subject: CA-7 schedule problem
Hi All,

Thanks a lot for your suggestions .... We have spoken with schedule group and we were told that there was a facility that the sencond set of jobs can be triggered after successful completi ...
  Topic: CA-7 schedule problem
satya_mn_99

Replies: 18
Views: 12238

PostForum: Job Control Language(JCL)   Posted: Tue Dec 06, 2005 4:15 pm   Subject: CA-7 schedule problem
Our schedule guys are not comfortable to keep a hold on datasets, any other solution in CA-7 ?
  Topic: CA-7 schedule problem
satya_mn_99

Replies: 18
Views: 12238

PostForum: Job Control Language(JCL)   Posted: Tue Dec 06, 2005 3:28 pm   Subject: CA-7 schedule problem
Thx, for the reply, But this doesn't solve our problem. We need some kind of solution in CA-7. We have around 60 jobs in each set, we can' t have hold on datasets like that.

Anyone have anyother i ...
 
Page 1 of 2 Goto page 1, 2  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group