public String sqlAD_getSequences(String vendorName,String catalogName,String schemaName){
  String tableName="AD_Sequence";
  ArrayList<String> columnNames=new ArrayList<String>();
  columnNames.add("Name");
  columnNames.add("CurrentNextSys");
  columnNames.add("CurrentNext");
  ArrayList<String> aliasNames=new ArrayList<String>();
  aliasNames.add("SEQ_NAME");
  aliasNames.add("SEQ_SYS");
  aliasNames.add("SEQ_USER");
  ArrayList<String> conditions=new ArrayList<String>();
  conditions.add("IsTableID = 'Y'");
  ArrayList<String> sortColumns=new ArrayList<String>();
  sortColumns.add("1");
  return sql_select(vendorName,catalogName,schemaName,tableName,null,columnNames,aliasNames,conditions,sortColumns,false);
}

public String sqlAD_getSequences ( String vendorName , String catalogName , String schemaName ) { String tableName = "AD_Sequence" ; ArrayList < String > columnNames = new ArrayList < String > ( ) ; columnNames . add ( "Name" ) ; columnNames . add ( "CurrentNextSys" ) ; columnNames . add ( "CurrentNext" ) ; ArrayList < String > aliasNames = new ArrayList < String > ( ) ; aliasNames . add ( "SEQ_NAME" ) ; aliasNames . add ( "SEQ_SYS" ) ; aliasNames . add ( "SEQ_USER" ) ; ArrayList < String > conditions = new ArrayList < String > ( ) ; conditions . add ( "IsTableID = 'Y'" ) ; ArrayList < String > sortColumns = new ArrayList < String > ( ) ; sortColumns . add ( "1" ) ; return sql_select ( vendorName , catalogName , schemaName , tableName , null , columnNames , aliasNames , conditions , sortColumns , false ) ; }
gets the database specific sql command to find sequence counters defined in the application dictionary
