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.
    • Method Summary

      All Methods Instance Methods Abstract Methods 
      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