I've come across problems when working in SQL and ODBC with specific members in files with multiple members.
This is a simple solution that I came up with -- without using the OVRDBF or CREATE ALIAS.
Create an alias for the member of the file with multiple members:CRTDDMF FILE(library_name/ddm_file_name) RMTFILE(*NONSTD 'library_name/file_name(member_name)') RMTLOCNAME(*RDB) RDB(local_rdb_name) library_name/ddm_file_name = alias for file member to use in file with multiple members library_name/file_name(member_name) = file member in file with multiple members local_rdb_name = WRKRDBDIRE, see Relational Database Name (Remote Location = *Local)
In SQL------ SELECT field1, field2, field3, field4 FROM library_name/ddm_file_name WHERE field1 = 'ABCDF'
In ODBC------- In the screen Select Tables, to select the file: library_name/ddm_file_name Then, it will visualize the fields of the file (they are really the fields of the file: library_name/file_name(member_name)), to select the fields and to usually continue
MORE INFORMATION ON THIS TOPIC
The Best Web Links: Tips, tutorials and more.
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
Read this Search400.com Featured Topic: Monitoring your iSeries system .
Ask the Experts yourself: Our systems management gurus are waiting to answer your technical questions.