A B C D E F G I L Q S U X

A

addToKeyColumns(String) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Adds to the list of the key column names that will be used in building the where-clause for UPDATE or DELETE.
addToUpdateColumns(String) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Adds to the list of the column names that will be updated or inserted.

B

BaseProperties - class com.ibm.etools.sqltoxml.BaseProperties.
This class provides database connection information for SQL and XML.
BaseProperties() - Constructor for class com.ibm.etools.sqltoxml.BaseProperties
The default constructor.

C

com.ibm.etools.sqltoxml - package com.ibm.etools.sqltoxml
 
com.ibm.etools.xmltosql - package com.ibm.etools.xmltosql
 

D

DELETE - Static variable in class com.ibm.etools.xmltosql.SQLProperties
SQL DELETE action type.

E

execute() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Executes a query based on information from QueryProperties given as the constructor argument.
execute(Document, boolean) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Updates a table from a DOM Document.
execute(InputStream) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Updates a table from an XML input stream.
execute(InputStream, boolean) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Updates a table from an XML input stream.
execute(PrintWriter, String, String, PrintWriter) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Deprecated. Executes a query based on information from QueryProperties and the results are written to the PrintWriters and/or files. When any argument other than 'xml' is null, no result is generated for that particular argument. Also, if both dtdfile and xsdfile are specified, only xsdfile is generated.
execute(String) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Updates a table from an XML file.
execute(String, boolean) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Updates a table from an XML file.
execute(String, PrintWriter, String, String, PrintWriter) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Deprecated. Executes a query based on information from QueryProperties and the results are written to the PrintWriters and/or files. When any argument other than 'xml' is null, no result is generated for that particular argument. Also, if both dtdfile and xsdfile are specified, only xsdfile is generated. This method is used when the query contains a where-clause and its constraints are given in 'params' String argument. These constraint parameters are delimited using comma (,) in the argument.
execute(String, String, String, String) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Deprecated. Executes a query based on information from QueryProperties and the results are written to the files. When any argument other than 'xml' is null, no result is generated for that particular argument. Also, if both dtdfile and xsdfile are specified, only xsdfile is generated.

F

finalize() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Closes the connection if it was created by SQLToXML.
finalize() - Method in class com.ibm.etools.xmltosql.XMLToSQL
Closes the connection if this was created internally.

G

getAction() - Method in class com.ibm.etools.xmltosql.SQLProperties
Returns the action to be performed by XMLToSQL
getConnection() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns a database connection.
getCurrentDocument() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns the XML document that is a result of the most recent call to the execute() method.
getCurrentDocuments() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns the XML documents array that is a result of the most recent call to the execute() method.
getDTDFile() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns current DTD file name to be generated.
getEncoding() - Method in class com.ibm.etools.sqltoxml.BaseProperties
Returns the Java style encoding value for the properties file.
getEncodingTag() - Method in class com.ibm.etools.sqltoxml.BaseProperties
Returns the encoding value for the properties file to be written if store() is called.
getFailedStatements() - Method in class com.ibm.etools.xmltosql.XMLToSQL
Returns a collection of SQL statements that have been failed during execution.
getFormat() - Method in class com.ibm.etools.sqltoxml.QueryProperties
Returns a format option.
getJdbcDriver() - Method in class com.ibm.etools.sqltoxml.BaseProperties
Returns a JDBC driver name.
getJdbcServer() - Method in class com.ibm.etools.sqltoxml.BaseProperties
Returns a JDBC server path.
getLoginId() - Method in class com.ibm.etools.sqltoxml.BaseProperties
Returns a database user ID that has the appropriate privilege to perform the query.
getNextAllQuery() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns a valid query string.
getNextQueries() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns a sequence of valid query strings.
getParameters() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns the parameter values for the where-clause.
getPassword() - Method in class com.ibm.etools.sqltoxml.BaseProperties
Returns a password for the user ID that has the appropriate privilege to perform the query.
getRecurse() - Method in class com.ibm.etools.sqltoxml.QueryProperties
Returns a boolean value indicating whether or not the queries should also be performed on the target tables when foreign key columns from the current query are found.
getSchema() - Method in class com.ibm.etools.xmltosql.SQLProperties
Returns the schema name.
getStatement() - Method in class com.ibm.etools.sqltoxml.QueryProperties
Returns current SQL statement to be executed.
getTableName(InputStream) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Returns the database table name to be updated.
getTableName(String) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Returns the database table name to be updated.
getVarTypes() - Method in class com.ibm.etools.sqltoxml.QueryProperties
Deprecated. Returns a sequence of substitution parameter types. VarTypes are used when a SQL statement contains substitution parameters, such as '?', and the user wants to indicate the data types for those parameters explicitly.
getXMLFile() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns current XML file name to be generated.
getXMLWriter() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns current PrintWriter for the XML output.
getXSDFile() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns current XML schema file name to be generated.
getXSLFile() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns current XSL file name to be generated.
getXSLWriter() - Method in class com.ibm.etools.sqltoxml.SQLToXML
Returns current PrintWriter for the XSL output.

I

INSERT - Static variable in class com.ibm.etools.xmltosql.SQLProperties
SQL INSERT action type.

L

