MVSFORUMS.com

[KHerrera]

Can someone tell me what the =: statement means in the following line of code ?

WHERE
A.BUS_ASSOC_NBR = :BUS-ASSOC-NBR

[kolusu]

KHerrera,

A = table name identified in the FROM clause

BUS_ASSOC_NBR is a column name in that table

:BUS-ASSOC-NBR is working storage host variable , and the value will be populated in it before u execute the query

for ex :
move 11111 to BUS-ASSOC-NBR

this will be treated as


WHERE
A.BUS_ASSOC_NBR = 11111

now you the fetch/select statement will fetch the record with BUS-ASSOC-NBR of 1111.

[KHerrera]

so if i have an input file with 3 fields that i need to match against my table, my where clause will be like this: ?

WHERE
BUS_ASSOC_NBR = :BUS-ASSOC-NBR
OR ORG_NBR = :ORG_NBR
OR CARES_NBR = :CARES_NBR

thanks for your reply ...

[CraigG]