Re: can sql update a non database ascii text file in IFS

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