I am using the BETA DB2 Provider for .NET and have ran into the
following issue.
I would like to specify a library list and, for each unqualified
table/schema name that I specify in my query, I would like the correct
library to be 'looked up' with out having to manually code the Library
name, LIBRARY.TABLE.
ex:(Assume TABLE1 resides in LIB1)
strSQL = "SET PATH = LIB, LIB1, LIB2, LIB3..."
strSQL = "SELECT * FROM TABLE1"
How would I go about doing this?
Thanks!
following issue.
I would like to specify a library list and, for each unqualified
table/schema name that I specify in my query, I would like the correct
library to be 'looked up' with out having to manually code the Library
name, LIBRARY.TABLE.
ex:(Assume TABLE1 resides in LIB1)
strSQL = "SET PATH = LIB, LIB1, LIB2, LIB3..."
strSQL = "SELECT * FROM TABLE1"
How would I go about doing this?
Thanks!