×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
True, they do not write stored procedures.
However, someone, somewhere ran something like this:
CREATE PROCEDURE GIMMIEDATE (IN DATE_IN CHAR (6),
OUT DATE_OUT DATE)
LANGUAGE COBOL
PARAMETER STYLE GENERAL
EXTERNAL NAME GETDATE6C
Since they're pretty determined to disavow any knowledge of having done
that try the following:
open up a browser to
http://youribmi:2001 replacing youribmi with whatever
the name of your partition of IBM i is.
Expand IBM i Management
Expand Database
Expand Databases
Expand the name of your IBM i (well, that is the default database name...)
Expand Schemas (aka libraries).
Expand the schema (library) containing the procedure.
Select Procedures.
Select the procedure.
Actions, Generate SQL. This 'decompiles' the stored procedure into the
source used to create it.
Copy and paste the generated SQL.
Show us a sample you called with it hard coded parameters.
Show us as you want to call it from ODBC, also with the definition of the
variables used.
Rob Berendt
midrange.com
