|
View previous topic :: View next topic
|
| Author |
Message |
shekar.thota
New User
Joined: 21 Nov 2008
Posts: 2
Location: gurgaon
|
|
|
|
I'm trying to Unload DB2 data from a table into a sequential file. In the query i'm joining two tables with LEFT OUTER JOIN, when i select the rows from second table one extra space is comming(eg: if the field is 10 characters in a table, then 11 characters are comming in a file with one extra trailing space).
Please suggest how to modify the query to get currect length of data in a file. |
|
| Back to top |
|
 |
saiprasadh
Active User
Joined: 20 Sep 2006
Posts: 154
Location: US
|
|
|
|
Hi Shekar
Can you post the query.
Thanks
Sai |
|
| Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005
Posts: 459
Location: Belgium
|
|
|
|
| ... better the Table definition with column(s) without "NOT NULL" attribute |
|
| Back to top |
|
|
|
|
