Interested to Buy Any Domain ? << Click Here >> for more details...
SET is the ANSI standard for variable assignment, SELECT is
not.
SET can only assign one variable at a time, SELECT can make
multiple assignments at once.
If assigning from a query, SET can only assign a scalar
value. If the query returns multiple values/rows then SET
will raise an error. SELECT will assign one of the values
to the variable and hide the fact that multiple values were
returned (so you'd likely never know why something was
going wrong elsewhere - have fun troubleshooting that one)
When assigning from a query if there is no value returned
then SET will assign NULL, where SELECT will not make the
assignment at all (so the variable will not be changed from
it's previous value)
As far as speed differences - there are no direct
differences between SET and SELECT. However SELECT's
ability to make multiple assignments in one shot does give
it a slight speed advantage over SET.
- 0 Answers
- 2682 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is tablespace?
What is alias in db2?
What is a LIKE table and how is it created?
what is diffrence b/w file-aid tool and file-aid utility???
What is release/acquire in bind?
Can there be more than one cursor open for any program?
how do u update the faltfile into db2 table ?
What is the difference between primary key & unique index ?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is filter factor?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
COBOL 
