Re: XML to SQL processing

My main concern is to be able to flag the record put as much data as possible into the field and continue processing without the program ending poorly.  If the record is flagged as 'Inactive' our system will continue processing untill a user can correct the record.
 
If DB2 would fill the offending field with as much data as possible and return a SQL error to Java that I could trap for then that would be perfect for me.  I haven't been able to definitively find an answer to that though.
 

Cole

I love deadlines. I like the whooshing sound they make as they fly by.
    Douglass Adams


________________________________
From: Michael Naughton <michael_naughton@xxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Sent: Friday, January 20, 2012 5:13 PM
Subject: Re: XML to SQL processing

You could also use SUBSTR, although it will return an error if the length of the field is less than the length you specify (though that can be handled using a CASE statement and LENGTH).

I wonder, though -- do you really want to just throw away whatever is at the ends of those fields?


Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx> writes:

Are you using any special scalar functions, such as the XML* genre?
Otherwise you could do something like combine LENGTH and LEFT to get what
you want.


Rob Berendt
--

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-676-3144
Internal: x 444
mnaughton@xxxxxxxxxxxx
****************************************
NOTICE: This e-mail and any files transmitted with it are confidential and solely for the use of the intended recipient. If you are not the intended recipient or the person responsible for delivering to the intended recipient, be advised that any use is
strictly prohibited. If you have received this e-mail in error, please notify us immediately by replying to it and then delete it from your computer.