The following SQL script invokes the toSqlScript( ) method in Adaptive Server and then creates and populates a table with a copy of the result set data.
declare @rsx xml.resultset.ResultSetXml
select @rsx = rs_doc from resultset_docs where id=1
select @script = @rsx>>toSqlScript(“resultset_copy”,
“column_”, “no”)
declare @I integer
select @I = util.ExecSql.statement(@script, “”)
