Select Statement getting overridden in job variables file

Question

I'm running a tdload command using a job variables file with values :

SelectStmt = 'select * from database.tablename where column1 > 100',
SourceTdpid = 'hostid',
SourceUserName =  'username',
SourceUserPassword = 'password'
SourceTable  = 'database.tablename',
FileWriterFileSizeMax = '10M',
TargetTextDelimiter = '|'
TargetFilename = "file.csv"
FileWriterQuotedData =  "Y"

The filter clause in the select statement should return me only 39 rows,

but I'm getting all of the rows from the table in the extracted file.

How to resolve this?

What happens if you run that exact statement in SQL Assistant? — Andrew, Jul 01 '22 at 15:03
SourceTable is overriding the prior SelectStmt with a `SELECT * FROM databasename.tablename;` - don't use both — Fred, Jul 01 '22 at 15:18

score 0 · Answer 1 · answered Jul 01 '22 at 15:20

0

Had to use ExportSelectStmt instead of SelectStmt

answered Jul 01 '22 at 15:20

krx

85
1
7

1

And the specific operator-prefixed variable overrides both generic ones (SourceTable and SelectStmt). – Fred Jul 01 '22 at 15:37

Select Statement getting overridden in job variables file

1 Answers1