SQl Server 2000 Linked Server -- SYSTEM21

I know this a bit off the subject, but it is a System21 file I'm trying to read 
from a Server....Has anyone managed to define their AS400 as a Linked Server 
within SQL Server?   We are almost there, except weird things happen when we 
actually try to retrieve data. 

If anyone has this working, I'd much appreciate an "off-forum reply".

thanks in advance,

Neil.



-----Original Message-----
From: Garry Clarke [mailto:garry@xxxxxxxxxxx]
Sent: Monday 10 May 2004 09:29
To: 'System 21 Users'
Subject: RE: [SYSTEM21] Stock Interface


We've done this for a customer of ours if you want to email me separately
for advice.

Garry Clarke
Bluetech Ltd
Old Airport Road
Cloghran
Co. Dublin

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx
[mailto:system21-bounces@xxxxxxxxxxxx]On Behalf Of Neil Thursby
Sent: 07 May 2004 11:56
To: System 21 Users
Subject: [SYSTEM21] Stock Interface


I need to write an interface which mimics Manual Invoicing with Stock
Update.  I believe all I need do is write OEP65 and OEP70 records, then run
normal Invoice Print.  However, I'm not sure that process will update
Inventory.   I suspect I'll need to call IN070 for each of my stock
movements?  Can anyone confirm this please.

Neil.

_____________________________________________________________________
This transmission and any attachments are confidential and are intended
solely for the named addressee (s). If you are not the addressee, please do
not read, copy, use or disclose this transmission and please notify us
immediately by telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission from
your system.

Although we have taken steps to ensure that this email and attachments are
free from viruses, we advise that in keeping with good computing practice
the recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of
email communications.

_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This e-mail message has been scanned for Viruses and Content and cleared 
by the Mail Marshal Filtering System
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


_____________________________________________________________________
This transmission and any attachments are confidential and are intended solely 
for the named addressee (s). If you are not the addressee, please do not read, 
copy, use or disclose this transmission and please notify us immediately by 
telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission from 
your system.

Although we have taken steps to ensure that this email and attachments are free 
from viruses, we advise that in keeping with good computing practice the 
recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of email 
communications.

_____________________________________________________________________
This transmission and any attachments are confidential and are intended solely 
for the named addressee (s). If you are not the addressee, please do not read, 
copy, use or disclose this transmission and please notify us immediately by 
telephone on 
+44 (0) 1670 594848 or by reply.  Please then delete this transmission from 
your system.

Although we have taken steps to ensure that this email and attachments are free 
from viruses, we advise that in keeping with good computing practice the 
recipient must ensure that they in fact are virus free.

No contracts may be concluded on behalf of Fone Logistics LTD by means of email 
communications.