The documentation only provides the syntax but does not provide any sample DDL for this case.
I am modifying some DB2 queries to Cache SQL but always meet some errors, please provide a sample query for this case.
Thanks.
InterSystems Caché is a multi-model DBMS and application server. See more details here.