Author |
Message |
Topic: 1st day of the next month for a given date |
satya_mn_99
Replies: 2
Views: 1580
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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 ... |
|