 |
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 4 matches |
| Author | Message |
|---|---|
 Topic: Updating all columns in a table for a row |
|
| Nirav721 Replies: 6 Views: 1870 |
 Forum: Database Posted: Mon Feb 11, 2008 12:59 pm Subject: Updating all columns in a table for a row |
| Hi,
The reason why we do not want to load replace is because this module is part of batch process that will be called on per-transaction basis...This module will just get the address of the place ... |
|
| Topic: Updating all columns in a table for a row |
|
| Nirav721 Replies: 6 Views: 1870 |
Forum: Database Posted: Mon Feb 11, 2008 6:11 am Subject: Updating all columns in a table for a row |
| Thanks Chris. I will look into it. I am curious though...not that we would ever do something like this because of a huge performance hit, but would it be possible to declare temporary table, in which ... | |
| Topic: Updating all columns in a table for a row |
|
| Nirav721 Replies: 6 Views: 1870 |
Forum: Database Posted: Mon Feb 11, 2008 5:02 am Subject: Updating all columns in a table for a row |
| vkphani,
Thanks for the reply. But, I am looking for a way to avoid writing out the column names since we have some tables with upto 300 columns.....? Would you know anyway to do that? Thanks |
|
| Topic: Updating all columns in a table for a row |
|
| Nirav721 Replies: 6 Views: 1870 |
Forum: Database Posted: Sun Feb 10, 2008 3:30 am Subject: Updating all columns in a table for a row |
| I am wondering if there is a way to update all columns for a particular row excluding the key without having to actually specify all column names within the SET clause? The data would be coming in fro ... | |
All times are GMT - 5 Hours |