|
View previous topic :: View next topic
|
| Author |
Message |
yincw
New User
Joined: 15 Jan 2009
Posts: 6
Location: China
|
|
|
|
Hi,
As you know, when a column in a table is nullable, when we unload this column, the unload utility will append an extra 'null indicator' next to the column in the unload file.
But I don't want this 'null indicator' in the unload file and also I don't want to change this column to NOT NULL. Is there any simple way to accomplish this?
Thanks!! |
|
| Back to top |
|
 |
Bharath Bhat
Active User
Joined: 20 Mar 2008
Posts: 283
Location: chennai
|
|
|
|
| You can use the CASEstatement. |
|
| Back to top |
|
|
yincw
New User
Joined: 15 Jan 2009
Posts: 6
Location: China
|
|
|
|
| thanks, I'll try |
|
| Back to top |
|
|
|
|
