i'm looking for a clarification on fastload utility. my doubt is that, is it possible to load an empty table from some other populated table?. if yes could you please give me a sample script.
i tried the following script but its not working. its throwing an error at sql statement. error is "invalid column list". i tried here with different ways to get it done but didn't worked.
logon demotdat/tpch; drop table err1; drop table err2; drop table test; CREATE TABLE test, no FALLBACK, no AFTER journal, no BEFORE journal ( start_date date NOT NULL, end_date date NOT NULL, bus_date date ); set record text; define startdate (char(8)), /*just for name sake i gave coz fload expecting this */ enddate (char(8)), busdate (char(8)) file=c:\input3.txt; /*just for name sake i gave coz fload expecting this */ begin loading tpch.test errorfiles tpch.err1, tpch.err2 insert into test(:startdate,:enddate,:busdate) sel start_date, end_date, bus_date from test_load; end loading; logoff;
i saw so many scripts that loads from flat file to empty table but not between table to table.