Group Discounts available for 3+ students and Corporate Clients

Working with Multi Load and its Structure in TeraData

Multi Load

  1. It is cusion of Fast load To load bulk data multiple tables
  2. Mload Loads max 5 Tables at a Time
  3. Multi load supports, INSERT, UPDATE and UPSERT[update else insert]
  4. It is fully Automatic restart able
  5. It loads data into empty/populated tables
  6. It loads duplicate record as well
  7. It support input module programming
  8. Max15 FLML,FEXP Script we can executes at a time
  9. It process the data Block by block
  10. It reduce the utilization of P.E
  11. It Keeps BYNET Activity low by Running Amp local processing
  12. There is no transient General over head
  13. It performs over multiple DML Operations, multiple table by taking table data from a single file
  14. Max 20 DML Operation it supports a script.
  15. It Runs in 5 Phases and load error data to error tables
  16. Multi load support NUSI Data loading

 

Navigation

Start 2Run  2 M Load

Start  2 programs  2 Tera data client  2  Tera data m load

 

Limitation

  1. If the table contains USI,RI,JI,HI And Triggers, it cannot load the data
  2. It does not support Aggregate expontial operations
  3. Import task Requires the usage of P.I
  4. Concatenation input data file not allowed

 

Note

Mload supports NUSI And soft Baronial Integrity

 

MLOAD Structure

.Logon<>

.Log Table<Restart Log Table>

.Begin Import Delete MLoad

Tables Table1, Table2,—Table5

Work Tables work table1, work table2,—-Work table5

Error tables ET-Table1—ET-Table5

UV-Table1—UV-Table5

.Layout<Layout Name>

.Field

.Filler

.DML Label<Label name>

<DML Operation>

.Import In file<File Name>

From m  For N thru K

Format<Fast load/Binary/text/in Format/Var text>

Layout<Layout name>

Apply<Label Name>[Where condition]

.End M Load

.Logo FF

 

.Field

.FIELD[Field Name][Start-pos Data Desc]

{NULLIF Null expr}

[Drop{Leading/trailing}{Blanks/Nulls}]

[[And]{Leading/training}{Blanks/Nulls}]

 

.FILLER

.FILLER[Field name][Start pos Desc]

 

Note

From MàStarting positions

For NàThe number of Records To Read

Thru KàTill end Record

 

Ex

6 To 8th Record

From 6 for 2 these 8

 

M Load Conditional Logic

.IF<Condition>Then;

<Statements>

.Else;

< Statements >

.End if;

 

Support Environment system variables

$Sys Date 2 System Date in the Format yy/mm/dd

$Sys Date4 2 System Date in the Format yyyy/mm/dd

$Sys Date 2 System Day in the Format Day(3)

Ex: IF Friday Then ’Fri’

$SySOS 2 HOST operating system

$Sysuser 2 Unix/mvs user

$SYSRC 2 Return code

 

 

M Load variables

$SYSDELCNT 2 Delete COUNT

$SYSINSCNT 2 INSERT COUNT

$SYSUPDCNT 2 UPDATE COUNT

$SYSETCNT 2 ERROR Table COUNT

$SYS UVCOUNT 2 UV Table COUNT

 

Releasing LOCKS in m Load

IN ACQUISION

Release m load<Table1>…..< Table 5>

 

IN APPLY

Release m load<Table1>…..< Table 5>

IN APPLY

 

NOTE

WE Can use this release m load command only in “BTEQ”

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Working with Multi Load and its Structure in TeraData"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please Enter Your Details and Query.
    Three + 6