Hi all,
In my application that is generated by Clarion an SQL0418N ("A statement
contains a use of a parameter marker that is not valid.") occurs. In the
explanation section it says "in some cases as the sole argument of a scalar
function". The parameter marker is used in the UCASE function.
Is this such "some case"??
The full error provided by Clarion's trace:
Preparing Statement 1ae2350 : SELECT A.LANDCODE, A.SOORTLAND, A.LANDNAAM,
A.LANDCODE_CBS FROM MUNTSYS.LANDEN A WHERE {fn UCASE( A.LANDCODE)} >= {fn
UCASE(?)} ORDER BY {fn UCASE( A.LANDCODE)} Time Taken:0.00 secs
Setting number of rows to fetch to 20 for Statement 1ae2350 Time Taken:0.00
secs
Binding Column 1 to C type CHAR for Statement 1ae2350 Time Taken:0.00 secs
Binding Column 2 to C type UTINYINT for Statement 1ae2350 Time Taken:0.00
secs
Binding Column 3 to C type CHAR for Statement 1ae2350 Time Taken:0.00 secs
Binding Column 4 to C type SSHORT for Statement 1ae2350 Time Taken:0.00 secs
Binding ? 1 for input with C type CHAR as 1 for Statement 1ae2350 Time
Taken:0.00 secs
Executing prepared Statement 1ae2350
Error Occurred: 42610[IBM][CLI Driver][DB2/LINUX] SQL0418N A statement
contains a use of a parameter marker that is not valid. SQLSTATE=42610
--
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.***********@Askesis.nl
web: www.askesis.nl