Author |
Message |
Topic: Query to update the current value |
ranjit5311
Replies: 2
Views: 1575
|
Forum: Database Posted: Wed Aug 29, 2007 6:23 am Subject: Query to update the current value |
Hi All,
There are two tables;-
TAB1(LAST_KEY, UPDATED_BY)
TAB2(ADDRESS_ID,UPDATED_BY)
LAST_KEY is a dynamic field. The value keeps on increasing. My requirement is to update the LAST_KEY t ... |
Topic: count number of characters |
ranjit5311
Replies: 1
Views: 1166
|
Forum: Database Posted: Tue Aug 21, 2007 6:40 am Subject: count number of characters |
Hi,
I required to check the count of chacters present in a column's value of a table. The column is defined as char(150). So I am not able to use LENGTH funtion.
E.g:-
Column Value
--------- ... |
Topic: Listing dataset in batch mode |
ranjit5311
Replies: 1
Views: 2066
|
Forum: TSO and ISPF Posted: Wed Nov 01, 2006 8:19 am Subject: Listing dataset in batch mode |
Hi all,
I am trying to list the datasets by giving incompelte dataset name i.e using wild card as we do in ISPF 3.4. I am doing this using LMDINIT. code is as follow:-
/*REXX*/ ... |
Topic: updating many members of a PDS at a time |
ranjit5311
Replies: 2
Views: 1462
|
Forum: Job Control Language(JCL) Posted: Wed Aug 23, 2006 2:31 am Subject: updating many members of a PDS at a time |
Hi everybody,
I want to update two or more members of a PDS simultaneouly. Application program is written in COBOL. How can I do so. Please advice me.
TIA,
Ranjit Kumar |
Topic: merging GDG at end of month |
ranjit5311
Replies: 4
Views: 4204
|
Forum: Job Control Language(JCL) Posted: Wed Jun 14, 2006 10:26 am Subject: merging GDG at end of month |
Kolusu,
Nice to see ur promt reply.
According, to the soltuion above, If we run the JOB at the end of month feb then it will merge gdg vertion from JAN to Feb. But I want just the version of th ... |
Topic: merging GDG at end of month |
ranjit5311
Replies: 4
Views: 4204
|
Forum: Job Control Language(JCL) Posted: Wed Jun 14, 2006 9:30 am Subject: merging GDG at end of month |
Hi gurus,
JOB1 run daily and it create a GDG verion daily. We need to write JCl which will merge all the version created in the particular month. This job will run at the end of the month.
How t ... |
Topic: FTP using REXX |
ranjit5311
Replies: 2
Views: 1571
|
Forum: TSO and ISPF Posted: Tue May 09, 2006 5:07 am Subject: FTP using REXX |
Hi Kolusu,
Can u please post the new link. I am unable to opemn the page.
Cheers,
Ranjit Kumar |
Topic: Parallel job updating same VSAM file |
ranjit5311
Replies: 4
Views: 2635
|
Forum: Job Control Language(JCL) Posted: Wed Apr 26, 2006 1:45 pm Subject: Parallel job updating same VSAM file |
Kolusu,
I have gone through the link that u have given. It is discuss mainly on the sequential file. But here its a VSAM file. Does the shr option make a difference.
Also the last post say :-
... |
Topic: Parallel job updating same VSAM file |
ranjit5311
Replies: 4
Views: 2635
|
Forum: Job Control Language(JCL) Posted: Wed Apr 26, 2006 10:53 am Subject: Parallel job updating same VSAM file |
Hi friends,
Thanks kolusu for promt reply, can the above objective be achived by ENQ and DEQ logic. Can anyone refer the detail of ENQ/DEQ. How it locks the resourse in context of VSAM file. we r ... |
Topic: Parallel job updating same VSAM file |
ranjit5311
Replies: 4
Views: 2635
|
Forum: Job Control Language(JCL) Posted: Wed Apr 26, 2006 8:24 am Subject: Parallel job updating same VSAM file |
Hi experts,
My problem is as follow:-
There are 13 jobs which r accessing the same vsam file and udating the same VSAM file. Each job takes about 8-9 mins. So if they are run serially, then total ... |
Topic: Problem in copying GDG |
ranjit5311
Replies: 3
Views: 1518
|
Forum: TSO and ISPF Posted: Fri Apr 07, 2006 7:19 am Subject: Problem in copying GDG |
Hi Phantom,
When i am have run the REXX program through batch. Its giving the correct version.
Thanks,
Ranjit |
Topic: Problem in copying GDG |
ranjit5311
Replies: 3
Views: 1518
|
Forum: TSO and ISPF Posted: Fri Apr 07, 2006 4:51 am Subject: Problem in copying GDG |
Hi Phantom,
1. You would have seen the generations even before the REXX completed execution.
I have executed the program and seen the genertion.It is still the same thing
2. You used on ... |
Topic: Problem in copying GDG |
ranjit5311
Replies: 3
Views: 1518
|
Forum: TSO and ISPF Posted: Fri Apr 07, 2006 3:58 am Subject: Problem in copying GDG |
Hi all,
I have allocated the base GDG in the following way:
"DEFINE GDG(NAME('"SA_FILE_NAME_BASE_GDG_NEW"') ,
OWNER('KUMARRA'),LIMIT("GEN_LIMIT& ... |
Topic: How to copy all Generations from Input GDG to Output GDG |
ranjit5311
Replies: 30
Views: 22834
|
Forum: Job Control Language(JCL) Posted: Mon Mar 13, 2006 11:08 am Subject: How to copy all Generations from Input GDG to Output GDG |
Hi Kolusu,
Allocate the GDG's as shown in this post for all the available generations and then copy them
The link that u have given, discuss about the How to allocate the current vertion of G ... |
Topic: How to copy all Generations from Input GDG to Output GDG |
ranjit5311
Replies: 30
Views: 22834
|
Forum: Job Control Language(JCL) Posted: Mon Mar 06, 2006 9:13 am Subject: How to copy all Generations from Input GDG to Output GDG |
1.How can we do the same thing through the REXX program?
2. How we can use any utilities in REXX. Please explain with the sample code? |
|