Interested to Buy Any Domain ? << Click Here >> for more details...
Is schema the same as database?
- 0 Answers
- 1022 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the purpose of the WHENEVER statement?
What are the bind parameters ibm db2?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is the SQL query to select, delete and get count of duplicate rows in DB2?
What technique is used to retrieve data from more than one table in a single SQL statement?
what is the responsibility of the construction superintendent
What is a buffer pool?
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.
What is dbrm in db2 database?
What is the purpose of the SDSNLOAD dataset in the STEPLIB while running DB2 programs?
What are the abend codes occour in ur latest PROJECT in DB2
COBOL 
