Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

iSeries / AS400 FAQ : (Category) Programming : (Category) SQL : How do I access a specific member with SQL?

April 26, 2017AS400 category iSeries Programming sql

0

Posted

iSeries / AS400 FAQ : (Category) Programming : (Category) SQL : How do I access a specific member with SQL?

1 Answer

0

Posted

You can create logical files that point to a particular member or use the SQL CREATE ALIAS function. Here’s an example: CREATE ALIAS mylib/SALESJAN for prodlib/SALESFIL(JAN). If running an iSeries program, you can also do an OVRDBF SALESFIL TOFILE(prodlib/SALESFIL) TOMBR(JAN). This works with ODBC if you create a stored procedure and call that from ODBC. Use the member name as one of the parameters and do the override there.