IBM Sterling B2B: SELECT Queue, Lifespan, PersistentLevel of Business Process: Difference between revisions
(Criou a página com " SELECT wfd.NAME, wfd.EXECNODE, wfd.PRIORITY QUEUE, wfd.LIFE_SPAN, wfd.PERSISTENCE_LEVEL FROM WFD wfd, wfd_versions wfdv WHERE wfd.WFD_ID=wfdv.WFD_ID and wfd.wfd_version...") |
No edit summary |
||
Line 2: | Line 2: | ||
SELECT wfd.NAME, wfd.EXECNODE, wfd.PRIORITY QUEUE, wfd.LIFE_SPAN, wfd.PERSISTENCE_LEVEL | SELECT wfd.NAME, wfd.EXECNODE, wfd.PRIORITY QUEUE, wfd.LIFE_SPAN, wfd.PERSISTENCE_LEVEL | ||
FROM WFD wfd, wfd_versions wfdv | FROM WFD wfd, wfd_versions wfdv | ||
WHERE wfd.WFD_ID=wfdv.WFD_ID and wfd.wfd_version = wfdv.WFD_VERSION and wfd.WFD_VERSION=wfdv.DEFAULT_VERSION | WHERE wfd.WFD_ID=wfdv.WFD_ID and wfd.wfd_version = wfdv.WFD_VERSION and wfd.WFD_VERSION=wfdv.DEFAULT_VERSION | ||
Where PERSISTENCE_LEVEL | Where PERSISTENCE_LEVEL |
Latest revision as of 10:20, 17 April 2021
SELECT wfd.NAME, wfd.EXECNODE, wfd.PRIORITY QUEUE, wfd.LIFE_SPAN, wfd.PERSISTENCE_LEVEL FROM WFD wfd, wfd_versions wfdv WHERE wfd.WFD_ID=wfdv.WFD_ID and wfd.wfd_version = wfdv.WFD_VERSION and wfd.WFD_VERSION=wfdv.DEFAULT_VERSION
Where PERSISTENCE_LEVEL
PERSISTENCE_LEVEL | Human Value |
---|---|
0 | SystemDefault |
1 | Full |
3 | StepStatusEMO |
4 | StartStopEMO |
5 | StepStatusOnly |
8 | StartStop |
9 | Zero |
10 | ErrorOnly |
* | * |