We are currently engaged in a conversion of our Customer Information System, originally written in RPG for the AS/400 green-screen environment. The converted system uses ASNA AVR (Visual RPG) in a Windows environment.
The original system uses the DSPPFM command via a CL program to display data in various ?Flat Files? that have been created for various electronic exports & imports of data from/to the system.
The problem is how to now display this data for quick and easy viewing to the user within the Windows environment using Client Access or something similar. We have guaranteed that there will be no loss of function in the new system.The record lengths of a file can be up to 4000 characters, typically in CSV type files. Do you know of a way to emulate the DSPPFM command in this situation? Any help on this matter would be greatly appreciated.
You can replace DSPPFM with SQL request - i.e. do the following:
* Add an exit program to QIBM_QCA_CHG_COMMAND as follows:
ADDEXITPGM ?*EXITPNT(QIBM_QCA_CHG_COMMAND) ?*FORMAT(CHGC0100) ??PGMNBR(1) ??PGM(MYLIB/MYPGM) ?*REPLACE(*NO) PGMDTA(*JOB 20 'DSPPFM QSYS')
2. Program MYPGM in mylib will replace the DSPPFM with doing run query to the result file:
3. Your program can now issue select to templib.tempfile.
MORE INFORMATION ON THIS TOPIC
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: Tips, tutorials and more.
PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.
Dig Deeper on FTP
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.