This appendix contains the topic:
Run the FASTR version with the following information specified in the corresponding fields on the Override Default Information form:
Field | Information |
---|---|
PC Download File | Y |
Member Name | (your name, initials, or version name) |
Library Name | (a valid library name). If left blank, the system will create a file in QGPL |
When the version finishes running, resubmit it by entering an 8.
Press Enter.
This reformats the version that you created in step 1 ,and saved to disk file F8309, into an EBCDIC format.
(Optional) You should have a file prepared to be converted to ASCII. You can view this file by entering the following commands:
Prompt | Value |
---|---|
Command entry | DSPPFM |
File | FASTR form ID (e.g. GENERAL) |
Library | QGPL (or whatever library was specified in the library field) |
Member | Version identifier (e.g. XJDE0001) |
Press F4.
If the file is there and resembles the version that you submitted, proceed to step 6; otherwise, return to step 1.
You are ready to use the PC support product to create the transfer.
Transferring the Data via your PC Support Product
Access your PC support product. The following instructions are for IBM Client Access on a Windows NT 4.0 platform.
Double click on the selection Data Transfer from AS/400.
AS/400 System Name: Type your system name (e.g., JDEG1)
File Name: Click on Browse and select -
Library/Form Name/(Version Name) (e.g., QGPL/TEACHER(XJDE0001)
PC Output Device: File
Select the subdirectory and file name with a .prn extension where you want this file to reside on your PC.
Click Transfer Data From AS/400.
A window appears with the message: Receive completed successfully.
Lotus Instructions
Once in Lotus, press F9 to retrieve options. Choose the following:
F - File
I - Import (Do not use R - retrieve)
N - Numbers (Do not use T - text)
Follow the standard procedures for creating a Lotus spreadsheet.
Excel Instructions
Once in Excel, click the File/Open button.
Find your file with the .prn extension in the subdirectory and open it.
In the text Import Wizard Step 1 of 3 window, select the following settings:
Delimited
File Origin = DOS or OS/2 (PC-8)
Click Next.
In the text Import Wizard Step 2 of 3 window, select the following options:
For Delimiters, select comma only
Text Qualifier: '"
Click Next
In the Text import Wizard step 3 of 3 window, select the following options:
Column Data Format: General
Click Finish.
Organize the data as needed.