Hello all,
We have a legacy process that requires Client Access File Transfer, DOS batch scripting, and ancient Lattice programs, to move files from S/36EE (record len=175) to a Native library (record len=200) to a PC DBF file(record len=200).
This is processed manually within a software package that requires a DBF file.
Then the scripted process takes the altered DBF file to a txt file (via Lattice-all the header data is removed) back to Native (record len=177) then across to the S/36EE (record len=177) again.
For multiple reasons, I'm trying to recreate this process to not be PC dependent for processing, not require Lattice installed for any reason and not require the ability to run DOS batch scripts (thus not Client Access File Transfers either).
I had not believed it would be as complicated as it has turned out to be because, after quite a lot of frustration, I've come to determine that Lattice seems to have quite a lot more built in ability to handle these files that is not apparent from the prc/src files I have access to.
I've been using primarily Linoma GoAnywhere to build a new project, but have hit a roadblock with the handling of .DBF files. (It handles, flat files, fixed-width, csv and xml files, but not dbf)
So...
I'm beating my head against this, so asking anywhere I can.
Thank you!
Liz
We have a legacy process that requires Client Access File Transfer, DOS batch scripting, and ancient Lattice programs, to move files from S/36EE (record len=175) to a Native library (record len=200) to a PC DBF file(record len=200).
This is processed manually within a software package that requires a DBF file.
Then the scripted process takes the altered DBF file to a txt file (via Lattice-all the header data is removed) back to Native (record len=177) then across to the S/36EE (record len=177) again.
For multiple reasons, I'm trying to recreate this process to not be PC dependent for processing, not require Lattice installed for any reason and not require the ability to run DOS batch scripts (thus not Client Access File Transfers either).
I had not believed it would be as complicated as it has turned out to be because, after quite a lot of frustration, I've come to determine that Lattice seems to have quite a lot more built in ability to handle these files that is not apparent from the prc/src files I have access to.
I've been using primarily Linoma GoAnywhere to build a new project, but have hit a roadblock with the handling of .DBF files. (It handles, flat files, fixed-width, csv and xml files, but not dbf)
So...
- By any chance, does anyone have documentation for the old Lattice platform, specifically relating to .DBF importing/exporting/handling?
- OR has anyone tried to handle .dbf files within GoAnywhere back and forth from a PC to an iSeries?
- OR does anyone know of another way/tool that could be scripted/incorporated into automating this portion?
I'm beating my head against this, so asking anywhere I can.
Thank you!
Liz
Comment