Zoomed Image

AMSX Scripting Language - Command : xmltotemptable

Summary

Load the current XML document into a temporary database table

Description

Creates a temporary table from the XML records in the mdoc buffer and inserts all rows. Column names are derived from XML tag names. The table name must include $tempdb$ to create it in the temp database rather than the main database. The first record must contain all fields. Optionally untags field names and ignores legacy flag fields.

Parameters

ParameterDescription
cmdDestination table name (include $tempdb$ for a temp table)
Argument 0"1" or "True" to untag field names (reverse FieldTag conversion)
Argument 1"1" or "True" to ignore v6 flag fields A and B
Argument 2Comma-separated list of fields to include (blank for all fields)

Syntax


XmlToTempTable "Destination table name (include $tempdb$ for a temp table)", ""1" or "True" to untag field names (reverse FieldTag conversion)", ""1" or "True" to ignore v6 flag fields A and B", "Comma-separated list of fields to include (blank for all fields)"

Return to the AMSX Command Reference