Collection is gathering together several transactions, or pieces of those transactions, and placing them into one larger transaction. Use collection when an application endpoint requires a single transaction containing data sent by several different acquisition AIMs. For example, an endpoint that generates patient billing may require selected information from lab, pharmacy, and admitting applications.
TRAN-IDE provides the dbInsert, dbDiskList, dbSelect, and dbDelete built-in filter functions and the dbExist and dbNotExist built-in qualification functions to facilitate collection.
dbInsert – copies the contents of the current message area to the referenced collection file.
dbSelect – copies the specified entry from the referenced collection file to the current message area in the production object.
dbDiskList – finds all key fields that fit a certain search mask.
dbDelete – deletes the specified entry from the referenced collection file.
dbExist – verifies the existence of data in the specified collection file.
dbNotExist – verifies that data does not exist in the specified collection file.
Production objects gather the different pieces of data from the various incoming transactions and use the dbInsert filter to store them in collection files on the network server or on a personal computer workstation. If desired, use dbNotExist before using dbInsert to determine if the insertion will copy over data already present in the collection file. Once all the pieces of data are present, use dbDiskList to list all the relevant files and dbSelect to collect all relevant data from these files and send the output transaction to a delivery AIM. If necessary, use dbExist to verify whether data is present in the collection file before calling dbSelect. Use dbDelete to remove data from a collection file.
To use a database to perform collection, use the Database filter. You can create a database interface object that includes SQL statements to manipulate the transaction elements. See the e-Biz Impact ODL Guide for more information.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
