Re: File Members with CA/400 (FASTR to PC Download)

[Pete Hall <peteh@xxxxxxxxxx>]

At 02:33 PM 5/22/98 +0400, Vladimir Bystrov wrote:
>I want to be able to use CA/400 ODBC driver in Visual Basic to connect to 
>F8309 FASTR work file with an explicit reference to  IBM file member that 
>holds my FASTR report PC download information.  I cannot figure out the 
>ODBC connection string portion describing member name in CA/400 ODBC.

Vladimir,

With ODBC you are essentially using SQL to retrieve information. SQL does not 
support the concept of "Member", which is AS/400 specific. You can work around 
this problem by overriding the file name to the specific member (OVRDBF 
FILE(F8309) MBR(XXXX)). You can do this with ODBC by CALLing QCMDEXC and 
passing the command string, or by CALLing a CL program that executes the 
override (if you do this, you must also specify OVRSCOPE(*JOB), or the override 
will go away when the CL program RETURNs. QCMDEXC does not have this problem, 
because it always acts as though it is executing at the calling program's 
invocation level.

Pete


Pete Hall
peteh@inwave.com 
http://www.inwave.com/~peteh/

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---