How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?
Only one LONG columns is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is Extension table? 26.09.08
My understand is "base table has default colums. But Extension table is the table in which we can add additional columns other than its base tables columns I...After a table is defined, can columns be removed ? 25.07.08
The only way to remove columns from an existing table involves a migration program that extracts only the desired columns of data, redefining the table without...What is a view ? 23.07.08
If we have several tables in a db and we want to view only specific columns from specific tables we can go for views. It would also suffice the needs of securit...After a table is defined, can columns be removed ? 14.07.08
The only way to remove columns from an existing table involves a migration program that extracts only the desired columns of data, redefining the table without...How many number of columns a record group can have? 21.05.08
A record group can have an ultimate number of columns of type CHAR,LONG,NUMBER, and DATE provided that the total number of columns does not exceed 64k....How many types of columns are there and what are they? 21.05.08
Formula columns : For doing mathematical calculations and returning one value Summary Columns : For doing summary calculations such as summations etc. Place h...How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY? 17.05.08
Only one LONG column is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause....What is a clustered index ? 02.04.08
For a clustered index DB2 maintains rows in the same sequence as the columns in the index for as long as there is free space. DB2 can then process that table in...What are some characteristics of columns that benefit from indexes ? 01.04.08
Primary key and foreign key columns; columns that have unique values; columns that have aggregates computed frequently and columns used to test the existence...can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table? 21.03.08
yes possible. until the updation or selection is committed db2 table will not be restructured. new column definition will be there but it will not be included u...