Home > IT Answers > AS/400 > export sql server to iseries files
AS400programmer
0 pts.
 export sql server to iseries files
AS/400, DB2 Universal Database, Desktops, Management, Microsoft Windows, OS, Security, Servers, SQL Server
when I attempt to export a file most vchar and char fields default to datalink type via odbc. The iseries does not like the datalink type as then it can't find the link. When I try to force the vchar field it creates the file but then on the copy tells me the field is not found Any suggestions

Software/Hardware used:
ASKED: November 11, 2005  8:53 AM
UPDATED: November 11, 2005  9:43 AM
RELATED QUESTIONS
Answer Wiki:
Can you CAST the field as VARCHAR or even CHAR?
Last Wiki Answer Submitted:  November 11, 2005  9:06 am  by  TheQuigs   0 pts.
All Answer Wiki Contributors:  TheQuigs   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I am using the export wizard. The field in the
table is NVARCHAR 64 user name
When I attempt to export via odbc
I wind up with type datalink

The other problem it will create the file
on the iseries but fails on the copy that
it can’t find the field

AS400programmer
 0 pts.