Toad 6.0 LUW Bind Variables

Toad for IBM DB2
1

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

2

Hi Ivan,

I could not recreate the problem.

How are you specifying the variables?

Adam

3

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

4

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

Regards,

Ivan

5

Hi Ivan,

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

Thanks,

Adam

6

Hi,

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

Regards,

Ivan

7

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

8

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

I opened TDB-1564 to track the error.

Thanks very much for your help.

9

Great!

Tnx Adam.