I'm getting a -879 when running the CREATE DDL for a COBOL stored procedure that I wrote. The Stored procedures returns as "OUT" values all sorts of DataTypes, such as those listed below from MVS\Quickref. The procedure Binds OK. Based on the message below, it sounds like i need to see the DBA to change the "MIXED DATA install option" for this DB2 subsystem. Does this sound correct?
This sounds strange since in the Stored Procedure I do a select on a Table containing the datatypes in question (and the Table does exist).
A CREATE FUNCTION or CREATE PROCEDURE statement cannot define a
parameter or specify a RETURNS data type, for ASCII or EBCDIC data, as
CHAR FOR MIXED DATA, or GRAPHIC, VARGRAPHIC, or DBCLOB, when the MIXED DATA install option is set to NO.