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 26 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Query to update the current value
ranjit5311

Replies: 2
Views: 1575

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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