Database
Specifies the name of the database that contains the table to which you are loading data.
Schema
Specifies the schema in which to load the data. Use only if the Netezza® system supports multiple schemas in a database
Table
Specifies the name of the table in which to load the data.
Bad file (bf)
Specifies the name of the nzbad file, which contains any records that cannot be loaded. The default is table.schema.database.nzbad.
Log file (lf)
Specifies the name of the nzload log file, which contains messages and errors that occurred during the load processing. The default is table.schema.database.nzlog.
Data file
Specifies the path name of the file that you want to load into the specified table, schema, and database. The data file option must be the first line of the control file, followed by list of control file options in curly braces {}. You can specify more than one data file, each with its own set of options, in the control file.
Decimal delimiter
Specifies to use a comma instead of a period as a decimal delimiter. The default delimiter is a period.
DatabaseSpecifies the name of the database that contains the table to which you are loading data.SchemaSpecifies the schema in which to load the data. Use only if the Netezza® system supports multiple schemas in a databaseTableSpecifies the name of the table in which to load the data.Bad file (bf)Specifies the name of the nzbad file, which contains any records that cannot be loaded. The default is table.schema.database.nzbad.Log file (lf)Specifies the name of the nzload log file, which contains messages and errors that occurred during the load processing. The default is table.schema.database.nzlog.Data fileSpecifies the path name of the file that you want to load into the specified table, schema, and database. The data file option must be the first line of the control file, followed by list of control file options in curly braces {}. You can specify more than one data file, each with its own set of options, in the control file.Decimal delimiterSpecifies to use a comma instead of a period as a decimal delimiter. The default delimiter is a period.
การแปล กรุณารอสักครู่..
