Hello,
You cannot change varchar to character. Because this kind of conversion is not supported by DB2. As all this memory conversion functions are not allowed in DB2 storage....
nearestniladri
Last Activity: Nov 21 '07, 12:39 PM
Joined: Nov 18 '07
Location:
-
If you are using DB2 8.1 then you need to follow the following steps:
1. Go to Command Center
2. Go to script tab.
3. Write your SQL statement
4. Then goto Script menu.
5. Click on the option like Access Plan or generate access plan.Leave a comment:
-
If you want to get the first 3 rows, then your SQL statement need to be like:
select * from table_name where B<=90 fetch first 3 rows only.
Actually the statement is for fetching first n rows is:
select * from table_name fetch first n rows only.Leave a comment:
-
Hello
I think if you are using the constraint like primary key -> foreign key, then casecade option is important. If you choose that option for on delete action then it will help.Leave a comment:
-
Follow this book, this book is an ultimate one and following a good book from the very beginning is suggested
Go to download book page
over here the book from IBM Press on IBM products are called Redbooks. download a book depending on the os and DB2 product version.
ThanksLeave a comment:
No activity results to display
Leave a comment: