PLSQL code on iSeries

895 pts.
Hi, I have a question as we have developed some plsql procedures on Db2 10.5 on windows & Linux. This is purely plsql code. as we need to run these procedures on all the databases under a particular instance. My requirement is can I use the same plsql code on Db2/400. I mean on iSeries. On iSeries database concepts are some what like LIBRARY, SOURCE PHYSICAL file, PHYSICAL file, LOGICAL FILE etc. Can some one please tell me what is the database hierarchy of normal db2/400? Will the code work on db2/400?
Is that library on Db2/400 is similar to a schema on db2 10.5 or something else? The same instance, database,schema , tables etc will be there on db2/400 too. Please clear my question.

Software/Hardware used:

Answer Wiki

Thanks. We'll let you know when a new response is added.

What type of connection and what does you connection string look like ? 

Discuss This Question: 3  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    We need to see the PL/SQL. How does it follow SQL standards and avoid platform-specific extensions? Also, how is the iSeries database defined? Is it all native files or is it created as SQL objects?

    In most senses, a native physical file can be treated just like a SQL TABLE, and a native logical file can be treated as a SQL VIEW (and possibly as an INDEX).

    But complications can arise when platform-specific extensions get involved. For example, if a native physical file is "multi-member", then the same PL/SQL might not be appropriate. Or if any of the iSeries data is in a S/36 environment, it might not be obvious how to access it.

    In short, it will probably mostly work; and maybe all of it will. But we can't be sure about any of it without knowing more.
    36,880 pointsBadges:
    Thanks ,

    You gave me a very useful information.
    I worked on native files of Iseries with RPG & CL. But I never saw the sql objects as I m not that much experienced. As like db2luw, can I get db2/400 alone that too do we have any command prompt not like this green screes.
    895 pointsBadges:
  • TheRealRaven
    Yes. The iNavigator feature can be downloaded from a network share from most iSeries or later systems. It provides some general database creation/manipulation functions.

    For database serious work, IBM's Data Studio product gives almost any DB2 access capability you could need.

    Various other database clients can also be used if you have a couple you might be comfortable with.
    36,880 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: