public String getSqlSelectTenantDistinctClassCode() { if (S_sqlSelectTenantDistinctClassCode == null) { S_sqlSelectTenantDistinctClassCode = "SELECT " + "DISTINCT tent.ClassCode " + "FROM " + schema.getLowerDbSchemaName() + "..tenant AS tent "; } return (S_sqlSelectTenantDistinctClassCode); }
public String getSqlSelectTSecGroupDistinctClassCode() { if (S_sqlSelectTSecGroupDistinctClassCode == null) { S_sqlSelectTSecGroupDistinctClassCode = "SELECT " + "DISTINCT tgrp.ClassCode " + "FROM " + schema.getLowerDbSchemaName() + "..TSecGrp AS tgrp "; } return (S_sqlSelectTSecGroupDistinctClassCode); }
public String getSqlSelectTenantBuff() { if (S_sqlSelectTenantBuff == null) { S_sqlSelectTenantBuff = "SELECT " + "tent.id, " + "tent.clusterid, " + "tent.tenantname, " + "tent.revision " + "FROM " + schema.getLowerDbSchemaName() + "..tenant AS tent "; } return (S_sqlSelectTenantBuff); }
public String getSqlSelectTSecGroupBuff() { if (S_sqlSelectTSecGroupBuff == null) { S_sqlSelectTSecGroupBuff = "SELECT " + "tgrp.tenantid, " + "tgrp.tsecgroupid, " + "tgrp.name, " + "tgrp.revision " + "FROM " + schema.getLowerDbSchemaName() + "..TSecGrp AS tgrp "; } return (S_sqlSelectTSecGroupBuff); }