Yes, Virtuoso implements SQL extensions that enable the results of standard SQL queries to be transformed into XML documents, these documents are openly accessible to user agents such as Web Browsers via HTTP and/or WebDAV. It is important to note that these SQL-XML documents are URL accessible, and sensitive to the underlying changes that occur in the underlying database tables from which they have been derived.

Yes, the SQL to XML functionality sits above Virtuoso's virtual database functionality, which enables a unified logical and physical representation of database tables and views that reside in disparate database engines from different database vendors. The only requirement is that these database have to be ODBC or JDBC accessible - implying the existence of data access drivers for these databases.

A lot of data that you would typically like to use as the foundation of your web application initiatives more than likely resides in application databases that are predominantly SQL based.

Yes, you can. One way to do this is to first build a JDOM tree from your XML document, and afterwards expose JDOM tree nodes as data models. The FreeMarker-Ext library has a class that can wrap JDOM nodes to expose them to FM-Classic as a template model. In order to wrap your JDOM document tree in a FM-Classic TemplateModel, it is sufficient to do the following: ... org.jdom.Document document = getMyDocumentSomehow(...); TemplateModel model = new freemarker.ext.jdom.NodeListModel(document); ..

Q: Why can't GnuCash find my data file anymore? It just says: parser error : Start tag expected, '<' not found

The same as you create documents that don't use XML namespaces. If you're currently using Notepad on Windows or emacs on Linux, you can continue using Notepad or emacs. If you're using an XML editor that is not namespace-aware, you can also continue to use that, as qualified names are legal names in XML documents and xmlns attributes are legal attributes.

Include EXPLAIN command in the embedded dynamic SQL statements 52.How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)

It is easy to create the template using the wizard. Just click the More button at the last wizard step and select the Save Template item to save the current configuration. Use Data Export Wizard to export data to any of the 14 available formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX, and SQL. Data Import Wizard allows you to import data into MS SQL Server tables from the following available formats: MS Excel, MS Access, XML, DBF, TXT and CSV.

When building up a single SQL statement in a string, do not include any semicolon at the end (inside the quotation marks). When building up a PL/SQL anonymous block, include the semicolon at the end of each PL/SQL statement and at the end of the anonymous block. You will have a semicolon right before the end of the string literal, and another right after the closing single quotation mark.

The Global Justice XML Data Model (Global JXDM) is an object-oriented data model for organizing the content of a data dictionary, the Global JXDD, in a database. From this database an XML schema specification can be generated that consistently represents the semantics and structure of common data elements and types required to exchange information within the justice and public safety communities. The first version (1.

A major benefit of XML is its ability to provide an open format for data representation, exchange, protocol and application modeling. By using XML as a uniform data interface to disparate data sources, it becomes much easier to cost-effectively develop and deploy next generation web applications; increasingly these applications will depend on data hosted in a variety of databases and data sources.

Starting from Oracle8i one can use the "EXECUTE IMMEDIATE" statement to execute dynamic SQL and PL/SQL statements (statements created at run-time). Look at these examples. Note that the statements within quotes are NOT semicolon terminated: EXECUTE IMMEDIATE 'CREATE TABLE x (a NUMBER)'; -- Using bind variables... sql_stmt := 'INSERT INTO dept VALUES (:1, :2, :3)'; EXECUTE IMMEDIATE sql_stmt USING dept_id, dept_name, location; -- Returning a cursor..

Hi there - I am new to Oracle (used to Ingres).I am having trouble creating a database.I keep getting the following oracle errors.ORA-01501ORA-01519ORA-00604ORA-30012Can you tell me what I am doing incorrectly?Many thankseibbed

Using the DTS ActiveX Script Task it is pretty easy to accomplish something like this. Here is a script that I used to create a Package which was scheduled and executed successfully. '********************************************************************** ' Visual Basic ActiveX Script '************************************************************************ Function Main() Dim oCmd, sSQL, oDom ''' If MSXML 4.0 is not installed this will not work! Set oDom = CreateObject("Msxml2.DOMDocument.4.

I played hooky and ploughed through the Metro specification. Interesting. I satisfied myself that there are ways to anticipate this format in some "package" applications I have in mind, and they should be able to be Metro hybrids in the future. I know what names not to use to avoid future collisions, in particular [;<).

The WithXmlDoc example in bakery/examples/ shows how to subclass from Document_XML so that your Document can use an XML format. This document explains how to use Document_XML. Don't worry, you don't need to do much of it. And it is very useful in this case. Bakery classes do not need to inherit from classes that share a common base class (Bakery::View is not a Gtk widget) so the situation is not complicated.

To disable validation you will need to pass the xml_schema::flags::dont_validate flag to one of the parsing functions, as described in Section 5.1, "XML Schema Validation and Searching" in the C++/Tree Mapping Getting Started Guide.

In order to index XML documents you need to first parse them to extract text that you want to index from them. Here are some XML parsers that can help...

Your hints about dynamic creation of arrays work fine for one-dimensional arrays. But I need a global matrix. There is no problem if the matrix is small. But, if I simply put int A[200][100] = {{}}; I will increase the size of my program by about 40K (200*100*sizeof(int)). This is really unacceptable. Obviously, I need to create a matrix dinamically. But I have no any idea how to do this. Very good question. Solving this problem requires good knowledge about how arrays and pointers are related.

XML is a meta-language optimized for use on the Internet. A meta-language provides a way to create other languages or vocabularies. Many applications use XML as a way of sharing data between otherwise incompatible systems.