utilities - How can I perform fastload for a file which has only one column and 'n' rows? -
i have done fastload table has more 1 column (i did vartext format ,
delimiter).
now want load file has 1 column (and 5 rows say). i'm unable , encountering below error:
i/o error on file read: 16, text: unexpected data format
my fastload script below:
sessions 5; .logon dbc/dbc.dbc; begin loading mytable errorfiles table_flet, table_fluv ; define col1_mytable (char(2)) file = c:\fload\inpt.txt; insert mytable ( col1_mytable ) values ( :col1_mytable ); end loading;
mytable structure below:
create multiset table database.mytable ,no fallback , no before journal, no after journal, checksum = default ( col1_mytable char(2) character set latin not casespecific ) primary index ( col1_mytable );
the contents of input file below:
aa bb cc dd ee
how can fastload?
done.. below script :
.logon dbc/dbc,dbc; create multiset table database.mytable ,no fallback , no before journal, no after journal, checksum = default ( col1_mytable char(2) character set latin not casespecific) primary index ( col1_mytable ); begin loading mytable errorfiles table_flet, table_fluv ; <b>set record text; </b> define col1_mytable (char(2)) file = c:\fload\inpt.txt; show; insert mytable ( col1_mytable ) values ( :col1_mytable ); end loading;
Comments
Post a Comment