1.1

}
}
else {
return val;
}
}
}
SYSCS_UTIL.IMPORT_TABLE_LOBS_FROM_EXTFILE
Use the SYSCS_UTIL.IMPORT_TABLE_LOBS_FROM_EXTFILE system procedure to import data to a table,
where the LOB data is stored in a separate file. The main import file contains all of the other data and a reference
to the location of the LOB data.
Syntax
SYSCS_UTIL.IMPORT_TABLE_LOBS_FROM_EXTFILE (
IN SCHEMANAME VARCHAR(128),
IN TABLENAME VARCHAR(128),
IN FILENAME VARCHAR(32672),
IN COLUMNDELIMITER CHAR(1),
IN CHARACTERDELIMITER CHAR(1),
IN CODESET VARCHAR(128),
IN REPLACE SMALLINT)
IN LOCKTABLE SMALLINT, IN NUMTHREADS INTEGER, IN CASESENSITIVENAMES
SMALLINT
IN IMPORTCLASSNAME VARCHAR(32672), IN ERRORFILE VARCHAR(32672))
The import utility looks in the main import file for a reference to the location of the LOB data.
Specifies the schema of the table. You can specify a NULL value to use the
default schema name. The SCHEMANAME parameter takes an input argument
that is a VARCHAR (128) data type.
SCHEMANAME
Specifies the name of the table into which the data is to be imported. This table
cannot be a system table or a declared temporary table. The string must exactly
TABLENAME
match case of the table name. Specifying a NULL value results in an error. The
TABLENAME parameter takes an input argument that is a VARCHAR (128)
data type.
Specifies the name of the file that contains the data to be imported. If the path
is omitted, the current working directory is used. The specified location of the
FILENAME
file should refer to the server side location if using the Network Server.
Specifying a NULL value results in an error. The FILENAME parameter takes
an input argument that is a VARCHAR (32672) data type.
Specifies a column delimiter. The specified character is used in place of a comma
to signify the end of a column. You can specify a NULL value to use the default
COLUMNDELIMITER
value of a comma. The COLUMNDELIMITER parameter takes an input
argument that is a CHAR (1) data type.
Specifies a character delimiter. The specified character is used in place of double
quotation marks to enclose a character string. You can specify a NULL value
CHARACTERDELIMITER
to use the default value of a double quotation mark. The
CHARACTERDELIMITER parameter takes an input argument that is a CHAR
(1) data type.
Specifies the code set of the data in the input file. The code set name should be
one of the Java-supported character encoding sets. Data is converted from the
CODESET
specified code set to the database code set (UTF-8). You can specify a NULL
vFabric SQLFire User's Guide592
vFabric SQLFire Reference