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?
Thanks!
Deguza
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
Here's some documentation on the INTO clause.
As Robert already said, though, it's a way to do an embedded query and store the result columns into variables in the host language.
Robert and David,
Thank you both!
Deguza