Declare Statement

[c***@hotmail.com]

If the table field type is VARCHAR and
If I wanna to declare a variable to hold this VARCHAR field.
How do I use the declare statement?

DECLARE X VARCHAR; .....?

Thanks in Advance.


. BTW, I try to look into the DB2 manual and online help.
But I cannot find anything related to this topics.
..May be I search the wrong the wrong keyword....

[Knut Stolze]

Post by c***@hotmail.com
If the table field type is VARCHAR and
If I wanna to declare a variable to hold this VARCHAR field.
How do I use the declare statement?
DECLARE X VARCHAR; .....?

DECLARE x VARCHAR(<length>)

You should probably use the same length as you have in the table definition.