Using files with multiple members in SQL or ODBC

Working in SQL and ODBC with specific members in files with multiple members? Here's a helpful tip to make it a little easier when problems occur.

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.


This was first published in September 2004

Dig deeper on Performance

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchEnterpriseLinux

SearchDataCenter

Close