TOAD Datapoint 4.0 STRING Variable Problem with numerics

Toad Data Point & Toad Intelligence Central
1

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.

2

Try the latest Beta. I believe this is fixed.

3

I work for a very large bank - Beta software is not an option. Is there a workaround?

4

You can try concatonating a leading alpha character to your number string (i.e. A00001234) and then comparing to the right(:IDNoVar, len(:IDNoVar) - 1) to your IDNo field in Teradata. Hope that workaround works.