com.ibm.tivoli.maximo.dbmanage.transform

Interface SQLSpecificTransform

All Known Implementing Classes:

DB2SqlTransform, EmptyTransform, SQLServerTransform

public interface SQLSpecificTransform

This interface is for objects that can take a SQL statement written for Maximo and return SQL that will work on a specific server. The SQL standard for Maximo is a sub-set of Oracle, using Oracle's format for sequence values and "sysdate" for the current date/time.

Author:

John Neville

Method Summary

Modifier and Type	Method and Description
java.lang.String	nextval(java.lang.String seqName)
java.lang.String	transform(java.lang.String sql) Convert Maximo SQL to specific server SQL.

Method Detail

transform

java.lang.String transform(java.lang.String sql)
                    throws java.sql.SQLException

Convert Maximo SQL to specific server SQL.

Throws:

java.sql.SQLException

nextval

java.lang.String nextval(java.lang.String seqName)
                  throws java.sql.SQLException

Parameters:

string -

Returns:

Throws:

java.sql.SQLException