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

Hello Vladimir,

I don't believe the standard SQL syntax allows specifying members (RDB theory 
doesn't even admit to multiple 
members) however you should be able to accomplish the same thing by using the 
SQL CALL statement to invoke the 
OVRDBF command via QCMDEXC to point to the correct member.

The OVRDBF will run in your host ODBC job and SQL (really the AS/400 query 
engine) will respect this sort of 
override.

Regards,
Simon Coulter.

//----------------------------------------------------------
// FlyByNight Software         AS/400 Technical Specialists
// Phone: +61 3 9419 0175      Mobile: +61 3 0411 091 400
// Fax:   +61 3 9419 0175      E-mail: shc@flybynight.com.au
// 
// Windoze should not be open at Warp speed.
 

//--- forwarded letter -------------------------------------------------------
> X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211
> Date: Fri, 22 May 98 14:33:02 +0400
> From: "Vladimir A. Bystrov" <byst@mail.wplus.net>
> To: "MIDRANGE-L@midrange.com" <MIDRANGE-L@midrange.com>
> Reply-To: MIDRANGE-L@midrange.com
> Subject: File Members with CA/400 (FASTR to PC Download)

> 
> 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.
> 
> I can do this with ShowCase ODBC (SELECT ... FROM LIBRARY.F8309:MEMBER).  I 
> also can create a physical file with AS/400 query or FTP and dump it to a 
> PC, but it all requires extra steps.
> 
> Does anyone have any clue how this could be done directly with CA/400 ODBC 
> in VBA?
> 
> Any help or comments are appreciated.
> 
> Thanks,
> 
> Vladimir Bystrov+---
> | 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
> +---
> 

+---
| 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
+---