Archives of the TeradataForum

Message Posted: Mon, 23 Jun 2008 @ 08:28:50 GMT

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

Sridhar.S

Your import and using clauses need to match the record format and layout of your import file.

Depending on if you are running on channel-attached or network attached, your bteq needs to be modified as:

     --channel-attached (format=data, layout=6 bytes record)
     .import data file=in_condition.out
     .repeat 2
     using dno (char(3)) ,filler1 (char(3))
     sel * from department where deptno = :dno
     ;


     --network-attached (format=report, layout=6 bytes record)
     .import report file=in_condition.out
     .repeat 2
     using dno (char(3)) ,filler1 (char(3))
     sel * from department where deptno = :dno
     ;

Regards

Jonas Blomqvist

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