All Forums Tools
dixon 22 posts Joined 01/06
10 Jun 2008
fastload between table to table

Hi alli'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.testerrorfiles tpch.err1, tpch.err2insert 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. ThanksDixon

Dixon
Adeel Chaudhry 773 posts Joined 04/08
10 Jun 2008

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

-- If you are stuck at something .... consider it an opportunity to think anew.

dixon 22 posts Joined 01/06
11 Jun 2008

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

Adeel Chaudhry 773 posts Joined 04/08
11 Jun 2008

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

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.