× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Chuck, in my case, it was a matter of seeing the flat file in the list of tables in the schema (library).

I don't remember if I tried a SELECT against the flat file - I suspect that it would have worked.

Vern

On 11/20/2013 11:42 AM, CRPence wrote:
On 20-Nov-2013 04:45 -0800, Daron Whitehouse wrote:
I'm able to see my legacy CRTPF tables (20 y/o ERP application) using
IBM Data Studio v4.1. Could it be the way I configured the driver?
The connection I use most uses the "naming=system;" property and the
user credentials used is a profile having a job description with an
initial library list for our normal ERP environment (although, I do
not believe this library list is necessary for visibility in IBM Data
Studio).
I am implying nothing, as I have not used the product. And FWiW, the
chosen drive could play a huge role; e.g. a /native/ driver would be
able to implement its API invocations [e.g. SQLTables()] using the
specific knowledge of the OS, beyond mere dependence on the /standard/
catalogs. Additionally...

What is meant by "to see", may be the crux. Is the implication that
the file name is visible in a /list/ of tables, against which a SQL
request is being composed; e.g. selecting the table name from a list,
when composing an UPDATE statement? Or is the implication that an
already-composed SQL statement, having either a qualified or an
unqualified table-reference, is able to complete as expected; e.g. the
following request produces a report?:
SELECT * FROM aFlatFile



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.