Where are Views, stored procedures, stored? - IBM AS400

This is a discussion on Where are Views, stored procedures, stored? - IBM AS400 ; Where are sored procedures, views etc, stored? Are they objets for the OS/400 as Logical files or Phisical files? how to save and restore them? Thanks in advance....

+ Reply to Thread
Results 1 to 3 of 3

Thread: Where are Views, stored procedures, stored?

  1. Where are Views, stored procedures, stored?

    Where are sored procedures, views etc, stored? Are they objets for the
    OS/400 as Logical files or Phisical files? how to save and restore them?

    Thanks in advance.



  2. Re: Where are Views, stored procedures, stored?

    On Aug 16, 5:21 am, "CENTRINO" wrote:
    > Where are sored procedures, views etc, stored? Are they objets for the
    > OS/400 as Logical files or Phisical files? how to save and restore them?
    >
    > Thanks in advance.


    Tables are Physical Files
    Views are Logical Files
    Stored procedures are Program Objects

    All are stored in the library of choice, and get backed up when the
    library is backed up.


  3. Re: Where are Views, stored procedures, stored?

    SQL VIEW and TABLE are objects of type *FILE; a VIEW is implemented
    as a LF [Logical File] extended attribute, and the TABLE is implemented
    as a PF [Physical File] extended attribute. The SQL INDEX in DB2 for
    i5/OS is also of type *FILE, implemented as a keyed LF.
    SQL Stored Procedures are objects of type *PGM
    SQL Functions are modules as part of object type *SRVPGM

    External Stored Procedures and External User Defined Functions are
    entries in an SQL Catalog TABLE [the SYSROUTINE TABLE stores procedure
    and function entries as rows, SYSPROCS VIEW and SYSFUNCS VIEW divide
    those rows] which may or may not have a self-describing *PGM or *SRVPGM
    associated. If the external/referenced object exists before the CREATE
    statement, and the reference object is capable of becoming
    self-described [a message is issued during CREATE if not], then future
    save and restore activity will enable the object to self-register upon
    [create at/for] restore. This does not attempt to explain REXX nor
    JAVA, which may be different.

    The aforementioned External Object Types [*FILE, *PGM, *SRVPGM] are
    stored in *LIB objects, in the /QSYS.LIB file system. The SAVLIB and
    SAVOBJ commands are used to save almost any external object type, such
    as *FILE. RSTLIB and RSTOBJ commands are the counterparts, used to
    restore the objects. SAV and RST commands can be used to save and
    restore objects from that, and the other file systems; maybe not for
    /QDLS, but if not, it has SAVDLO and RSTDLO.

    Regards, Chuck
    --
    All comments provided "as is" with no warranties of any kind
    whatsoever and may not represent positions, strategies, nor views of my
    employer

    CENTRINO wrote:
    > Where are stored procedures, views etc, stored? Are they objects for the
    > OS/400 as Logical files or Physical files? how to save and restore them?


+ Reply to Thread