Helllo Jim,

Am 13.01.2020 um 17:20 schrieb Jim Franz <franz9000@xxxxxxxxx>:

I need to update text files received for import (not a database file) in
the IFS with only sql (the text files were generated weeks ago, cannot be
regenerated, and a two byte column needs to be updated before processing if
value = 99). I don't have an option to do an emergency release of program
code to fix it (at least not easily), but I can execute sql script with a
simple approval.
Is such a thing possible? It is many files (20 or so) and approx 100,000
rows per file.


To my knowledge there is no facility in IBM i for doing what you want.

There are solutions for other platforms, though:
https://web.synametrics.com/plaintextfiles.htm
https://drill.apache.org/docs/querying-plain-text-files/

But I think this is not what you need, because not on i, AFAIK.

I don't think there are fast and easy solutions to this and thus the emergency release is the only way I see. At least when considering the available options what you actually are allowed to do with these files.

That could be a good chance to ask the right persons if some company-internal rules are a bit too strict. ;-)

:wq! PoC

PGP-Key: DDD3 4ABF 6413 38DE - https://www.pocnet.net/poc-key.asc



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

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