Trying to SQL data from file QSYS2/USER_INFO, and I get this error message. SQL7919. Help text for the message says the following. So how do I define this as a variable length field in my RPG program, if that is what I need to do? Thanks!
Cause . . . . . : Host variable AUTHORIZATION_NAME requires conversion. The
data retrieved for the FETCH or embedded SELECT statement can not be
directly moved to the host variables. The statement ran correctly.
The host variable requires conversion for reason 5.
-- Reason 5 - host variable AUTHORIZATION_NAME is not a variable length
string and the value being retrieved is.
Cause . . . . . : Host variable AUTHORIZATION_NAME requires conversion. The
data retrieved for the FETCH or embedded SELECT statement can not be
directly moved to the host variables. The statement ran correctly.
The host variable requires conversion for reason 5.
-- Reason 5 - host variable AUTHORIZATION_NAME is not a variable length
string and the value being retrieved is.
Comment