I have two databases, one on a SQL server, one on and AS400 on the other side of the bldg. <BR><BR>Every night, I must update some data in the SQL server based on data in the AS400. This would be ...
I currently produce a data file on an AS400 for use in a SQL 2000 database.<BR><BR>I use the CPYTOIMPF command to produce a file from a query. I then copy it to a PC directory using the CPYTOPCD ...
A Version 6 PROC SQL Pass-Through view does not need to be updated to be used in Version 7 or Version 8. The conversion of PROC SQL Pass-Through views is automatic and does not require you to use the ...