Re: DB2 table vs Physical files

They're implemented as pretty much the same thing on an iSeries. The ODBC
driver should take care of the code conversion.

On Wed, 12 May 2004 09:19:56 -0400, "Lokesh Gupta"
<Lokesh.Gupta@xxxxxxxxxx> said:
> Hi,
> I used to work with Physical Files (PF)  and this is first time when I
> may have to work
> with DB2 tables. I need to pull data from As400 to windows environment
> (this could be
> .net or Java) over ODBC and I have an option to use physical files or DB2
> tables. 
> My question is (1) which option would be better for performance pov PF or
> DB2 tables. 
> I do not need to join lot of tables, it is just couple of tables and a
> simple query. 
> I do not see any difference from windows side to access the data.
> 
> Secondly, Is there any data conversion involved (db2 or PF) as I am
> pulling data 
> from AS400 to Windows, if yes, how will that affect the performance.
> 
> 
> regards,
> Lokesh
> 
> 
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
-- 
  
  michaelr_41@xxxxxxxxxxxxxx

-- 
http://www.fastmail.fm - Access your email from home and the web