|
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 mailing list archive is Copyright 1997-2026 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.