public String getSqlSelectISOCountryDistinctClassCode() {
if (S_sqlSelectISOCountryDistinctClassCode == null) {
S_sqlSelectISOCountryDistinctClassCode =
"SELECT "
+ "DISTINCT isoc.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..iso_cntry AS isoc ";
}
return (S_sqlSelectISOCountryDistinctClassCode);
}
public String getSqlSelectSecAppDistinctClassCode() {
if (S_sqlSelectSecAppDistinctClassCode == null) {
S_sqlSelectSecAppDistinctClassCode =
"SELECT "
+ "DISTINCT sapp.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..SecApp AS sapp ";
}
return (S_sqlSelectSecAppDistinctClassCode);
}
public String getSqlSelectISOTimezoneDistinctClassCode() {
if (S_sqlSelectISOTimezoneDistinctClassCode == null) {
S_sqlSelectISOTimezoneDistinctClassCode =
"SELECT "
+ "DISTINCT itzn.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..ISOTz AS itzn ";
}
return (S_sqlSelectISOTimezoneDistinctClassCode);
}
public String getSqlSelectISOCountryBuff() {
if (S_sqlSelectISOCountryBuff == null) {
S_sqlSelectISOCountryBuff =
"SELECT "
+ "isoc.id, "
+ "isoc.iso_code, "
+ "isoc.country_name, "
+ "isoc.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..iso_cntry AS isoc ";
}
return (S_sqlSelectISOCountryBuff);
}
public String getSqlSelectSecAppBuff() {
if (S_sqlSelectSecAppBuff == null) {
S_sqlSelectSecAppBuff =
"SELECT "
+ "sapp.clusterid, "
+ "sapp.secappid, "
+ "sapp.jeemountname, "
+ "sapp.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..SecApp AS sapp ";
}
return (S_sqlSelectSecAppBuff);
}
public String getSqlSelectSecFormBuff() {
if (S_sqlSelectSecFormBuff == null) {
S_sqlSelectSecFormBuff =
"SELECT "
+ "sfrm.clusterid, "
+ "sfrm.secformid, "
+ "sfrm.secappid, "
+ "sfrm.jeeservletmapname, "
+ "sfrm.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..SecForm AS sfrm ";
}
return (S_sqlSelectSecFormBuff);
}
public String getSqlSelectISOTimezoneBuff() {
if (S_sqlSelectISOTimezoneBuff == null) {
S_sqlSelectISOTimezoneBuff =
"SELECT "
+ "itzn.isotimezoneid, "
+ "itzn.iso8601, "
+ "itzn.tzname, "
+ "itzn.tzhouroffset, "
+ "itzn.tzminoffset, "
+ "itzn.description, "
+ "itzn.visible, "
+ "itzn.revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ "..ISOTz AS itzn ";
}
return (S_sqlSelectISOTimezoneBuff);
}
