Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

Multiple-Member File w/ SQL select via ODBC????

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

  • Multiple-Member File w/ SQL select via ODBC????

    Use the Create Alias command to build a "pointer-file" that references a specific member in a table. CREATE ALIAS MYLIB/FRED FOR MYLIB/BARNEY (MBR1)

  • #2
    Multiple-Member File w/ SQL select via ODBC????

    I am sorry but I don't understand. That looks like something I would do via STRSQL from a command line or in a CL program on my AS400. I am trying to access multiple members via an ODBC connection. I have setup a DSN link in my ODBC Data Source Administrator. Sincerely, Scott

    Comment


    • #3
      Multiple-Member File w/ SQL select via ODBC????

      From what I understand or have learned ODBC has no built-in mechanism for accessing multiple members. By default, ODBC always accesses the first member. Is there anyway to access additional members in a multi-member file via ODBC with an SQL select statement? Or should I just give up trying?

      Comment


      • #4
        Multiple-Member File w/ SQL select via ODBC????

        Once you created the Alias for each member, you could then access the alias through ODBC. Dave

        Comment

        Working...
        X