How do you retrieve the first 5 characters of firstname column of db2 table emp?
Answer / ankit
Select substr(firstname,1,5) as firtname from emp;
| Is This Answer Correct ? | 0 Yes | 0 No |
Which catalog tables contain authorization information?
How to resolve -502 sql code in DB2?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
How do I import a csv file into db2?
What is the use of commit in db2?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What is the use of with ur in db2?
What is index cardinality?
What are PACKAGES ?
What is dbrm library?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.