Problem with SP
Trying to execute the following statement i found in the
'Guide to SQL, Reference book' on page 8-7 using 'dbaccess'
produces:
create procedure read_address (lastname char(15))
returning char(15), char(15), char(20), char(15), char(2), char(5); define p_lname, p_fname, p_city char(15);
define p_add char(20);
define p_state char(2);
define p_zip char(5);
select fname, lname, address1, city, state, zipcode
into p_fname, p_lname, p_add, p_city, p_state, p_zip
from customer
where lname = lastname; ^cursor
return p_fname, p_lname, p_add, p_city, p_state, p_zip;
end procedure
581: Error loading message file.
Dbaccess stops with error number 581 and the cursor is
blinking at lastname.
Now my questions:
1) What is wrong with the above procedure ?
2) Which message file is missing ?
Our Configuration:
Informix Online 5.01.UD2
Informix SQL 4.11 UC1
Informix RDS 4.11 UC1
SCO 3.2.4
Thanks in advance,
Robert
--
Robert Velter Email: rv@argon.in-ulm.de
D-87727 Babenhausen Voice: 49 8333 4691