Can anyone help me with this?

Article View: ab.software.developers

Article #1199

Back to ab.software.developers Previous Next

#1199

From: Element Limited
Date: Thu, 14 Jan 1999 00:00

11 lines
1110 bytes

I am using JD Edwards One World ERP software and I need to copy tables from
one server to another for production. I want to use ISQL to accomplish this.
I attempted to use the following statement:>
                       Currently running ISQL on the source server.>
                           INSERT
<servername>.<databasename>.<tableowner>..<tablename>
                             SELECT * from <tableowner>.<tablename>>
I get an error stating I am using too many prefixes. I know this can be done
through ISQL but must be doing something wrong.

Help!

Technical Details

Message-ID: <46kn2.4007$gP1.53@news-reader.bt.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10f2ee,85f0c7b839027c6d,start
X-Google-Attributes: gid10f2ee,public
From: "Element Limited" <element@element-limited.com>
Subject: Can anyone help me with this?
Date: 1999/01/14
Message-ID: <46kn2.4007$gP1.53@news-reader.bt.net>
X-Deja-AN: 432494598
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
X-Trace: news-reader.bt.net 916311552 194.75.179.147 (Thu, 14 Jan 1999 10:59:12 BST)
NNTP-Posting-Date: Thu, 14 Jan 1999 10:59:12 BST
Newsgroups: ab.software.developers