Author |
Message |
Topic: What is whacky with this query (Update + select) |
Mukunda
Replies: 5
Views: 2922
|
Forum: 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  |
Topic: What is whacky with this query (Update + select) |
Mukunda
Replies: 5
Views: 2922
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: Utilities Posted: Thu Jun 02, 2005 4:12 pm Subject: Unpacking 9 byte packed decmial |
Thanks a lot, Kolusu. It works fine  |
Topic: Unpacking 9 byte packed decmial |
Mukunda
Replies: 5
Views: 6556
|
Forum: 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? 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
|
Forum: 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.  |
Topic: Can I create a +1 version (relative #) of GDG with Rexx? |
Mukunda
Replies: 6
Views: 5408
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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  |
Topic: Routing SYSOUT to a dataset and also to spool - Possible? |
Mukunda
Replies: 5
Views: 5331
|
Forum: 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
|
Forum: 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, ... |
|