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 |
|
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. |
|
2 |
Export from SQL |
|
3 |
Export from Cube |
|
4 |
Import into Cube (Fac2) This value is best for importing small to medium data |
|
5 |
Clear data from SQL You can check the work status setting on the data before clearing. See Checking Work Status below. |
|
6 |
Import into Cube (WB) |
|
9 |
Import Into Cube Append — Appends the value in the cube without clearing the existing data |
|
10 |
Export journal data |
|
11 |
Restore journal data |
|
12 |
Clear 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. |