I am trying to run a FastExport script in which data is extracted from the table using the WHERE clause. Now in the WHERE clause there is a VARCHAR column. For extraction I have defined the fields in the LAYOUT using FIELDS and FILLER.
Like, in the Teradata Database table there is a VARCHAR (128) column ACCOUNT_NAME which I am using in the WHERE clause. I am giving 6 characters in the input file and the remaining are spaces. So I define this in the LAYOUT as follows: