spl blocks in informix

[penzk001]

Can anyone tell me convert the following pl/sql block to informix spl.

declare
db v$database.name%TYPE;
begin
dbms_output.enable (99999);
select name into db from v$database;
dbms_output.put_line (db);
end;

Is there a good pdf for SPL ?

 

[vpshriyan]

Hi,

The Oracle SP that you have posted seems to be specific and native to Oracle SPL, hence I may not be in a position to suggest a solution.

However, you may look at the link below, which points to an official documentation on informix spl in pdf format. The title of the e-book is Informix Guide to SQL and the 8th chapter deals with Creating and Using Stored Procedures.

http://www-3.ibm.com/software/data/informix/pubs/library/interim/4366-pdf.html

Regards,
Shriyan

"Man who knows, knows, he knows nothing!"

 

[penzk001]

Thanks for your help, as I thought that informix supported a SPL structures outside the create procedure clause.


Thanks again
Kenneth