Answer / s

Each column value is interpreted based on the data typed
defined for the column

Answer / sikander

In programming, classification of a particular type of
information. It is easy for humans to distinguish between
different types of data. We can usually tell at a glance
whether a number is a percentage, a time, or an amount of
money. We do this through special symbols -- %, :, and $ --
that indicate the data's type. Similarly, a computer uses
special internal codes to keep track of the different types
of data it processes.
Most programming languages require the programmer to
declare the data type of every data object, and most
database systems require the user to specify the type of
each data field. The available data types vary from one
programming language to another, and from one database
application to another, but the following usually exist in
one form or another:

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.

1 Answers  

---

What is SPUFI?

4 Answers  

---

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

0 Answers  

---

What does db2 blu stand for?

0 Answers  

---

What is subquery ?

6 Answers  

---

5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  

---

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

---

What is db2 command?

0 Answers  

---

What is COPY PENDING status?

6 Answers  

---

Describe the elements of the SELECT query syntax?

3 Answers  

---

quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  

---

what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,

---