Q
Problem solve Get help with specific problems with your technologies, process and projects.

SQL 7's DTS function to copy data from an AS/400 file to a SQL table

I'm attempting to use SQL 7's DTS function to copy data from an AS/400 file to a SQL table. I'm using a Client Access ODBC DSN to connect.

When I try to execute the copy, I get the following error message.

"ODBC error: [IBM] [Client Access/400 ODBC V2 Driver][DB2/400 SQL/ SQL0113 - Name "*N" not allowed.

I found a suggested solution that I should use the ADDRDBDIRE command to rectify the problem, but don't know if this is appropriate or what parameters to include.


You found the correct solution. Indeed you have to add a name to your local as400 data base.

ADDRDBDIRE is used in the following manner:

ADDRDBDIRE RDB(machine name) RMTLOCNAME(*LOCAL)

Be sure to restart the TCPIP database servers to activate this change:


Dig Deeper on FTP

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close