On 12/3/2014 3:39 PM, Graves, Chuck wrote:
After more "testing" I have determined is that I CAN clear an entire iSeries file with this statement:

DELETE FROM LS_ISERIES.S650CC6F.RODDATEST.PNMAST_E

After which I can INSERT new data

But this statement fails:

DELETE FROM LS_ISERIES.S650CC6F.RODDATEST.PNMAST_E where BHBTNO = @Batch_Number

I assume that the failure means 'appears to work but the row is not
deleted', because I think that if you had an error message you'd have
included that. So, it seems likely that your statement is executing and
not finding any rows to delete.

Check the contents of @Batch_Number and make sure it exactly matches the
contents of one or more rows. By exactly, I mean length, format and
contents. Double check your assumption that there is a row to be
deleted by doing a count(*) of the rows with the same WHERE clause.


This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].