Re: Stored procedure

Googling DB2 Temporary table brings up this:
http://www.cs.newpaltz.edu/~pletcha/DB/db2_TempTables.html

Here is a Redbook that will likely answer these and many of your followup
questions: http://www.redbooks.ibm.com/redbooks/pdfs/sg246503.pdf

Is the issue you don't know how to write the stored procedure or you don't
know how to do things like temp tables and loop variables in DB2?

Also, do you need temp tables and for loops to solve your problem? In any
relational database platform, using a CURSOR, FOR loopp or any other for of
RBAR (row by agonizing row) is bad practice on any relational database.
There is usually another better way.

Can you instead of a temp table, use a common table expression for example:

http://publib.boulder.ibm.com/html/as400/v4r4/ic2962/info/db2/rbafzmst66.htm



On Tue, Jun 2, 2015 at 1:32 PM, Hoteltravelfundotcom <
hoteltravelfun@xxxxxxxxx> wrote:

I want to use a stored procure which have a lot of feature
like temp table loop variables, Can I do this in IBM i?

I have not seen any examples how to create stored procedure on IBM i.

that

can be called from
a crystal report.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.