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);
}
