User Profile

Collapse

Profile Sidebar

Collapse
rozedror
rozedror
Last Activity: Sep 9 '07, 11:17 AM
Joined: Oct 26 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rozedror
    started a topic Use ODBC API to retrieve indexes and keys on AS/400
    in General

    Use ODBC API to retrieve indexes and keys on AS/400

    hi,
    i need to retrieve all indexes and keys from tables and files.
    right now i'm using SQLStatistics, but it retrieve only the indexes on tables (indexes that appear on the catalog sysindexes).
    i need to retrieve also the key fields in physical file.

    1. how can i retrieve the key field in physical file through ODBC?
    2. Is there another AUTOMATIC way retrieving the key field? for example a way to AUTOMATICLY...
    See more | Go to post
    • rozedror
      started a topic build index from key field
      in General

      build index from key field

      hi,

      I have (On AS/400) a physical file (with keyed access path )with a key
      field.
      How can i build an index from this field?
      (i need it for the SQLStatistics)


      Thank,
      Dror
      See more | Go to post
      No activity results to display
      Show More
      Working...