Is it possible to declare a variable in DB2400 based on external column

Vote count:

0

I was wondering if anyone knew if it was possible to have an externally described variable in a stored procedure for DB2/400?

We have quite a few stored procedures out there, and they all access a certain file. We recently went through a field expansion and V7 is throwing an SQLSTATE 1004 (variable size difference). I now need to go out and change all the procedures that reference this file and use the expanded field size for the internal variable.

Ideally, I would like to change the procedures to allow an external reference for this definition, so in the future, all I have to do is re-compile this procedure. Is this possible in DB2?

asked 38 secs ago

jgriffin

65