TL_SQL_BIND_LNG

(SQL Table)
 Index Back

Bind Mappings for Where Exprs

This table holds Bind mappings for a Sub-Query used as an operand in a where expression.

  • Related Language Record for TL_SQL_BINDS

  • Parent record: TL_SQL_WHERE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SQL_ID Character(30) VARCHAR2(30) NOT NULL TL

    Prompt Table: TL_SQL_OBJECT

    2 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
    3 BINDNUM Character(2) VARCHAR2(2) NOT NULL Bind Number - Used for TL Sub Queries
    1=:1
    2=:2
    3=:3
    4=:4
    5=:5
    6=:6
    7=:7
    8=:8
    9=:9
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description