AW: Stored Procedures

["Birgitta Hauser" <Hauser@xxxxxxxxxxxxxxx>]

Hi,

with iSeries Navigator it is possible to generate the appropriate SQL code
for any Database Object (physical files, tables, views, indexes, sequence
objects but also stored procedures and user defined functions either written
in pure SQL or registered as external) and store this code in either an
IFS-File with extension .sql that can be executed by iSeries Navigator's Run
an SQL script or you can store it as real source physical file member.

When generating the SQL code you also can specify the naming you want to
use, if drop statements should be added (so that the object first get
deleted before it will recreated) and if short SQL names should be kept or
newly generated.

The SQL Code stored in an Source physical file member can be executed by
running RUNSQLSTM.

In my company we generate all SQL objects with the iSeries Navigator and we
also register our external procedures or UDFs with iSeries Navigator. After
the objects are created successfully, we generate the source code and dump
it into source members. After we delete the generated objects and run the
SQL scripts, to make sure the source code in the members corresponds to the
objects.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von DLee@xxxxxxxx
Gesendet: Friday, 01. May 2009 18:52
An: rpg400-l@xxxxxxxxxxxx
Betreff: Stored Procedures

Hi

Here at my company we are new to using stored procedures.

Some of our stored procedures are being created as sqlrpgle members, other 
are keyed into Ops Nav and no real source other than that is retained.

My department wants to be sure and keep the stored procedures in the 
sqlrpgle member. as a method of knowing where they are.

I'm wondering what other companies are doing.

I would appreciate any reponses on this.

Darrell Lee
Information Technology
Extension 17127