Groups > DB2 > DB2 on AS400 server > Re: How can I access the DB2/400 using Microsoft SQL Server 2005




How can I access the DB2/400 using Microsoft SQL Server 2005
?

How can I access the DB2/400 using Microsoft SQL Server 2005 ?
Sun, 24 Feb 2008 15:54:16 EST
Friends, <br />
<br />
I have this file QGPL/FATURAS (on AS/400) and I have too the field named num-fat
and I dont know how access this file using a command from the Microsoft SQL
Server 2005 creating a file text on this directory
"C:\TEMP\FATURAS.TXT".<br />
<br />
Regards,<br />
Post Reply
Re: How can I access the DB2/400 using Microsoft SQL Server 2005
Sun, 24 Feb 2008 16:22:44 -060
   From the perspective of MS SQL Server, that would be a question more 
appropriate to a forum on that product.  The DB2 side accepts a wide 
variety of means to access its data directly.

   From the perspective of i5/OS, that can be accomplished simply by 
invoking the CPYTOIMPF database file export feature, specifying that the 
stream file that is generated for text export be placed on a file share 
defined to the target system.

Regards, Chuck
-- 
  All comments provided "as is" with no warranties of any kind 
whatsoever and may not represent positions, strategies, nor views of my 
employer

roberto_borges_silva@yahoo.com.br wrote:
> I have this file QGPL/FATURAS (on AS/400) and I have too the field
> named num-fat and I don't know how access this file using a command
> from the Microsoft SQL Server 2005 creating a file text on this
Post Reply
about | contact