Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The <rowsets> tag can have the following children:

Anchor
Rowset
Rowset
<rowset> tag

Holds the request for a specific rowset.

...

The <rowset> tag can have the following children:

Anchor
Columns
Columns
<columns> tag

Holds a tag list of all the columns to load in this rowset.

...

Info

The following mandatory columns should not be sent in the load request:

  • <table shortcut>_PWHG_ID
  • <table shortcut>_RECEIVED_TIMESTAMP
  • <table shortcut>_MINUTES_COUNT_SUM

These columns are populated by the PMDB FocalPoint during the load process.


Anchor
Row
Row
<row> tag

Holds one row of loaded data. Where X is a one-digit number indicating the length of the value's length, Y is the actual length of the value, and value is the actual value. For example:

...

The first column value's length is 2, the column value's length is 12, and the column value is ABCDEFGHIJKL; the second column value's length is 1, the column value's length is 4 and the column value is 1234; and so on.

AttributeDefinition
rownumRequired. Holds the ordinal number of the row.

Anchor
Statement
Statement
<statement> tag

Holds the actual SQL command to perform.

...

Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse