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 |
| * | * |