Customizing the Display and Printer session interfaceTransfer menuBlueZone LIPI host file transfer – iSeries (5250)Creating iSeries database files

Creating iSeries database files

  1. Start a BlueZone iSeries Display session.
  2. Click Transfer → Send/Receive.
  3. From the Host File Transfer menu bar, click Transfer → Create iSeries Database File.
  4. Click Browse and locate the local file that contains the data from which the iSeries file is created and click Next.
    The File Type dialog opens. BlueZone automatically chooses the File Type based on the file structure of the database file you chose in the previous step. For example, if you chose an Excel spreadsheet, the File Type is BIFF8.
    Supported file types:
    • ASCII: A simple text file format where the records are separated by CRLF.
    • Basic Sequential: Fixed-length records; text-based file format.
    • BIFF8: The Office Open XML Spreadsheet (.XLSX); file format.
    • CSV: Comma-Separated Values; text-based file format; fields separated by comma; rows are separated by CRLF.
    • DIF: Data Interchange Format; text-based file format.
    • DOS Random: Fixed-length records; text-based file format.
    • No Conversion: The host data is stored as-is on the PC.
    • Tab Delimited: Text-based file format; fields separated by tab; rows are separated by CRLF.
  5. Click Next.
  6. Change the name of the FDF or use the default name and click Next.
  7. If necessary, change the Date, Time, and Decimal data options to match the data in your file.
  8. Click Next.
  9. Click Start Scan.
    BlueZone scans the PC data file to determine its contents. A progress bar shows the progress of the scan.

    The check box First row of data contains field names must be selected to use the first row as field names and the second row is used as the first row of data. If cleared, the first row in the PC File is used as the first row of data.

    You can skip the scan but you are prompted to continue.

    If any errors are detected, you receive an error message with a description of the error. Fix any errors and scan the file again. Keep fixing errors until the file has been scanned successfully.

  10. Click Next.
    If the file was scanned successfully, a list of configured fields displays in the File Contents window.

    You can right-click a field to edit, delete, or move the field. You can also insert new fields.

  11. To edit a field, select the field and click Details. You can edit the following options:
    • Name: Field name
    • Description: Optional description for the field
    • Type: Field type
    • Length: Number of digits or number of characters for the field
    • Allocate: Fixed length space allocated for the field for VARCHAR and VARGRAPHICS
    • Scale: Number of digits after the decimal
    • Padding: Allows for extra space in a CHARACTER or GRAPHIC field
    • CCSID: The host CCSID for the field
    • Default: The default value of the field when empty
    • Null Capable: The field can contain null values
  12. Click OK to save and close the Field Details window.
  13. When you have the necessary fields and settings, click Next.
  14. Type the iSeries file that will be created. You must have authority in the specific library. Click Next.
  15. Optional: Type an description of the iSeries file on the host. Click Next to continue.
  16. Review the settings and click Back to make any necessary changes.
  17. When the settings are complete, click Finish.
Parent topic: BlueZone LIPI host file transfer – iSeries (5250)