public String getSqlSelectAccessSecurityDistinctClassCode() {
if (S_sqlSelectAccessSecurityDistinctClassCode == null) {
S_sqlSelectAccessSecurityDistinctClassCode =
"SELECT "
+ "DISTINCT asec.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".accsec AS asec ";
}
return (S_sqlSelectAccessSecurityDistinctClassCode);
}
public String getSqlSelectURLProtocolDistinctClassCode() {
if (S_sqlSelectURLProtocolDistinctClassCode == null) {
S_sqlSelectURLProtocolDistinctClassCode =
"SELECT "
+ "DISTINCT uprt.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".URLProto AS uprt ";
}
return (S_sqlSelectURLProtocolDistinctClassCode);
}
public String getSqlSelectAccessFrequencyDistinctClassCode() {
if (S_sqlSelectAccessFrequencyDistinctClassCode == null) {
S_sqlSelectAccessFrequencyDistinctClassCode =
"SELECT "
+ "DISTINCT afrq.ClassCode "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".accfreq AS afrq ";
}
return (S_sqlSelectAccessFrequencyDistinctClassCode);
}
public String getSqlSelectAccessSecurityBuff() {
if (S_sqlSelectAccessSecurityBuff == null) {
S_sqlSelectAccessSecurityBuff =
"SELECT "
+ "asec.Id, "
+ "asec.Name, "
+ "asec.Revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".accsec AS asec ";
}
return (S_sqlSelectAccessSecurityBuff);
}
public String getSqlSelectAccessFrequencyBuff() {
if (S_sqlSelectAccessFrequencyBuff == null) {
S_sqlSelectAccessFrequencyBuff =
"SELECT "
+ "afrq.Id, "
+ "afrq.Name, "
+ "afrq.Revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".accfreq AS afrq ";
}
return (S_sqlSelectAccessFrequencyBuff);
}
public String getSqlSelectURLProtocolBuff() {
if (S_sqlSelectURLProtocolBuff == null) {
S_sqlSelectURLProtocolBuff =
"SELECT "
+ "uprt.URLProtocolId, "
+ "uprt.Name, "
+ "uprt.Description, "
+ "uprt.IsSecure, "
+ "uprt.Revision "
+ "FROM "
+ schema.getLowerDbSchemaName()
+ ".URLProto AS uprt ";
}
return (S_sqlSelectURLProtocolBuff);
}