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

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

java - Android recognize cell phone with keyboard or not? -

iphone - How would you achieve a LED Scrolling effect? -