Specifies the path and the name of the text fileĪnd the relative to the specified directory can be Relative path to the specified directory can beĬommand prompt and the control file, the value specified in the Records the tbLoader data loading execution Specifies the path and the name of the file that Relative path to the specified directory can be used. the path and the name of the control file thatĬontains parameter information. Specifies the Tibero database user name and password.Į.g. READSIZE, BINDSIZE, ERRORS, and ROWS parameters can be specified only from Tbloader control=sample.ctl bindsize=1000000įrom the command prompt, a user can input the metadata required for Multithread Use multi-thread for Direct Path Loading ĭpl_parallel Use Parallel Direct Path Loading Message Loading progress message to stdout v|-version Displays the version information.ĭpl_log Enable Direct Path Load logging h|-help Displays the more detailed information. The following is the format that the command If a parameter is not specified when executing the tbLoader utility, parameters can be specifiedįrom the command prompt.
The following section describes the tbLoader utility parameters that can be Separated record format has lower performance than the fixed recordįormat but has higher flexibility because the format can be modified Record is separated by the LINE TERMINATOR (record delimiter). Eachįield is separated by the FIELD TERMINATOR (field delimiter) and each Specify POSITION information for all columns in the control file. The separated record format is applied when the user does not In the example.dat file, the second line does not have The following is an example of the EOL character as a When a user does not specify the record size in the controlįile, the EOL character ('\n') is used as a delimiter. example.ctl:ħ922 MILLER 77 KING 7934 MILLER 7566 JONES The following is an example of fixed length record. If the LINES TERMINATED BY statement is used, it will be The user has to specify the record size in the control file e.g. Included in the data file has a fixed length (number of bytes). The LINES FIX statement is used when the record length Fixed Record Format - In the Case of a Fixed Length Recordĥ.10.4. Fixed Record Format - When Record Separator is EOL 5.10.3. Specifying Parameters in the Command Prompt 5.7.1. When Spaces in a Field Value Are Recognized As Data 5.7. When the Part of a Field Value Is Whitespace 5.6.3. When an Entire Field Value Is Whitespace 5.6.2. When the ESCAPED BY Option Is Not Specified 5.6.
0 kommentar(er)
