Archives of the TeradataForum

Message Posted: Fri, 08 Jul 2005 @ 08:44:04 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Have this query w/o the value for sample in a file say "is.sql"

     Insert into dbs1.tbl1
     Select col1, col2, col3
       From dbs1.tbl2
     Where not col1 in
       (select col1 from dbs1.tbl1)
     Sample
     Change your script as below...
     Insert into dbs1.tbl1
     Select col1,col2, col3
       From dbs1.tbl2
     Where col3 = 'X'
     ;
     .sidetitles on
     .foldline on
     .export file=is.sql
     Select 500000-count(*) || ';' (Title '')
       From dbs1.tbl1
     ;
     .export reset
     .foldline off
     .sidetitles off
     .Quit.
     .Label restart;
     .run file=is.sql

Sanjaya

	<Prev	Next>		<<First	<Prev	Next>	Last>>