Toad World® Forums

Toad 6.0 LUW Bind Variables

Hi,

I noticed one issue when i try to use simple bind variables:

select TBSpace, TabSchema, TabName, Type
from Syscat.Tables
–where TabSchema = ‘SYSIBM’ and TabName = ‘SYSTABLES’
where TabSchema = ? and TabName = ?
;

With bind variables (?) there is no rows returned.

Toad is 6.0.0.373 LUW and DB2 is 9.7 FP8 DPF, PC is Win 7 x64.

On Toad 5.6.0.2916 is working as should.

Can someone try to reproduce the same? Maybe i’m just too tired today :slight_smile:

Thanks,

Ivan

Toad for LUW 6.0.0.373

Hi Ivan,

I could not recreate the problem.

How are you specifying the variables?

Adam

Hi Adam,

Just executing sql with question marks as variables from editor, then variable screen pops out and i fill in schema and table name fro variables.

The strange is that first time i used variables everything worked ok, then i started to change different schemas and table names in variable and in one moment query started to return no rows in result set grid.

If needed, i can send print-screen somewhere.

Tnx,

Ivan

Also, i see that with Colon (:variable;) and At symbol (@variable;) works ok.

Regards,

Ivan

Hi Ivan,

I’m not seeing any problems like yours. Please post screenshots or send them to me.

Thanks,

Adam

Hi,

I sent you screenshot of my editor on PM, because i am not able to paste or attach here.

Regards,

Ivan

Hi Ivan,

I still have not been able to recreate this. What DB2 client version are you using?

Also, can you give me the exact steps from starting Toad to getting the error?

Adam

Sorry. Please ignore the last post. I recreated it.

I opened TDB-1564 to track the error.

Thanks very much for your help.

Great!

Tnx Adam.