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



Start 2Run  2 M Load

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



  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



Mload supports NUSI And soft Baronial Integrity


MLOAD Structure


.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


.Layout<Layout Name>



.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 Name][Start-pos Data Desc]

{NULLIF Null expr}





.FILLER[Field name][Start pos Desc]



From MàStarting positions

For NàThe number of Records To Read

Thru KàTill end Record



6 To 8th Record

From 6 for 2 these 8


M Load Conditional Logic




< 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







Releasing LOCKS in m Load


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



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




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, 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 *


Please Enter Your Details and Query.
Three + 6