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 46 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: What is whacky with this query (Update + select)
Mukunda

Replies: 5
Views: 2922

PostForum: Database   Posted: Wed Nov 23, 2005 1:17 pm   Subject: What is whacky with this query (Update + select)
Thanks Kolusu. It works fine...I just had to take care of -407. Thanks for your time Smile
  Topic: What is whacky with this query (Update + select)
Mukunda

Replies: 5
Views: 2922

PostForum: Database   Posted: Tue Nov 22, 2005 5:36 pm   Subject: What is whacky with this query (Update + select)
Kolusu
Thanks for the quick response!
Infact, I tried that and later thought the format is inappropriate
UPDATE XXXX.TABLE1 CUSTMAST
SET CUSTMAST.END_CUST_NAME = ...
  Topic: What is whacky with this query (Update + select)
Mukunda

Replies: 5
Views: 2922

PostForum: Database   Posted: Tue Nov 22, 2005 3:19 pm   Subject: What is whacky with this query (Update + select)
Gurus of the board
I'm trying to figure out what is wrong with this query but haven't been quite successful yet. I tried searching the board. But could not get much clue either.
UPDATE TABLE1 CUSTMA ...
  Topic: Why save CPU cycle time?
Mukunda

Replies: 5
Views: 3384

PostForum: Application Programming   Posted: Tue Sep 27, 2005 1:06 pm   Subject: Why save CPU cycle time?

The only major reasons to save CPU cycles are time and money

Semigeezer, thank you for making me think in more fundamental/meaning ful ways. Often, I give me head to all meaningless jargons and b ...
  Topic: Why save CPU cycle time?
Mukunda

Replies: 5
Views: 3384

PostForum: Application Programming   Posted: Thu Sep 22, 2005 2:31 pm   Subject: Why save CPU cycle time?
Thanks Kolusu.
Reduction in the batch window and associated reduction in monitoring time were the benefits we were envisioning.
Besides, there was a thought that if the CPU gets free'ed up it might ...
  Topic: Why save CPU cycle time?
Mukunda

Replies: 5
Views: 3384

PostForum: Application Programming   Posted: Thu Sep 22, 2005 2:00 pm   Subject: Why save CPU cycle time?
Gurus of the board
We did some performance tuning for a lengthy batch job and reduced CPU cycle time by 90%. Now the management is discussing on whether to expand this to the whole application? Is th ...
  Topic: Unpacking 9 byte packed decmial
Mukunda

Replies: 5
Views: 6556

PostForum: Utilities   Posted: Thu Jun 02, 2005 4:12 pm   Subject: Unpacking 9 byte packed decmial
Thanks a lot, Kolusu. It works fine Very Happy
  Topic: Unpacking 9 byte packed decmial
Mukunda

Replies: 5
Views: 6556

PostForum: Utilities   Posted: Thu Jun 02, 2005 7:51 am   Subject: Unpacking 9 byte packed decmial
Gurus
Is there a way to unpack 9 byte packed decimal? Rolling Eyes We have syncsort, file-aid and SAS at our shop.
I understand that syncsort has a limitation of 8 bytes. I searched the help boards and c ...
  Topic: Can I create a +1 version (relative #) of GDG with Rexx?
Mukunda

Replies: 6
Views: 5408

PostForum: TSO and ISPF   Posted: Tue May 04, 2004 12:10 pm   Subject: Can I create a +1 version (relative #) of GDG with Rexx?
superk
That would solve the problem. Thanks. Smile
  Topic: Can I create a +1 version (relative #) of GDG with Rexx?
Mukunda

Replies: 6
Views: 5408

PostForum: TSO and ISPF   Posted: Tue May 04, 2004 8:45 am   Subject: Can I create a +1 version (relative #) of GDG with Rexx?
Dibakar
Thanks for your suggestions. But this still does not solve my problem. Whenever I dont write anything on to the GDG version just created, the REXX fails when it is invoked next time. In other ...
  Topic: Can I create a +1 version (relative #) of GDG with Rexx?
Mukunda

Replies: 6
Views: 5408

PostForum: TSO and ISPF   Posted: Mon May 03, 2004 8:20 am   Subject: Can I create a +1 version (relative #) of GDG with Rexx?
Thanks Superk.
Here is the piece of code that I'm using. It assumes that first version of GDG is already exists.
/* REXX*/
trace r ...
  Topic: Can I create a +1 version (relative #) of GDG with Rexx?
Mukunda

Replies: 6
Views: 5408

PostForum: TSO and ISPF   Posted: Fri Apr 30, 2004 5:27 pm   Subject: Can I create a +1 version (relative #) of GDG with Rexx?
When I tried allocating a fresh GDG version with relative number (+1), it did not seem to work. So I tried with absolute number, MY.DATASET.GnnnnVnn - and it worked.
For getting absolute number, I'm ...
  Topic: Routing SYSOUT to a dataset and also to spool - Possible?
Mukunda

Replies: 5
Views: 5331

PostForum: Application Programming   Posted: Mon Mar 01, 2004 2:58 pm   Subject: Routing SYSOUT to a dataset and also to spool - Possible?
Thanks Kolusu. The way in which you are replying the questions would make this site something of an mvschat.com Razz
  Topic: Routing SYSOUT to a dataset and also to spool - Possible?
Mukunda

Replies: 5
Views: 5331

PostForum: Application Programming   Posted: Mon Mar 01, 2004 2:41 pm   Subject: Routing SYSOUT to a dataset and also to spool - Possible?
Kolusu
Thanks for the quick pointer. There is an issue with this approach. Incase of abends, then next step would not execute.
I might have to code an IF ABEND construct and do the next step for cop ...
  Topic: Routing SYSOUT to a dataset and also to spool - Possible?
Mukunda

Replies: 5
Views: 5331

PostForum: Application Programming   Posted: Mon Mar 01, 2004 2:11 pm   Subject: Routing SYSOUT to a dataset and also to spool - Possible?
We have a job that validates some transactions. The validation program writes out the summary stats to the spool. We want to capture this in a dataset. While this can easily be done, incase of abends, ...
 
Page 1 of 4 Goto page 1, 2, 3, 4  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group