Background documentationExport Locate this document in the navigation structure

 

The following are some examples of data exporting with Loader CLI in transport mode.

Prerequisites

You require the demo databases DEMODB and TESTDB. Start the Loader in transport mode: loadercli -p.

You do not require and knowledge about the Loader syntax in transport mode. The generated Loader commands are, however, displayed on the console and in the Loader files, and can be used as templates for writing your own Loader commands.

Activities

Executing the Export

You want to export table HOTEL of schema HOTEL of database user MONA from database DEMODB. The application data is to be exported as files in CSV format. The values of the column INFO of data type LOB of table HOTEL are to be exported to a separate file for each data record.

loadercli -p

Package history: C:\Documents and Settings\anna\Application Data\sdb\loader\log\transport.log

Package path: c:\transport

Package name : 20060312161616

Step 1: Enter a package path

Package path: c:\transport

Step 2: Enter a package comment

Package comment: export

Step 3: What do you want to do?

[1] Transport from a source database to a target database

[2] Export from a source database

[3] Import to a target database

Step 3: 2

Step 4: What do you want to do?

[1] Choose an export package

[2] Create an export package

Step 4: 2

Step 5: Enter the source database connection

Database computer : genua

Database name : demodb

Database user : mona

Password : red

Step 6: Choose what you want to include in the package

[1] Complete user; one file per user

[2] Complete user; one file per user, excluding some tables

[3] Complete user; one file per table

[4] Complete user; one file per table, excluding some tables

[5] Complete schema; one file per schema

[6] Complete schema; one file per schema, excluding some tables

[7] Complete schema; one file per table

[8] Complete schema; one file per table, excluding some tables

[9] Schema tables; one file per table

Step 6: 9

Step 7: Enter the source database connection

Database schema : hotel

Step 8: Enter the table names you want to include in the package

[1]hotel

[2]

Step 9: Choose the transformation streams

[1] Catalog and data

[2] Catalog

[3] Data

Step 9: 1

Step 10: Do you want to specify the datastream format?

[1] Yes

[2] No

Step 10: 1

Step 11: How do you want to export the datastream?

[1] Comma separated values; one file per lob column

[2] Comma separated values; one file per lob value

[3] Fixed width values; one file per lob column

[4] Fixed width values; one file per lob value

[5] Platform independent loader records format (with logging)

[6] Platform independent database page format (without logging, backup necessary)

Step 11: 2

Step 12: How do you want to import the data?

[1] Row by row (with logging)

[2] Row by page (without logging, backup necessary)

Step 12: 1

Step 13: The package can be executed or generated now.

[1] Execute package to transport data now

[2] Generate package to transport data later

Step 13: 1

Export package name : 20060312161616

Export package comment : export

Export package creation : 20060312161616

Export package execution : 20060312161616

Export package path : c:\transport

Export package status [-T]: EXECUTE

Export direction [-t]: EXPORT

Export package [-p]: TABLE

Export part [-P]: TABLE

Export streams [-s]: CATALOG,DATA,PACKAGE

Export format [-f]: CSV

Export format [-F]: ROW

Export encoding [-c]:

Export lobcolumn [-l]: COLUMNVALUE

Source database computer [-nSRC]: GENUA

Source database name [-dSRC]: DEMODB

Source database user [-uSRC]: MONA

Source database table : "HOTEL"."HOTEL"

Step 14: Continue

[1] OK

[2] CANCEL

Step 14: 1

EXPORT TABLE "HOTEL"

CATALOG OUTSTREAM FILE 'HOTEL.CATALOG' DDL

DATA OUTSTREAM FILE 'HOTEL.DATA' CSV

Start 1 MAXROWS

LOB OUTSTREAM FILE "INFO" 'HOTEL_INFO.DATA###'

  ;

Package execution time   : 10.039s

Package execution log : loader_20060312161616.log

Package name : 20060312161616

You can see the Loader commands that are processed when export package 20060312161616 is executed in log file loader_20060312161616.log.

Repeating the Export

If you would like to repeat the export you just executed, specify the name of the export package when you call the Loader CLI:

loadercli -p 20060312161616

Step 1: Enter the source database connection

Database computer : genua

Database name : demodb

Database user : mona

Password : red

Export package name : 20060312161616

Export package comment : export

Export package creation : 20060312161616

Export package execution : 20060312171717

Export package path : c:\transport

Export package status [-T]: EXECUTE

Export direction [-t]: EXPORT

Export package [-p]: 20060312161616

Export part [-P]: TABLE

Export streams [-s]: CATALOG,DATA,PACKAGE

Export format [-f]: CSV

Export format [-F]: ROW

Export encoding [-c]:

Export lobcolumn [-l]: COLUMNVALUE

Source database computer [-nSRC]: GENUA

Source database name [-dSRC]: DEMODB

Source database user [-uSRC]: MONA

Source database table : "HOTEL"."HOTEL"

EXPORT TABLE "HOTEL

CATALOG OUTSTREAM FILE 'HOTEL.CATALOG' DDL

DATA OUTSTREAM FILE 'HOTEL.DATA' CSV

