|
|
Archives of the TeradataForum
Message Posted: Fri, 29 Aug 2008 @ 15:34:10 GMT
Subj: | | Re: Change another database in FASTLOAD? |
|
From: | | krishna.kumar4 |
Hi,
after login reassign database name
Like below.
.logon 127.0.0.1/tduser,tduser
database financial;
Drop table sdw_detail_data;
create table sdw_detail_data,
no before journal,
no after journal,
no fallback protection
(
no varchar(20)
,non DECIMAL(20)
,status char(1)
)
unique primary index (no);
set record text;
define
no (char(20))
,non (char(10))
,status (char(1))
file=detail_sample1.txt;
begin loading sdw_detail_data
errorfiles sdw__detail_data_et,
sdw_detail_data_uv;
Thanks & Regards
Krishna Kumar
| |