MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » May 2014

RE: store procedures?



fixed

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.






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact