Export table:

[Former Member]

Hi,

When i try to use the Export (table) command, an exception comes:

I followed the syntax:

EXPORT TABLE hotel.room

DATA OUTSTREAM 'room_csv.data'

-

---

Error -

---

Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

Syntax error or access violation;-3005 POS(1) Invalid SQL statement

My requirement is to pass the table data from one server to another? How can i achieve this?

Thanks

Vinod V

Edited by: Vinod V on Jun 12, 2008 10:52 AM

[steffen_schildberg]

Hi Vinod,

to get tables exported with the command you use you need to use the Loader - it is not integrated in SQL Studio.

Run loadercli -u <user name>,<pw> -d <db name> and then type the command again and it'll run.

Regards,

Steffen

[Former Member]

Hi,

anyway it seems to be a nice idea to enter Loader commands in the SQL Editor of Database Studio.

I will check if this is possible for a future release of Database Studio.

Best Regards

Wolfgang

[Former Member]

HI,

try following.

EXPORT TABLE hotel.room

DATA OUTSTREAM FILE 'room.data' RECORDS

PACKAGE OUTSTREAM FILE 'room_export.package' COMPRESSED

regards,

kaushal

[Former Member]

I tried the same and found exception in export command.

Syntax error or access violation;-3005 POS(1) Invalid SQL statement

I don't find any Syntax error in Query also i create a table manually under a test schema and tried to export using that. Still getting the same exception.

Any Idea?

Regards

Vinod V

[Former Member]

Hi,

I'm not sure why it's giving error?

you can try other method using following blog.

check /people/kathirvel.balakrishnan2/blog/2005/02/03/import-and-export-data-in-maxdb-using-sqlcli-and-batch-files

regards,

kaushal

[Former Member]

Hello,

the lines

> Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed

> Syntax error or access violation;-3005 POS(1) Invalid SQL statement

show that you executed the Export Loader command as SQL command. This is not possible.

Please use the loadercli command line program or Database Studio to realize export and import.

If you want to transport a table form one server to another I would recommend to use Database Studio. There you can simply drag/drop the table between two databases.

Best Regards

Wolfgang

[Former Member]

Hi,

your requirement is to pass the table entry from one sap server to other sap server.

prerequisites: the target system have same table with same structure.

do following.

on source system

execute SE10 -> create -> workbench request.

When created, click on it, go in menu Request/task -> Object list -> Display object list. Go in modification mode (change) and add a new line with:

PgmID = R3TR

Obj = TABU

Object name = Name of your table

Double-click on the created line and, depending on your need, put '*' in the key

release this request and import it in target system.

regards,

kaushal

[Former Member]

Hi Kaushal,

Please note down that i have created Dynpro Database Project and deployed in one J2EE server. I deployed the same application in another server and now want the table data from first to the latest tables in second server. How can i do that?

[ workebnch request is not possible in this case. ]

Thanks

Vinod V