Home
PowerLoader
PowerLoader provides several transactions for uploading and managing large tables. For tables larger than tens of thousands of rows, use the addtab transaction in favor of the upload transaction.
Column display format types
A column's display format may be one of the following:

PowerLoader
PowerLoader provides several transactions for uploading and managing large tables. For tables larger than tens of thousands of rows, use the addtab transaction in favor of the upload transaction.
- addtab (Load a large table)
  The addtab transaction loads a table into the 1010data system.
- killaddtable (Kills an ongoing load process)
  The killaddtable transaction kills an ongoing asynchronous load job (an addtab command with <sync>0</sync>).
- status (Status of the addtab API)
  The status transaction reports the status of an asynchronous addtab transaction (an addtab command with <sync>0</sync>). The return code indicates the state of the load process.
- convert (Convert a legacy spec)
  The convert transaction will parse and convert a legacy PowerLoader spec file into XML.
- validate (Validate a table)
  The validate transaction will parse and validate the XML spec input to addtab.
- edittab (Edit a table)
  The edittab transaction changes the table metadata (table information acquired via tabinfo).
- Column data types
  A column's data type may be one of the following:
- Column display format types
  A column's display format may be one of the following:

Column display format types

A column's display format may be one of the following:

`char`	Alphanumeric Text
`num`	Number: 1,234,567.89
`nocommas`	Number: 1234567.89
`date`	Date: 10/15/98
`month`	Month/Year: 10/03
`quarter`	Quarter/Year: 2Q03
`hms24`	Time: 22:45:56
`datehms24`	Date+Time: 10/15/98_22:45:56