Q
Problem solve Get help with specific problems with your technologies, process and projects.

Displaying data during a conversion of the Customer Information System

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:

RUNQRY QRY(*NONE)
QRYFILE((ORIGFILE))
OUTTYPE(*OUTFILE)
OUTFILE(TEMPLIB/TEMPFILE)

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.


This was last published in May 2004

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close