|
View previous topic :: View next topic
|
| Author |
Message |
replytovishu
New User
Joined: 09 Dec 2008
Posts: 23
Location: india
|
|
|
|
Hi,
i am using a left outer join in a DB2 Query.
This query is unloading some data from a db2 table
i am passing this query as SYSIN DD * from a jcl.
but in the output file one extra space is coming in one of the columns.
not sure why.
Please advise. |
|
| Back to top |
|
 |
Bharath Bhat
Active User
Joined: 20 Mar 2008
Posts: 283
Location: chennai
|
|
|
|
| Post the query, Post the result. It would be helpful to come up with answers. |
|
| Back to top |
|
|
replytovishu
New User
Joined: 09 Dec 2008
Posts: 23
Location: india
|
|
|
|
SELECT SUBSTR('AA',1,2),S.ID,
I.P_ID
FROM TAB1 S
LEFT OUTER JOIN TAB2 I
ON S.P_ID = I.T_ID
AA12345ABCD1234<SPACE>
This extra space i am getting at the end...
:-( |
|
| Back to top |
|
|
muthuvel
Active User
Joined: 29 Nov 2005
Posts: 217
Location: Canada
|
|
|
|
| What is the field length of I.P_ID .did you try HEX ON .Was it Spaces when you tried HEX ON? |
|
| Back to top |
|
|
|
|
