ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Database alias

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database alias

    I would like to know if it's possible to create alias of a database library, not single tables or views but an entire db.
    Someone can help me ?
    Thanks

  • #2
    CREATE ALIAS is only supported for tables and views.

    Comment


    • #3
      yes I know,
      but I am interested in knowing if, with some workaround, I can use a library also with another name

      Comment


      • #4
        When creating a new schema it is possible to define a long (SQL) name and a short (system) name for the schema ... so you may have 2 names.
        ... but there is no RENAME for an existing schema.

        Comment


        • #5
          I know the possibility to create long name ...
          I'm interested if exist something like
          db2 catalog database db1 as db2

          Comment

          Working...
          X