|
|
|
Junior Member
 
Group: Forum Members
Last Login: 7/3/2008 3:49:29 AM
Posts: 22,
Visits: 21
|
|
Hi all
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.
Thanks
Dixon
dixon
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 11:02:22 AM
Posts: 197,
Visits: 614
|
|
Hello,
FastLoad is the utility to load data from flat-files/data-files to empty tables. You can move data between two tables using BTEQ script.
Regards,
Adeel
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 7/3/2008 3:49:29 AM
Posts: 22,
Visits: 21
|
|
Hi thanks for your reply.
how about multiload and tpump? that also loads from flat file to a table and not from table to table?
dixon
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Today @ 11:02:22 AM
Posts: 197,
Visits: 614
|
|
They are the Load-Utilities and loading a table is done from external source, normally. :)
If you want to copy one table's data to other table, you can use INSERT SELECT statement.
Regards,
Adeel
|
|
|
|