Artur Deguzman · Jan 18

Q: Need help with "into:CODE, :VALUE"

Hello all,


I just started learning SQL and am also new to Cache...


I am dealing with a simple SQL query and trying to understand the components of the following expression do:

STRING(city_name, ' - ', city_code) into :CODE, :VALUE 

I understand what the STRING function does. However, I am lost after that:

"into:CODE, :VALUE"

What do these do?



0 107
Discussion (3)1
Log in or sign up to continue

expression into :var   stores the content of the expression into a local host variable var 

in your case you seem to get from STRING(...) 2 expression stored in to variables CODE  and  VALUE

this construct is typical for embedded SQL