The CreateiSeriesDataBaseFile method generates
a new iSeries database file based on the settings passed into this
method.
- Syntax
- object.CreateiSeriesDataBaseFile( FileName, FileType,
FDFName, DateFormat, DateSeparator, TimeFormat, TimeSeparator, DecimalSeparator,
FirstRowFieldNames, *Fields, iSeriesFile, Description)
- Parameters
- FileName
- Data type: String
- The local
file name used as the source file.
- FileType
- Data type: Long
- The type of
data stored in the local PC file name. The available values are:
| Value |
Description |
| 0 |
ASCII |
| 1 |
Basic Sequential |
| 2 |
CSV |
| 3 |
DIF |
| 4 |
DOS Random |
| 5 |
No Conversion |
| 6 |
Tab Delimited |
| 7 |
BIFF8 (XLS) |
- FDFName
- Data type: String
- The local FDF
file name that will be created.
- DateFormat
- Data type: Long
- The available
values are:
| Value |
Description |
| 0 |
[DMY] Day/Month/Year |
| 1 |
[EUR] European |
| 2 |
[ISO] International Standards Organization |
| 3 |
[JIS] JIS |
| 4 |
[JUL] Julian |
| 5 |
[MDY] Month/Day/Year |
| 6 |
[USA] USA |
| 7 |
[YMD] Year/Month/Day |
| 8 |
[HMS] Hours/Minutes/Seconds |
- DateSeparator
- Data type: Long
- The available
values are:
| Value |
Description |
| 0 |
[ ] Blank |
| 1 |
[,] Comma |
| 2 |
[.] Period |
| 3 |
[/] Slash |
| 4 |
[-] Dash |
- TimeFormat
- Data type: Long
- The available
values are:
| Value |
Description |
| 0 |
[EUR] European |
| 1 |
[HMS] Hours/Minutes/Seconds |
| 2 |
[ISO] International Standards Organization |
| 3 |
[JIS] JIS |
| 4 |
[USA] USA |
- TimeSeparator
- Data type: Long
- The available
values are:
| Value |
Description |
| 0 |
[ ] Blank |
| 1 |
[,] Comma |
| 2 |
[.] Period |
| 3 |
[:] Colon |
- DecimalSeparator
- Data type: Long
- The
available values are:
| Value |
Description |
| 0 |
[,] Comma |
| 1 |
[.] Period |
- FirstRowFieldNames
- Data type: Long
- Set
to true if the first row of the source file includes Field Names.
Not used for all file types.
- Fields
- Data type: IFields
- A Fields Object
that describes the field types for the source file.
- iSeriesFile
- Data type: String
- The new
iSeries database that will be generated on the host. For example,
Library/File.
- Description
- Data type: String
- Text that
describes the iSeries Database on the host.
- Returns
- Data type: Long
If the method is successful, the return value
is 0. To get the error message, use the ErrorMessage property.
Refer to ErrorMessage property for
more information.