× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.