Hi experts, this is the error I got while executing the fastload script
0002 .logon 127.0.0.1/dbc,
You will need the commas also, but didn't even get that far.
While the reference to "'WITH' keyword" is confusing, the 3706 error is because your BEGIN LOADING command does not include the required ERRORFILES table1, table2 clause
Thank you for your help.. It worked... :) Can you please help me with some other issues. If my file includes column header names how do i skip them so that they will not be loaded into my database. Also, is there any way i can concatenate two or more fields from my file and load it into the database with fastload. Example;
Empno, Efirstname, Emiddlename, Elastname, Deptno
Empno, Ename, Deptno
(Would I be able to concatenate first,middle, and last name field in the fastload script and load it to the ename field in my database)
Thank you for your help in advance.. :)
You can use RECORD 2; command to skip the first record.
FastLoad does not allow you to concatenate the fields or extract part of a field. You can ignore fields from the input record, but can only insert a field to a column (or substitute NULL, using NULLIF clause).
I could be wrong but I do not think the RECORD command will work with header rows.
FastLoad expects every row to have the same format, so the header rows would have to be in the same format as the data rows (which does not always happen).
TPT, on the other hand, will just blindly read until the EOR when skipping rows and not care about the content of the row. TPT can also perform concatenation of columns.