FW: SPL Returning Column Names

---------- From: Charles Smith[SMTP:csmith@vsol.com] Sent: Saturday, October 05, 1996 3:07 PM To: 'Dennis Robinson' Subject: FW: SPL Returning Column Names Dennis: When you create a stored procedute the next line should look like this ' RETURNING CHAR(15), INT;' other stuff at the return should look like 'RETURN fname,nrows' Example on page 12-26 SQL Tutorial Version 7.2 Hope this helps Charles. ---------- From: Dennis Robinson[SMTP:drrobin@vsol.com] Sent: Thursday, October 03, 1996 4:06 PM To: 'Charles Smith' Subject: FW: SPL Returning Column Names can you help ---------- From: Mike Scotece[SMTP:sco@pcslink.com] Sent: Monday, September 30, 1996 9:53 AM To: informix-list@rmy.emory.edu Subject: SPL Returning Column Names I have a stored procedure that returns three values such as follows: return SldYear, MinYear, MaxYear; When executing the procedure through ODBC, the returning values have no column name associated with them. Using MS ODBC connection (IDC) for IIS I need to be able to reference any returning values with a column name. Is there anyway I can force the returned values from a stored procedure to have a column name? Thanks Sco