Saturday, May 24, 2014
PeopleSoft IB message transaction table names,
/* Formatted on 2014/04/30 09:41 (Formatter Plus v4.8.7) */
SELECT ibtransactionid, ib_segmentindex, ib_operationname, ibpubtransactid,
actionname, pubnode, queuename, queueseqid, subqueue, trxtype,
versionname, createdttm, publishtimestamp, actionowner, conversationid,
inreplytoid, isrequest, routingdefnname, subconstatus, statusstring,
lastupddttm, retrycount, machinename, slaveprocessname, ib_slavequeued,
tuxdomain, processid
FROM psapmsgsubcon
/* Formatted on 2014/04/30 09:42 (Formatter Plus v4.8.7) */
SELECT ibtransactionid, ib_segmentindex, subnode, ibpubtransactid,
ib_sendpubid, pubnode, queuename, queueseqid, subqueue, createdttm,
publishtimestamp, trxtype, ib_operationname, versionname,
conversationid, canonicaltrsfrmid, inreplytoid, isrequest,
routingdefnname, pubconstatus, statusstring, lastupddttm, retrycount,
machinename, slaveprocessname, ib_slavequeued, tuxdomain, processid,
nrid
FROM psapmsgpubcon
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment