|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
September 1st, 2006, 02:59 AM
|
|||
|
|||
|
How to insert NULL into a Dummy Column
I want to insert NULL to a dummy column ,
ex: table A contains Columns C1 , C2 . i want to get 3 columns (2 existing columns + 1 new column - C3) , in which all the fields in C3 should be NULL . I have written query as SELECT C1,C2, NULL C3 FROM TABLE A ; The same query is executing in Oracle and inserting NULL in C3 , but it is not working in DB2 . Could you please tell me the solution
|
|
#2
September 1st, 2006, 04:24 AM
|
|||
|
|||
|
What data type should the C3 column have? E.g.
Code:
select c1,c2, cast(null as char(10)) as c3 from a
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > How to insert NULL into a Dummy Column |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
