Show TOC

Function documentationDATATRANSFERMODE Property Locate this document in the navigation structure

 

When using the Dumpload task (for example, TASK(DumpLoad, DATATRANSFERMODE, 4)), there are special property values for DATATRANSFERMODE. These values are shown in the following table:

Property Value

Description

More Information

0

Process the application set

Processing the Application

1

Import into SQL

This value is best for importing large data. You can check the work status setting on the data before importing. See Checking Work Status below.

Importing into SQL Server

2

Export from SQL

Exporting from Microsoft SQL Server

3

Export from Cube

Exporting from a Cube

4

Import into Cube (Fac2)

This value is best for importing small to medium data

Importing into a Cube

5

Clear data from SQL

You can check the work status setting on the data before clearing. See Checking Work Status below.

Clear Data from SQL

6

Import into Cube (WB)

Importing into a Cube

9

Import Into Cube Append — Appends the value in the cube without clearing the existing data

Importing into a Cube

10

Export journal data

Exporting Journal Data

11

Restore journal data

Restoring Journal Data

12

Clear journal data

Clearing Journal Data

Checking Work Status

When you use the 1 (Import into SQL) and 5 (Clear Data from SQL) property values, you can have the system check the work status settings of the data being cleared from the database.

Use the following rule in the MODIFYSCRIPT package variable for DumpLoad:

TASK (Task Name, “CHECKLCK”, 1)

Process Mode

Property Value

Description

1

Full Process. This rebuilds the entire application. Select this option if the application structure has changed.

2

Refresh. Clears data from the application and repopulates it with existing data

4

Fac2 Process. This option processes the short-term data storage (the FAC2 table). The Data Manager imports data to the short-term data storage by default, so there may be no need to process the entire application.