Declaring Variables on Informix

Posted by santiagobasulto on Stack Overflow See other posts from Stack Overflow or by santiagobasulto
Published on 2010-06-03T19:02:50Z Indexed on 2010/06/03 19:04 UTC
Read the original article Hit count: 231

Filed under:

informix

|

spl

Hi everybody.

I've a Store Procedure Routine. I want to get some variables from the execution of that proc. But i don't know how to create it. For example:

CREATE PROCEDURE foo() ... RETURN somebar; END PROCEDURE;

then, when i call it:

-- DEFINE bar, this is what i want to know!!!! execute procedure foo() into bar;

How can i initialize "bar"????

Thanks!

© Stack Overflow or respective owner

Related posts about informix

How to improve Java perfomance on Informix for Windows

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with performance of Java UDR functions on Informix on Windows. On this server I already have some functions in C and SPL. I chose one function to write it in those 3 languages and I measured performance of this function on test table. Function calculates some kind of checksum so it… >>> More
Informix "Database locale information mismatch"

as seen on Server Fault - Search for 'Server Fault'
I have informix 11.5 running in my Win-2003 box and few databases running in it. System databases have locale en_us.819 My custom databases have locale en_us.57372 (UTF8). There is also application deployed to JBoss 4.0.2 which has few datasources configured for those custom databases. <local-tx-datasource> <jndi-name>InformixDS</jndi-name> <connection-url>jdbc:informix-sqli://@database… >>> More
Problem with Informix JDBC, MONEY and decimal separator in string literals

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problem with JDBC application that uses MONEY data type. When I insert into MONEY column: insert into _money_test (amt) values ('123.45') I got exception: Character to numeric conversion error The same SQL works from native Windows application using ODBC driver. I live in Poland and have… >>> More
Users Login Info in INFORMIX-SQL

as seen on Stack Overflow - Search for 'Stack Overflow'
INFORMIX-SQL 4.1 - There's this ASCII UNIX file called "passwd" in /usr/informix/etc which holds all the user id's and encrypted passwords to log into ISQL. Is there a system catalog table which holds the logged in users? I see a SYSUSERS.DAT file but when I queried it, it didnt show my login id… >>> More
String concatenation within INFORMIX-SQL "Perform" screens.

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I concatenate two char columns within a perform screen? example: table sample col1 char(1), col2 char(1) . . after editadd of sample let label_3 = sample.col1 + sample.col2 .. this didn't work, I even tried using subscripts for the 2 cols but no dice! >>> More

Related posts about spl

How do I aggregate results from an Adjacency list using PHP's SPL

as seen on Stack Overflow - Search for 'Stack Overflow'
I've tried using nested sets, and they become very difficult to maintain when dealing with multiple trees and lots of other complications.. I'd like to give PHP's SPL library a stab at this (btw, we are PHP 5.3, MySQL 5.1). Given two datasets: The Groups: +-------+--------+---------------------+---------------+ |… >>> More
PHP SPL RecursiveDirectoryIterator RecursiveIteratorIterator retrieving the full tree

as seen on Stack Overflow - Search for 'Stack Overflow'
how can i retrieve the full directory tree using SPL ? >>> More
Killing Stuck Child JVM's

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Note: This facility only applies to Oracle Utilities Application Framework products using COBOL. In some situations, the Child JVM's may spin. This causes multiple startup/shutdown Child JVM messages to be displayed and recursive child JVM's to be initiated and shunned. If the following: Unable… >>> More
Where is the source code of the PHP SPL library??

as seen on Stack Overflow - Search for 'Stack Overflow'
I can find the definition files at http://www.php.net/~helly/php/ext/spl/... but I want to extend DirectoryIterator and SplFileInfo to work over a virtual filesystem stored on a database... not a real filesystem... Many thanks... >>> More
Web Self Service installation on Windows

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Web Self Service (WSS) installation on windows is pretty straight forward but you might face some issues if deployed under tomcat. Here's a step-by-step guide to install Oracle Utilities Web Self Service on windows. Below installation steps are done on: Oracle Utilities Framework version… >>> More