Start 1 MAXROWS

LOB OUTSTREAM FILE "INFO" 'HOTEL_INFO.DATA###'

  ;

Package execution time   : 2.152s

Package execution log : loader_20060312171717.log

Package name : 20060312161616

In log file loader_20060312171717.log, you can see the Loader commands that are processed when export package 20060312161616 is executed.

Generating an Export Package

If you want to generate an export package without executing it, proceed as follows:

loadercli -p

Package history: C:\Documents and Settings\anna\Application Data\sdb\loader\log\transport.log

Package path: c:\transport

Package name : 20060322101010

Step 1: Enter a package path

Package path: c:\transport

Step 2: Enter a package comment

Package comment: export_generate

Step 3: What do you want to do?

[1] Transport from a source database to a target database

[2] Export from a source database

[3] Import to a target database

Step 3: 2

Step 4: What do you want to do?

[1] Choose an export package (updates data)

[2] Create an export package

Step 4: 2

Step 5: Enter the source database connection

Database computer : genua

Database name : demodb

Database user : mona

Password : red

Step 6: Choose what you want to include in the package

[1] Complete user; one file per user

[2] Complete user; one file per user, excluding some tables

[3] Complete user; one file per table

[4] Complete user; one file per table, excluding some tables

[5] Complete schema; one file per schema

[6] Complete schema; one file per schema, excluding some tables

[7] Complete schema; one file per table

[8] Complete schema; one file per table, excluding some tables

[9] Schema tables; one file per table

Step 6:9

Step 7: Enter the source database connection

Database schema : hotel

Step 8: Enter the table names you want to include in the package

[1]hotel

[2]

Step 9: Choose the transformation streams

[1] Catalog and data

[2] Catalog

[3] Data

Step 9: 1

Step 10: Do you want to specify the datastream format?

[1] Yes

[2] No

Step 10: 1

Step 11: How do you want to export the datastream?

[1] Comma separated values; one file per lob column

[2] Comma separated values; one file per lob value

[3] Fixed width values; one file per lob column

[4] Fixed width values; one file per lob value

[5] Platform independent loader records format (with logging)

[6] Platform independent database page format (without logging, backup necessary)

Step 11: 2

Step 12: How do you want to import the data?

[1] Row by row (with logging)

[2] Row by page (without logging, backup necessary)

Step 12: 1

Step 13: The package can be executed or generated now.

[1] Execute package to transport data now

[2] Generate package to transport data later

Step 13: 2

Export package name : 20060322101010

Export package comment : export_generate

Export package creation : 20060322101010

Export package execution : 20060322101010

Export package path : c:\transport

Export package status [-T]: EXECUTE

Export direction [-t]: GENERATE

Export package [-p]: TABLE

Export part [-P]: TABLE

Export streams [-s]: CATALOG,DATA,PACKAGE

Export format [-f]: CSV

Export format [-F]: ROW

Export encoding [-c]:

Export lobcolumn [-l]: COLUMNVALUE

Source database computer [-nSRC]: GENUA

Source database name [-dSRC]: DEMODB

Source database user [-uSRC]: MONA

Source database table : "HOTEL"."HOTEL"

Step 14: Continue

[1] OK

[2] CANCEL

Step 14: 1

EXPORT TABLE "HOTEL"

CATALOG OUTSTREAM FILE 'HOTEL.CATALOG' DDL

DATA OUTSTREAM FILE 'HOTEL.DATA' CSV

Start 1 MAXROWS

LOB OUTSTREAM FILE "INFO" 'HOTEL_INFO.DATA###'

  ;

Package execution time   : 11.195s

Package name : 20060322101010

Executing a Generated Export Package

If you would like to execute an export package you have generated, specify the name of the export package when you call Loader CLI:

loadercli -p 20060322101010

Step 1: Enter the source database connection

Database computer : genua

Database name : demodb

Database user : mona

Password : red

Export package name : 20060322101010

Export package comment : export_generate

Export package creation : 20060322101010

Export package execution : 20060322121212

Export package path : c:\transport

Export package status [-T]: EXECUTE

Export direction [-t]: EXPORT

Export package [-p]: 20060322101010

Export part [-P]: TABLE

Export streams [-s]: CATALOG,DATA,PACKAGE

Export format [-f]: CSV

Export format [-F]: ROW

Export encoding [-c]:

Export lobcolumn [-l]: COLUMNVALUE

Source database computer [-nSRC]: GENUA

Source database name [-dSRC]: DEMODB

Source database user [-uSRC]: MONA

Source database table : "HOTEL"."HOTEL"

EXPORT TABLE "HOTEL"

CATALOG OUTSTREAM FILE 'HOTEL.CATALOG' DDL

DATA OUTSTREAM FILE 'HOTEL.DATA' CSV

Start 1 MAXROWS

LOB OUTSTREAM FILE "INFO" 'HOTEL_INFO.DATA###'

  ;

Package execution time   : 2.058s

Package execution log : loader_20060322121212.log

Package name : 20060322101010

In log file loader_20060322121212.log, you can see the Loader commands that are processed when export package 20060322101010 is executed.