[Ben Michael]

Or for CSV (without quotes) I found this worked:

perl -pi -ne ‘s/n/n#n/g’ tbl

perl -pi -ne ‘s/,/n/g’ tbl

Table ended up being to big and went with SQLite as per:

https://usspvlclovertch2.infor.com/viewtopic.php?p=25470#25470

[Ben Michael]

SQLite is a good option for this.

I had a 70mb table that was way to big for .tbl or a .csv lookup.

Ended up going with SQLite which slowed down translation initially but then when I configured the value I was searching on as the primary key and with an index, 20 transactions processed at practically the same speed as what they did before the lookup was added.

[Ben Michael]

Hi There,

Does anyone have an example of TCL to dump the message ‘as is’ to a printer.

And if possible – where it fails to kick off that command dumps output in the error database.

Thanks,

Ben

[Author]

Replies