load(InputStream) - Method in class com.ibm.etools.sqltoxml.BaseProperties
Loads database operation values from an InputStream.
load(InputStream) - Method in class com.ibm.etools.sqltoxml.QueryProperties
Loads necessary query values from an InputStream.
load(InputStream) - Method in class com.ibm.etools.xmltosql.SQLProperties
Loads necessary database manipulation values from an InputStream.
load(String) - Method in class com.ibm.etools.sqltoxml.BaseProperties
Loads database operation values from an external file.
load(String) - Method in class com.ibm.etools.sqltoxml.QueryProperties
Loads necessary query values from a query file.
load(String) - Method in class com.ibm.etools.xmltosql.SQLProperties
Loads necessary database manipulation values from an external file.

Q

QueryProperties - class com.ibm.etools.sqltoxml.QueryProperties.
This class provides information necessary for SQLToXML to perform its SQL query and generate an XML file as well as several other artifacts.
QueryProperties() - Constructor for class com.ibm.etools.sqltoxml.QueryProperties
The default constructor.

S

setAction(String) - Method in class com.ibm.etools.xmltosql.SQLProperties
Sets the action to be performed by XMLToSQL.
setConnection(Connection) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Provides a JDBC connection to be used for generating the XML files.
setConnection(Connection) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Provides a JDBC connection to be used for updating the tables.
setDTDFile(String) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Sets the DTD file name to be generated.
setEncoding(String) - Method in class com.ibm.etools.sqltoxml.BaseProperties
Sets the Java style encoding value for the properties file to be written if store() is called.
setEncodingTag(String) - Method in class com.ibm.etools.sqltoxml.BaseProperties
Sets the encoding value for the properties file to be written if store() is called.
setFormat(String) - Method in class com.ibm.etools.sqltoxml.QueryProperties
Sets a format option.
setGenDocType(boolean) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Deprecated. Controls whether or not to generate a DTD or an XML schema file for validation purposes.
setIndenting(boolean) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Sets indentation on and off.
setJdbcDriver(String) - Method in class com.ibm.etools.sqltoxml.BaseProperties
Sets a JDBC driver name.
setJdbcServer(String) - Method in class com.ibm.etools.sqltoxml.BaseProperties
Sets a JDBC server path.
setLoginId(String) - Method in class com.ibm.etools.sqltoxml.BaseProperties
Sets a database user ID that has a privilege to perform the query.
setMaxRows(int) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Sets the limit for the maximum number of rows to be retrieved in the generated XML.
setParameters(String) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Sets the parameter values for the where-clause.
setPassword(String) - Method in class com.ibm.etools.sqltoxml.BaseProperties
Sets a password for the user ID that has a privilege to perform the query.
setQueryProperties(QueryProperties) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Overrides current QueryProperties.
setRecurse(boolean) - Method in class com.ibm.etools.sqltoxml.QueryProperties
Sets a boolean value indicating whether or not the queries should also be performed on the target tables when foreign key columns from the current query are found.
setSchema(String) - Method in class com.ibm.etools.xmltosql.SQLProperties
Sets the schema name if required.
setStatement(String) - Method in class com.ibm.etools.sqltoxml.QueryProperties
Sets current SQL statement.
setTargetNamespace(String) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Sets the target namespace of the generated XML.
setTrace(boolean) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Sets the trace flag.
setTrace(boolean, PrintWriter) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Sets the trace flag.
setVarTypes(Vector) - Method in class com.ibm.etools.sqltoxml.QueryProperties
Deprecated. VarTypes are used when a SQL statement contains substitution parameters, such as '?', and the user wants to indicate the data types for those parameters explicitly.
setXMLFile(String) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Sets the XML file name to be generated.
setXMLWriter(PrintWriter) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Sets the PrintWriter to which the generated XML is directed.
setXSDFile(String) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Sets the XML schema file name to be generated.
setXSLFile(String) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Sets the XSL file name to be generated.
setXSLWriter(PrintWriter) - Method in class com.ibm.etools.sqltoxml.SQLToXML
Sets the PrintWriter to which the generated XSL is directed.
SQLProperties - class com.ibm.etools.xmltosql.SQLProperties.
This class is used to provide data necessary for XMLToSQL to update database tables.
SQLProperties() - Constructor for class com.ibm.etools.xmltosql.SQLProperties
The default constructor.
SQLToXML - class com.ibm.etools.sqltoxml.SQLToXML.
This class provides methods used by applications (such as the SQL to XML wizard) to perform database queries.
SQLToXML(QueryProperties) - Constructor for class com.ibm.etools.sqltoxml.SQLToXML
This is the only constructor.
store(String) - Method in class com.ibm.etools.sqltoxml.BaseProperties
Stores database operation information to an external file.
store(String) - Method in class com.ibm.etools.sqltoxml.QueryProperties
Stores necessary query values to a query file.
store(String) - Method in class com.ibm.etools.xmltosql.SQLProperties
Stores database manipulation values to an external file.

U

UPDATE - Static variable in class com.ibm.etools.xmltosql.SQLProperties
SQL UPDATE action type.
updateMultipleRows(String, Vector) - Method in class com.ibm.etools.xmltosql.XMLToSQL
Determines if multiple rows would be updated/deleted once any of the execute() method was called.

X

XMLToSQL - class com.ibm.etools.xmltosql.XMLToSQL.
XMLToSQL is used to insert, update, or delete rows in a database table using an XML document.
XMLToSQL(SQLProperties) - Constructor for class com.ibm.etools.xmltosql.XMLToSQL
This is the only constructor.

A B C D E F G I L Q S U X