All Downloads are FREE. Search and download functionalities are using the official Maven repository.

org.opencms.db.as400.query.properties Maven / Gradle / Ivy

Go to download

OpenCms is an enterprise-ready, easy to use website content management system based on Java and XML technology. Offering a complete set of features, OpenCms helps content managers worldwide to create and maintain beautiful websites fast and efficiently.

There is a newer version: 18.0
Show newest version
#
# AS400 doesn't support column expressions in the RHS of a "LIKE" expression 
#
C_READ_RESOURCE_OUS=\
SELECT DISTINCT \
	${C_RELATIONS_SELECT_ATTRIBS} \
FROM \
	CMS_${PROJECT}_RESOURCE_RELATIONS \
WHERE \
    CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TYPE = ? \
    AND LOCATE(CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_PATH, CAST(? AS VARCHAR(1024))) = 1




© 2015 - 2024 Weber Informatics LLC | Privacy Policy