• Home
  • MAD
    • IOS Series
    • Android Series
    • Flutter Series
    • Xamarin Series
  • Concept Series
    • Software Design
    • Software Arch
    • GIT & Github
    • System Design
    • Cloud
    • Database Integration
    • Push Notification
    • API Integration
    • Cocoa PODS
  • DSA
  • Interview
  • Tips&Tricks
  • YT
  • Home
  • MAD
    • IOS Series
    • Android Series
    • Flutter Series
    • Xamarin Series
  • Concept Series
    • Software Design
    • Software Arch
    • GIT & Github
    • System Design
    • Cloud
    • Database Integration
    • Push Notification
    • API Integration
    • Cocoa PODS
  • DSA
  • Interview
  • Tips&Tricks
  • YT
  • #News
  • #APPS
  • #Events
    • #WWDC
    • #I/O
    • #Ignite
  • #Let’s Talk

MyCodeTips mycodetips-newlogocopy1

  • Home
  • MAD
    • IOS Series
    • Android Series
    • Flutter Series
    • Xamarin Series
  • Concept Series
    • Software Design
    • Software Arch
    • GIT & Github
    • System Design
    • Cloud
    • Database Integration
    • Push Notification
    • API Integration
    • Cocoa PODS
  • DSA
  • Interview
  • Tips&Tricks
  • YT
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

Liked it? Take a second to support Ranjan on Patreon!
become a patron 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)
  • More
  • Click to share on Pocket (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
Written by Ranjan - 2034 Views
Tags | DATABASE
AUTHOR
Ranjan

Namaste, My name is Ranjan, I am a graduate from NIT Rourkela. This website is basically about of what i learnt from my years of experience as a software engineer on software development specifically on mobile application development, design patterns/architectures, its changing scenarios, security, troubleshooting, tools, tips&tricks and many more.

You Might Also Like

mycodetips dotnet

Tips for Database ConnectionStrings of Various Provider

December 3, 2013
1386376017 database

Tips for Database Normalization

December 6, 2013
1386376017 database

Creating a Data File in AS400

January 18, 2014
Next Post
Previous Post

Support us

mycodetips
mycodetips

Follow us @ LinkedIn 2850+

Subscribe for updates

Join 8,213 other subscribers

Latest Posts

  • YT-Featured-solidprinciples
    SOLID Principles of Software Design
  • IOS 16 Features
    Latest features in IOS 16
  • r-language
    How can R language be used for data analysis?
  • wordpress-coding-blog
    Guide To WordPress Coding Standards
  • 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
whiteboard

Whiteboard(PRO)

whiteboard

Whiteboard(lite)

alphabets

Kids Alphabet

techlynk

Techlynk

techbyte

Do2Day

techbyte

Techbyte

  • #about
  • #myapps
  • #contact
  • #privacy
  • #Advertise
  • #myQuestions

Android Android Studio API APP Programming Apps blogging CSS DATABASE dsa Features HTML HTML5 installation Interview Questions IOS iPhone javascript Mac objective-c OS Programming quicktips SDK SEO SQL swift Tips & Tricks Tools UI Web Wordpress Xcode

  • SOLID Principles of Software Design
  • Latest features in IOS 16
  • How can R language be used for data analysis?
  • Guide To WordPress Coding Standards
  • What is Algorithm?

©mycodetips.com