how to pass variables into Teradata fastexport

Asked May 30 '20 at 11:22

Active May 31 '20 at 08:48

Viewed 107 times

my Bteq file code(test_bteq) is

select * from students where student.id between &start and $end.

the bteq sql is scheduled everyday and these 2 variables from 2 columns of a configuration table(tab_conf). I need to use &start and $end variables in bteq file.

edited May 31 '20 at 08:48

kadamb

1,532
3
29
55

asked May 30 '20 at 11:22

xiaojzhu

BTEQ or FastExport? – dnoeth May 31 '20 at 08:53
Teradata fastexport – xiaojzhu Jun 01 '20 at 02:13
`.ACCEPT` can read values from a file or an enviromement variable. Btw, FastExport is legacy and all new development should switch to TPT. – dnoeth Jun 01 '20 at 08:42
.ACCEPT Left,Right FROM file_test; I use this,but I got errors. – xiaojzhu Jun 02 '20 at 09:52
Which exact error messages? – dnoeth Jun 02 '20 at 21:12

how to pass variables into Teradata fastexport

0 Answers0