MVSFORUMS.com

[sri50131]

Hello,

I am executing the following query in my Cobol pgm;

EXEC SQL
SELECT I_CONTROL, I_SYMBOL
INTO :WS-I-CONTROL, :WS-I-SYMBOL
FROM PAST0170_MASTER
WHERE N_MFG = :WS-VEH-MAKE
AND I_MODEL LIKE RTRIM(:WS-VEH-MODEL) || '%'
AND D_YEAR = :WS-VEH-YEAR
END-EXEC

This is the first time that I ever had to use like in an embedded SQL. The DB2 column I_MODEL has a length of X(61). WS-VEH-MODEL is defined as X(26), this is the Max length that WS-VEH-MODEL can receive.

When I execute the pgm, I am getting SQLCODE = +100. Am I doing anything wrong? Please let me know.

Thanks

[Bithead]

Try making WS-VEH-MODEL X(61) and replace trailing spaces with '%'.

[sri50131]

Bithead, I tried it and still am getting a +100.

[Bithead]

Sri50131,

Make sure that all trailing spaces are converted to %.