Interested to Buy Any Domain ? << Click Here >> for more details...
How do you concatenate the firstname and lastname from emp table to give a complete name?
- 0 Answers
- 1035 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
When is the access path determined for dynamic SQL?
What is a system catalog table in db2?
How to select the duplicate rows from a table?
What do you mean by cursor?
How do I add a column to an existing table in db2?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
What is the FREE command?
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 .
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
What Utility is used to migrate DB2 from one release to the next?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
COBOL 
