sachinmallya83
New User
Joined: 27 Jan 2008 Posts: 4 Location: mumbai
|
|
|
|
Hi,
I am unloading DB2 table using SYNCSORT by passing following querry
SELECT *
FROM table
WHERE NAME='ABC'
O/P file contains each field value followed by a Null Indicator(1 Byte).
How can we replace null vaues by spaces/zeros(while querrying itself)? |
|