I am using TD automation and setting a variable (IDNoVar) that happens to be a number (00001234). My export returns 0 records because TD is stripping these leading zeroes. The variable is set to a STRING data type. The export SQL is to Teradata and the where clause is trim(IDNo) = trim(:IDNoVar). The IDNo column is Varchar(8). When the automation executes TOAD sets this IDnoVar to ‘1234’.
Any ideas on how to solve this issue?
Thanks for your help.