Browse Prior Art Database

FORCEIN Option for Database Import Utility

IP.com Disclosure Number: IPCOM000034604D
Original Publication Date: 1989-Mar-01
Included in the Prior Art Database: 2005-Jan-27
Document File: 2 page(s) / 13K

Publishing Venue

IBM

Related People

Alexander, VL: AUTHOR [+5]

Abstract

Disclosed is a control parameter option for a utility program importing data into a relational database which allows movement of database data from one codepage environment if the user chooses to do so, but guards against unintentional storage of data from different codepage environments into database tables. It permits migration of graphic data from Double-Byte Character Set databases into Single-Byte Character Set databases (which do not support graphic data). This option is the FORCEIN option. The background for this disclosure includes: . The import utility is part of a relational database software product which operates in various codepage environments, some single-byte codepage only, and in some environments allowing double-byte codepages. .

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 67% of the total text.

Page 1 of 2

FORCEIN Option for Database Import Utility

Disclosed is a control parameter option for a utility program importing data into a relational database which allows movement of database data from one codepage environment if the user chooses to do so, but guards against unintentional storage of data from different codepage environments into database tables. It permits migration of graphic data from Double-Byte Character Set databases into Single-Byte Character Set databases (which do not support graphic data). This option is the FORCEIN option. The background for this disclosure includes: . The import utility is part of a relational database

software

product which operates in various codepage

environments, some

single-byte codepage only, and in some environments

allowing

double-byte codepages.

. The FORCEIN option applies when importing foreign

data files

containing codepage identification fields. In

particular, it

has been applied to foreign data files containing

general

environment single- and double-byte code page values

and

specific single- and double-byte codepage values for

columns of

character and/or graphic data within the foreign

file.

Normally the import utility:

. terminates if an attempt is made to import a foreign

file

specifying a codepage environment different from that

of the

database being imported into.

. accepts columns of character data in the foreign

file being

imported only if the foreign column successfully

'matches' the

codepage values of the ta...