Re: SQL Question

If your web developer is dealing with an iSeries, he should be on the
following lists:

1.  This one.
2.  Web400.
3.  ignite/400 (go to ignite400.org).
4.  Java-400 (if you are using Java).

And make him as his own questions!

I didn't know a thing about the iSeries until I got to my present web
development job.  I couldn't have made it without these resources.

Mike E.

On 3/16/06, DebbieKelemen <DebbieKelemen@xxxxxxxxxxx> wrote:
> I am asking this question on behalf of my web developer, who does not belong
> to any list related to the iSeries (even though he should in my mind).
> Anyway, here goes nothing.  He would like to be able to something similar to
> the following:
> ____________________________________________________
> CREATE PROCEDURE CWMPINH.GETACTIVEITEMSKUS
> (IN IN_COMPANY CHARACTER(3),
> IN IN_OFFER CHARACTER(3))
> RESULT SETS 1
> LANGUAGE SQL
> BEGIN
>
> declare selectfromtable  CHARACTER(30);
> set selectfromtable = 'realtablename' + IN_COMPANY;
>
> DECLARE c1 CURSOR FOR
>
> select IN_COMPANY as company
> from  selectfromtable <-- this guy needs to be evaluated
>
> OPEN c1;
> SET RESULT SETS CURSOR c1;
> END;
> _______________________________________________________________
>
> In the above he is attempting make the table in his procedure something he
> declares & selects from on the fly because it will vary based on whether he
> is going over our live or test data.  But the iSeries is fighting him over
> this.
>
> Can anyone help?
>
> Debbie
>
> --
> 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.
>
>