Results 1 to 5 of 5

Thread: iSeries - Does CREATE LOGICAL FILE (CRTLF) create an SQL VIEW

  1. #1
    Senior Member
    Join Date
    Nov 2000
    Location
    E Greenville, PA, USA
    Posts
    1,229

    iSeries - Does CREATE LOGICAL FILE (CRTLF) create an SQL VIEW

    We need to access specified file members from w/in SQL.
    SQL CREATE command does not allow you to point at members.

    Create Logical File (CRTLF) DOES permit this.

    If I do a CRTLF does the system create an SQL VIEW somewhere for the database?
    If so, where would that VIEW be found?

    Thanks greatly.
    Frosty.
    Frosty
    *
    Back to the future supporting A7.3 while moving to Oracle EBS

  2. #2
    Member
    Join Date
    Mar 2009
    Location
    Phoenix, AZ USA
    Posts
    59
    Frosty,

    You can create a database alias to reference a specific existing logical file's member. Then you can use the alias name in your SQL statements. See this link for examples: "https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_71/sqlp/rbafycreatingalias.htm"
    Regards,
    Kim Schmidt

    - E1 9.1.4 ,TR 9.2.2 , iSeries, DB2
    - formerly Xe, 8.0, SQL Server, Oracle

  3. #3
    Senior Member
    Join Date
    Nov 2000
    Location
    E Greenville, PA, USA
    Posts
    1,229
    Thanks, we had tried that.
    We also tried creating VIEWs, and VIEWs based on ALIASes.

    Something is preventing my counterpart(s) from seeing ALIAS, VIEW, or LOGICALS.
    BUT, that's their problem, not mine.

    Frosty
    Frosty
    *
    Back to the future supporting A7.3 while moving to Oracle EBS

  4. #4
    Member
    Join Date
    Sep 2001
    Location
    Greene, NY
    Posts
    143
    .
    You should be able to query the system SQL tables to find the location of any Views, Indexes, etc.
    iSeries running at V6R1
    JDE World 7.3, Cum12
    OneWorld XE Coexistence - Configurator

  5. #5
    Member
    Join Date
    Sep 2001
    Location
    Greene, NY
    Posts
    143
    .
    Maybe this PDF will be helpful...
    Attached Files Attached Files
    iSeries running at V6R1
    JDE World 7.3, Cum12
    OneWorld XE Coexistence - Configurator

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.