Open topic with navigation

TIBCO® Patterns 6.1.2

# Looking Up Records in a Database (lkt_dbrecget)

The following command retrieves (without modifying or deleting) one or more records from a database.

    dvkerr_t lkt_dbrecget(lpar_t host, lpar_t dbname, lpar_t reckeylist,
                           lpar_t params, lpar_t *reclist );

## Input

## host (optional)

This is used to identify the server. For more information, see Communicating with TIBCO Patterns Servers

## dbname (required)

is the name of the database (LPAR_STR_DBDESCRIPTOR) from which records are retrieved.

## reckeylist (required)

The record key list for the lkt_dbrecget command is the same as described for the lkt_dbrecdelete command, see reckeylist (required) of lkt_dbrecdelete).

## params (optional)

The parameters for the lkt_dbrecget command are the same as described for the lkt_dbrecdelete command, see reckeylist (required) of lkt_dbrecdelete.

## Output

## reclist (required)

is the list of records requested.

Error codes and items returned by lkt_dbrecget

ARRAYLEN | (none) returned if too many child records found
DBNOTFOUND | database name
DUPRECKEYS | list of duplicate record keys
EXPECTDBDESC | item that should have been a database name
EXPECTLIST | item that should have been a list lpar
EXPECTRECKEY | item that should have been a record key
INTERNAL | item that was being processed at time of error
NODBDESC | (none)
NORECKEY | key with zero-length string, or (none)
NOSYSINIT | (none)
PARAMCONFLICT | parameter in conflict
PARAMTYPE | lpar that has invalid ID
PARAMVAL | Invalid key list
RECNOTFOUND | list of record keys not found
TBLNOTCHILD | Name of table that should be a child table
UPDPARAM | lpar that should have been an update parameter

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® Patterns

Copyright © 2010-2025. Cloud Software Group, Inc. All Rights Reserved.