Monday, July 23, 2012

Analysing “PSQRYCRITERIA” Table

 

CONDTYPE and EXPRTYPE stores below code in PSQRYCRITERIA Table.

Field: Condition Type (CONDTYPE)

Code

Description

Return Code

2

equal to

EQU

3

not equal to

EQU-

4

greater than

GRE

5

not greater than

GRE-

6

less than

LES

7

not less than

LES-

8

in list

LIS

9

not in list

LIS-

10

Between

BET

11

not between

BET-

12

Exists

EXI

13

does not exist

EXI-

14

Like

LIK

15

not like

LIK-

16

is null

NUL

17

is not null

NUL-

18

in tree

TRE

19

not in tree

TRE-

20

eff dt <=

EDLE

21

eff dt >=

EDGE

22

eff dt <

EDLT

23

eff dt >

EDGT

24

first eff dt

EDFS

25

last eff dt

EDLS

 

Field: Expression Type (EXPRTYPE)

Code

Description

Return Code

0

effective sequence

ES

1

constant

CN

2

field

FD

3

Expression

EX

4

Subquery

SQ

5

list

LS

6

current date

CD

7

tree

TR

8

Prompt

PR

9

between const-const

CC

10

between const-field

CF

11

between const-expr

CE

12

between field-const

FC

13

between field-field

FF

14

between field-expr

FE

15

between expr-const

EC

16

between expr-field

EF

17

between expr-expr

EE

18

Tree prompt

TP

Detailed Information:

Record Field Name: QRYFUNCTIONS - QRYTRANSFUNCS

1 comments:

Paula said...

Awesome! Thanks!

Post a Comment