RE: store procedures?

[Miguel Peralta <mperalta8@xxxxxxxxxxx>]

OH thanks! i try these, maybe i looking in the wrong place, or looking the wrong object, reggards!!!


La felicidad es frecuente, no pasa un día en que no estemos un instante en el Paraíso.

> To: midrange-l@xxxxxxxxxxxx
> Subject: Re: store procedures?
> From: rob@xxxxxxxxx
> Date: Tue, 20 May 2014 07:54:33 -0400
>
> When you create a procedure it should create an ILE C program in the 
> library.
>
> CRTLIB ROBSQL
>
> STRSQL
> create procedure 
> robsql/testsql ( In  question int, 
>                  Out answer   int) 
> Language sql 
> Begin 
>   set answer = question +1; 
> End 
> Procedure TESTSQL was created in ROBSQL.
>
> WRKOBJ ROBSQL/*ALL
> Object      Type      Library     Attribute   Text 
> TESTSQL     *PGM      ROBSQL      CLE         SQL PROCEDURE TESTSQL
>
> You can also see it 'registered' by
> SELECT * FROM SYSPROCS WHERE SPECIFIC_SCHEMA = 'ROBSQL'
>
> Now, I can 
> SAVOBJ OBJ(TESTSQL) LIB(ROBSQL) DEV(*SAVF) OBJTYPE(*PGM) SAVF(ROB/ROB)
> ftp it to other machine
> telnet to other machine
> crtlib robsql
> rstobj testsql robsql dev(*savf) savf(rob/rob)
> strsql
> SELECT * FROM SYSPROCS WHERE SPECIFIC_SCHEMA = 'ROBSQL'
> and see it registered there also.
>
> It may work differently for procedures based off of other languages than 
> SQL Procedure language (SPL).
> But I've got to get to work on real stuff.
>
>
>
> Rob Berendt
> -- 
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> From:   Miguel Peralta <mperalta8@xxxxxxxxxxx>
> To:     "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
> Date:   05/19/2014 05:36 PM
> Subject:        store procedures?
> Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
>
>
>
> hi i need some help, in where library are created the access or sql store 
> procedures? or are creatin on th fly? If i need to restore again or 
> moving, where resides? thank and reggards!!!
>
>
> La felicidad es frecuente, no pasa un día en que no estemos un instante en 
> el Paraíso.  
> -- 
> 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.