IBM Mainframe Forum

Hi all,

Please help me...

Can we define a DB2 column dynamically as below?

This works in cobol. My requirement like this 11/25/2013 + 50 DAYS = 01/14/2014

SELECT (DATE(:IN-DATE) + PERIOD_A DAYS) +
FROM TABLEX WITH UR

EX:
PERIOD_A COLUMN HAS:
--------
50


I am getting -418 sqlcode, Could you help me to fix this?

If you read and understand the first cause for SQLCODE -418, you will realize the error in your SQL.

Hello Akatsukami,

Could you please explain me to understand this parameter marker?

Raj2006 wrote:Hello Akatsukami,

Could you please explain me to understand this parameter marker?

A parameter marker is a placeholder in a SQL statement for a value obtained at run time. In dynamic SQL, the parameter marker is a question mark; in static SQL, it is the name of a host language variable prefixed with a colon.