List out the data types available.
- 1 Answers
- 1232 Views
- I also Faced
- E-Mail Answers
Answer / Chhaya Singh
DB2 supports a wide variety of data types, including character strings (CHAR, VARCHAR), numeric data (DECIMAL, NUMERIC), date and time data (DATE, TIME, TIMESTAMP), logical values (LOGICAL), binary data (RAW, BLOB), and user-defined data types (UDT).
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the syntax required for the creation of a cursor?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
What keyword does an SQL SELECT statement use for a string search?
What is DB2 (IBM Database 2)?
What are the various data types available in db2?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is collection in db2 bind?
What does sqlcabc has?
What is deadlock?
What are the different types of base tables?
What is an alias?
How do you insert a record with a nullable column?
COBOL 
