DB2 z/OS use of the || characters to concatenate a string.

Toad for IBM DB2
1

Has anyone run into this issue. Normally, using || between strings will concatenate them into a single string. However, when using Toad, the Characters do not seem to convert correctly and you get a -418 A STATEMENT STRING TO BE PREPARED CONTAINS AN INVALID USE OF PARAMETER MARKERS.

I know other ways around it, but I should not have to jump through hoops to get existing SQL that works on z/OS to work in Toad.

2

Hello,

ok, could be possible that exist a problem in Toad, and patch will be

released.

But, also remember that || is a SQL short cut of SQL statement CONCAT.

My suggest is try using syntax like followings:

SELECT DISTINCT

STRIP(DBNAME) CONCAT ‘.’ CONCAT STRIP(TSNAME)

FROM SYSIBM.SYSTABLES

WHERE NAME = ‘AAAAAA’ OR

NAME = ‘BBBBBB’;

SELECT

DISTINCT CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(CONCAT(

’ SELECT ‘’’,STRIP(NAME)),’’’’),’, '),

STRIP(‘COUNT(*) FROM’)),’ ‘),STRIP(NAME)),’;’)

FROM SYSIBM.SYSTABLES

WHERE CREATOR=‘my_creator’ AND TYPE=‘T’;

Cordiali Saluti, Best Regards, Bonne Réception, Mit Freundlichen Gruessen,

Venlig Hilsen, Saludos, Atenciosamente, Pokà/Met Vriendelijke Groeten

Gianfranco Casati

Certified Senior IBM System Engineer

for: zOS, DB2zOS, TCPIP, CICS, MQ, RACF, TWS, DB2LUW

IT Security is a Smart Investment

The human mind is our fundamental resource.

John Fitzgerald Kennedy

USA President

Da: “edward.j.spencer_656”

Per: ,

Data: 30/08/2016 19:18

Oggetto: [Toad for IBM DB2 - Discussion Forum] DB2 z/OS use of the ||

characters to concatenate a string.

DB2 z/OS use of the || characters to concatenate a string.

Thread created by edward.j.spencer_656

Has anyone run into this issue. Normally, using || between strings will

concatenate them into a single string. However, when using Toad, the

Characters do not seem to convert correctly and you get a -418 A STATEMENT

STRING TO BE PREPARED CONTAINS AN INVALID USE OF PARAMETER MARKERS.

I know other ways around it, but I should not have to jump through hoops to

get existing SQL that works on z/OS to work in Toad.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for IBM DB2 Forum notifications altogether.

Toad for IBM DB2 - Discussion Forum

Flag this post as spam/abuse.

3

This works file for me in Toad.

select name || ‘.’ || creator from sysibm.systables where CREATOR like ‘%POD%’

I would imagine that the error you are getting has to do with your computer’s region and language format and the code page in use in your DB2 subsystem on z/OS.

Just curious - what are those values?