RE: Changing a table to have a new column before existing columns

[rob@xxxxxxxxx]

Then use a view that doesn't include these blobs, clobs, etc.

Or join the Pluta camp and use Stored procedures instead of direct access.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"McCallion, Martin" <martin.mccallion@xxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
10/16/2003 08:51 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Changing a table to have a new column before existing columns






Zak Metz wrote:

> But the reason I replied is that a truly relational database 
> by definition has no ordering of columns or rows, so I am 
> really surprised that you care where in the table the column 
> happens to fall, and yes, I'm curious why.

Yes, good point.  The reason is that the table in question contains some
CLOBs (or they may be BLOBs, but they're definitely large objects).  The
database is accessed by a VB client and a Java server job.  Now, in the
past, our client application, at least, has had problems if the LOBs
were _not_ the last columns.  I don't remember the errors now, but they
definitely went away when we moved all the other columns to come before
the LOBs.  I don't really doubt that, with OS and driver improvements,
this would no longer be a problem; but it's a case of "once bitten,
twice shy".

Cheers,

Martin.

-- 
Martin McCallion
Senior Technical Consultant
Misys Wholesale Banking Systems
1 St George's Road, London, SW19 4DR, UK
T +44 (0)20 8486 1951
F +44 (0) 20 8947 3373
martin.mccallion@xxxxxxxxx
www.misys.com

This email and any attachments have been scanned for known viruses using
multiple scanners. We believe that this email and any attachments are
virus free, however the recipient must take full responsibility for
virus checking. This email message is intended for the named recipient
only. It may be privileged and/or confidential. If you are not the
intended named recipient of this email then you should not copy it or
use it for any purpose, nor disclose its contents to any other person.
You should contact the Misys Banking and Securities Division as shown
below so that we can take appropriate action at no cost to yourself. 

Misys Banking and Securities Division, 1 St George's Road, Wimbledon,
London, SW19 4DR, England. Email: banking.postmaster@xxxxxxxxxx Tel: +44
(0) 20 8879 1188 Fax: +44 (0) 20 8947 3373 
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.