Declare variables in sql statement

[xgenius]

Hello,

I execute some sql request from SPUFI utility, and I need to declare variable but it return me sql error

Code: Select all

Request:
DECLARE H_D_FIN_6MOIS DATE;                                             

Result:
---------+---------+---------+---------+---------+---------+---------+-------
DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "DATE". SOME SYMBOLS THAT
         MIGHT BE LEGAL ARE: TABLE STATEMENT , . SCROLL INSENSITIVE SENSITIVE
         ASENSITIVE NO

[/code]

[Natarajan]

Try using SET command.

Code: Select all

SET H_D_FIN_6MOIS = DATE;

[xgenius]

thanks for the answer;

but it doesn't work too, it seems to be for host variable assignement. I think declaring variable is only for stored procedures isn't it?

Code: Select all

SET H_D_FIN_6MOIS = DATE;                                               00000
---------+---------+---------+---------+---------+---------+---------+-------
DSNT408I SQLCODE = -104, ERROR:  ILLEGAL SYMBOL "H_D_FIN_6MOIS". SOME SYMBOLS
         THAT MIGHT BE LEGAL ARE: :

[dbzTHEdinosauer]

I think declaring variable is only for stored procedures isn't it?

Start looking in the manuals for answers instead of incorrectly guessing.
explanation of DECLARE VARIABLE

[xgenius]

I'm not guessing, I read the documentation before but when I try the example, I got error.
In the DB2 manual they show declaring variable for stored procedure only.
This is the link where i read from http://publib.boulder.ibm.com/infocente ... lsqlpl.htm

[dbzTHEdinosauer]

You seem to stop looking when you thinkyou have an answer. You would be better off researching in the correct area, instead drawing an incorrect conclusion by looking at something else - COMPOUND STATEMENT.
This is the DB2 Vsn 9 explanation of DECLARE VARIABLE

This is Vsn 8

You were not thinking - or possibly, you just don't know very much about DB2 terms
(e.g. application program) - basic fundamentals, which leads you to incorrect conclusions, and then trying to defend them makes you look even sillier:

and

I execute some sql request from SPUFI utility, and I need to declare variable but it return me sql error

SPUFI is not using the Statement in an application program.

spend more time learning instead of defending the indefensible - i.e. your error.