• Home
• org.opencms
• opencms-core
• 10.5.4
• source code
• query.properties

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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

#
# DB2 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