• Home
  • Troubleshoot
  • #Example
    • C
    • C++
    • Python
    • R-Programming
  • DSA
  • Quiz
  • Tutorial Videos
  • Home
  • Troubleshoot
  • #Example
    • C
    • C++
    • Python
    • R-Programming
  • DSA
  • Quiz
  • Tutorial Videos
  • #Deals
  • #News
  • #WiKi
  • #APPS
  • #Events
    • #WWDC
    • #I/O
    • #Ignite
  • #Let’s Talk

MyCodeTips mycodetips-newlogocopy1

  • Home
  • Troubleshoot
  • #Example
    • C
    • C++
    • Python
    • R-Programming
  • DSA
  • Quiz
  • Tutorial Videos
Database

How to Create an iSeries Database File

How to Create an iSeries Database File

Procedure

Launch a BlueZone iSeries Display session.

From the BlueZone MenuBar, choose Transfer:Send/Receive. The BlueZone Host File Transfer desktop user interface will launch.

From the Host File Transfer MenuBar choose Transfer:Create iSeries Database File or, click the Create iSeries Database File icon located on the Host File Transfer Toolbar.

The PC File Name dialog will be displayed. Browse to the PC file that contains the data from which the iSeries file will be created and click the Next button.

The File Type dialog will be displayed. BlueZone will automatically choose 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 will be 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 Binary Interchange File Format is used by Microsoft Excel (.XLS); binary based 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

Click the Next button.

The FDF File Name dialog will be displayed. Choose the name of the FDF file or use the default name and click the Next button.

The Data Options dialog will be displayed.

Select the Data Options that match the data in your file.

Date

Date Format:

[DMY] Day/Month/Year
[EUR] European
[ISO] International Standards Organization
[JIS] JIS
[JUL] Julian
[MDY] Month/Day/Year
[USA] USA
[YMD] Year/Month/Day

Date Separator: Not used in all Date Formats

[] Blank
[,] Comma
[.] Period
[/] Slash
[-] Dash

Time

Time Format:

[EUR] European
[HMS] Hours/Minutes/Seconds
[ISO] International Standards Organization
[JIS] JIS
[USA] USA

Time Separator: (Not used in all Time Formats)

[] Blank
[,] Comma
[.] Period
[:] Colon

Decimal

Decimal Separator:

[,] Comma
[.] Period

Click the Next button.

Click the Start Scan button. BlueZone will scan the PC data file to determine its contents. A progress bar will show the progress of the scan.

Recommended Reading: TIPS FOR DATABASE NORMALIZATION

The checkbox “First row of data contains field names” should be checked to use the first row as field names and the 2nd row will be used as the first row of data. If unchecked the first row in the PC File will be used as the first row of data.

You can skip the scan but you will be prompted to continue.

If any errors are detected, you will 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.

Click the Next button.

The File Contents dialog will be displayed. This dialog is used to configure all the database fields. If the file was successfully scanned then there should be a list of fields already configured for you.

The Details button will show a dialog with selected field’s information.

Name: Field Name

Description: Optional description for the field

Type: Field Type

BIGINT
CHARACTER
DATALINK
DATE
DECIMAL
DOUBLE
GRAPHIC
INTEGER
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP
UNICODE
VARCHAR
VARGRAPHIC

Length: Number of digits or number of characters for the field

Scale: Number of digits after the decimal

CCSID: The host CCSID for the field

Default: The default value of the field when empty

Allocate: Fixed length space allocated for the field for VARCHAR and VARGRAPHICS

Padding: Allows for extra space in a CHARACTER or GRAPHIC field

Null Capable: The field can contain null values

In addition, you can bring up a pop-up menu if you “right mouse click” on any of the entries as shown here:

Recommended Reading:TIPS FOR PERFORMANCE TUNING OF DATABASES

The pop-up menu will allow you to perform additional operations on the entries like inserting new fields, deleting entries, moving entries up or down.

When you are ready, click the Next button.

The iSeries Library/FileName dialog will be displayed. Enter the iSeries File that will be created. You must have authority in the specific Library. Click the Next button.

The File Description Text dialog will be displayed. This is optional. If desired, enter text that describes the iSeries file on the host. Click Next to continue.

The Confirm Settings dialog will be displayed. If any of these settings are not correct, click the Back button to back and make any necessary changes. When you are satisfied with the settings, click the Finish button

  • Click to share on Reddit (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Pocket (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
Written by Ranjan - 1865 Views
Tags | DATABASE
AUTHOR
Ranjan

I m Ranjan and Sharing my years of experience in Software Development. Love to code in Mobile apps (IOS, Android, Power Apps, Xamarin, Flutter), Machine Learning ( Beginner ), Dot Net, Databases ( SQL Server, MySql, SQLite), WordPress, Cloud Computing ( AWS, Azure, Google, MongoDB) and many more as required on project-specific. Besides this love to travel and cook.

You Might Also Like

mycodetips dotnet

Tips for Database ConnectionStrings of Various Provider

December 3, 2013
1386376017 database

Creating a Data File in AS400

January 18, 2014
1386376017 database

Tips for SQL Query Optimization

December 5, 2013
Next Post
Previous Post

Subscribe for updates

Join 6,916 other subscribers

whiteboard

Whiteboard(PRO)

whiteboard

Whiteboard(lite)

alphabets

Kids Alphabet

techlynk

Techlynk

techbyte

Do2Day

techbyte

Techbyte

Latest Posts

  • YT-Featured-Algorithm
    What is Algorithm?
  • Frameworks of IOS
    Frameworks of IOS – Part ( I )
  • NSFileManager or NSPathUtilities
    NSFileManager or NSPathUtilities in Objective-C
  • Passing data between view controllers in Objective-C
    Passing data between view controllers in Objective-C
  • structures-classes-enum
    Structures and Classes in swift !
  • control-system-swift
    Control Flow in Swift
  • swift-concurrency-await
    Concurrency in Swift
  • time-complexity-dsa
    The Term Time Complexity in DSA
  • objective-c-datatypes1
    Objective-C Data Types
  • Convert-jpeg-word
    Convert JPG to Word – Tips You Should Try!

Quick Links

  • #about
  • #myapps
  • #contact
  • #privacy

Other Websites

  • #myQuestions
  • #myBhojanalaya
  • #gadgetFacts
  • #ifscCodesDB

Tag Cloud

Algorithm Android Android Studio API APP Programming Apps blogging Browser Config CSS DATABASE dsa ecommerce error Features Google IO HTML HTML5 IDE installation Interview Questions IOS iPhone javascript Mac objective-c OneDrive OS Placeholder Programming quicktips SDK SEO Settings SMO SQL swift swiftUI Teams Tips & Tricks Tools UI Web Wordpress Xcode

©mycodetips.com