 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 29 matches |
| Author | Message |
|---|---|
 Topic: INSERT with NESTED SELECT, for Pagination Logic |
|
| hellohatim Replies: 10 Views: 4837 |
 Forum: Database Posted: Sun Jan 11, 2009 2:47 am Subject: INSERT with NESTED SELECT, for Pagination Logic |
| Hi Kolusu!
Thanks a lot  , I will try this tomorrow and let you know the updates soon.
Thanks & Regards, |
|
| Topic: INSERT with NESTED SELECT, for Pagination Logic |
|
| hellohatim Replies: 10 Views: 4837 |
Forum: Database Posted: Mon Dec 22, 2008 8:47 pm Subject: INSERT with NESTED SELECT, for Pagination Logic |
| Thanks Nic! | |
| Topic: INSERT with NESTED SELECT, for Pagination Logic |
|
| hellohatim Replies: 10 Views: 4837 |
Forum: Database Posted: Mon Dec 22, 2008 11:10 am Subject: INSERT with NESTED SELECT, for Pagination Logic |
| Hi Kolusu,
Yes, the select query (as mentioned by you above) works fine on its own, but when I use it in the INSERT SQL statement, it does not. As I said the requirement is to selectively insert ... |
|
| Topic: INSERT with NESTED SELECT, for Pagination Logic |
|
| hellohatim Replies: 10 Views: 4837 |
Forum: Database Posted: Mon Dec 22, 2008 9:56 am Subject: INSERT with NESTED SELECT, for Pagination Logic |
| Hi All,
I am working on DB2 (ver 8 I guess!) z/OS Stored Procedures and had a requirement to insert data from one table to another. I want to select the last ten rows of the query and insert it in ... |
|
| Topic: INSERT INTO ... SELECT & Pagination logic |
|
| hellohatim Replies: 0 Views: 1598 |
Forum: Database Posted: Mon Dec 22, 2008 9:55 am Subject: INSERT INTO ... SELECT & Pagination logic |
| Hi All,
I am working on DB2 (ver 8 I guess!) z/OS Stored Procedures and had a requirement to insert data from one table to another. I want to select the last ten rows of the query and insert it in ... |
|
| Topic: Query on Self generating Identity |
|
| hellohatim Replies: 2 Views: 2780 |
Forum: Database Posted: Tue Jul 15, 2008 1:21 am Subject: Query on Self generating Identity |
| Hi,
We have a table (defination given below) when we try to insert records into it, the sequence numbers being generated are not always consecutive. They start in gaps which are not neccessaily in ... |
|
| Topic: Joining a File & a table |
|
| hellohatim Replies: 13 Views: 16653 |
Forum: Database Posted: Thu Feb 07, 2008 3:23 pm Subject: Joining a File & a table |
| The Size of the file as of now is between 50K to 100K rows, table size is same. These tables (including the project) are just 7 months old & they will grow 3-4 times in coming year or so.
Yes w ... |
|
| Topic: Joining a File & a table |
|
| hellohatim Replies: 13 Views: 16653 |
Forum: Database Posted: Thu Feb 07, 2008 3:19 pm Subject: Joining a File & a table |
| The Size of the file as of now is between 50K to 100K rows, table size is same. These tables (including the project) are just 7 months old & they will grow 3-4 times in coming year or so.
Yes w ... |
|
| Topic: Joining a File & a table |
|
| hellohatim Replies: 13 Views: 16653 |
Forum: Database Posted: Thu Feb 07, 2008 1:49 pm Subject: Joining a File & a table |
| Hi Videlord,
we do have Sort joinkeys option that we are using where appropriate, but the question of concurrency still remains. We have 1. Unload job 2. Mix n Match with Update 3. Load job ... |
|
| Topic: Joining a File & a table |
|
| hellohatim Replies: 13 Views: 16653 |
Forum: Database Posted: Thu Feb 07, 2008 1:16 pm Subject: Joining a File & a table |
| Well I dont have corresponding tables for those files. I did see something of this sort on this forum
DECLARED GLOBAL TEMPORARY TABLE. "Just how are planning on joining a table and a file?&qu ... |
|
| Topic: Joining a File & a table |
|
| hellohatim Replies: 13 Views: 16653 |
Forum: Database Posted: Wed Feb 06, 2008 7:17 pm Subject: Joining a File & a table |
| Hi,
We have a certain set of input files which need to mixed & matched with Db2 table information. Basically I can visualize this file as a table which is joined with another DB2 table on a com ... |
|
| Topic: Drastic increase in cost of Job |
|
| hellohatim Replies: 32 Views: 24107 |
Forum: Problem Determination Posted: Tue Aug 21, 2007 11:21 am Subject: Drastic increase in cost of Job |
| Hi Sharon,
Thanks for the information. Yes 128 is way too high, 6 should be more then enuff I guess. I will try these values once to check. |
|
| Topic: Drastic increase in cost of Job |
|
| hellohatim Replies: 32 Views: 24107 |
Forum: Problem Determination Posted: Mon Aug 20, 2007 1:31 pm Subject: Drastic increase in cost of Job |
| Hi Sharon,
Here are the statistics again with Elapsed time as well. For first two Cost and elapsed time contain other steps as well so cannot include them here. EXCP CONN ... |
|
| Topic: Drastic increase in cost of Job |
|
| hellohatim Replies: 32 Views: 24107 |
Forum: Problem Determination Posted: Mon Aug 20, 2007 11:54 am Subject: Drastic increase in cost of Job |
| Hi jsharon1248,
The listcat dumps are pretty big.Can you please let me know your email id so that I can mail you the dumps? Or if you need only some of the stats, I can copy paste them here. I ... |
|
| Topic: Drastic increase in cost of Job |
|
| hellohatim Replies: 32 Views: 24107 |
Forum: Problem Determination Posted: Sat Aug 18, 2007 12:52 pm Subject: Drastic increase in cost of Job |
| Hi,
I did run the original production job with 4 VSAM file but this time with the following parameters... //STEP0090.IPLANIND DD AMP=('BUFNI=128,BUFND=16,ACCBIAS=DO') //STEP0090.IZIPTM ... |
|
All times are GMT - 5 Hours |