Informix Experts

From archive: October 2007

Global Control of Temp Table Logging

cheetahblog Tags: table temp logging control ‎ 3 Comments ‎ 4,655 Views

In previous IDS versions, the logging mode of the temp table matches the logging mode of the database in which theyare created. In other words, temp tables created in a logged database will be logging by default and temp tables created in a non-logged database will be non-logging by default. If you do not want your temp tables to be loggingin your logged database you have to use the "with no log" clause when you create it.

For example the following SQL creates the temp table temptab1 with no logging.

create temp table temptab1 with no log;

In IDS 11, you can control the default logging mode of temporary tables. If you set the configuration parameter TEMPTAB_NOLOG to 1, temp tables created in a logged database will be non-logging by default. This is useful inreplication environments where you create your databases logged but do not want to replicate your temp tables.

If TEMPTAB_NOLOG is set to 0, this feature is disabled.

Suma Vinod

[Read More]

XML Support in IDS 11 - Part 1

cheetahblog Tags: sql xml ‎ 2 Comments ‎ 3,499 Views

IDS 11 provides support for XML publishing thus enabling applications to publish SQL results as XML, query XML dataand return XML. It also provides the framework to map an XML schema into a relational schema and to shred an XML document into relational tables.

The XML functions available in IDS 11 are summarized in the following table:

Function Name	Description
genxml,genxmlclob	return SQL results as XML elements
genxmlelem, genxmlelemclob	return column values as XML elements
genxmlschema,genxmlschemaclob	return schema as XML
genxmlquery, genxmlqueryclob	return result set as XML
genxmlqueryhdr, genxmlqueryhdrclob	return result set as XML with head
extract, extractxmlclob	evaluate XPATH expression
extractvalue, extractxmlclobvalue	return value of XML node
existsnode	verify whether a node exists in XML doc
idsxmlparse	parse XML doc to determine if it is well-formed

To use the XML functions in IDS 11:

Start an XML VP by doing one of the following

Add VPCLASS idsxmlvp,num=1 in onconfig file to start the XML VP when the server starts

OR

Use onmode -p +1 idsxmlvp command to add an XML VP dynamically after the server has started

Note: An XML VP is required only if you use XPATH functions such as extract(), extractxmlclob(), extractvalue(),
extractxmlclobvalue(),existsnode(), idsxmlparse(). XML functions starting with gen do not require the XML VP.
Verify that $INFORMIXDIR/lib/libxml.udr is read-only
Make sure a default sbspace exists.

Default sbspace is specified by the SBSPACENAME configuration parameter. You can check the output of onstat -d to
verify that the space exists.

I will talk about each of the above functions with examples in Part 2.

Suma Vinod[Read More]

Feed for Blog Entries Feed for Blog Comments

Blogs