DB2 left outer join

5 pts.
Tags:
DB2
Left outer join is giving spaces between the values of 2 columns, how to get the output without any space in between, tried using '||' but getting error on CURRENT DATE field?


Software/Hardware used:
DB2, SQL
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Assuming this is course related specially on DB2, You can read your study books and you can gather more and more knowledge on the same. However, you can link here for more info: http://www.ibm.com/support/knowledgecenter/SSEPEK_10.0.0/intro/src/tpc/db2z_joindatafromtables.html
    130,580 pointsBadges:
    report
  • ToddN2000
    If you are doing a select and using a join for a second table and selecting form both, that's fine. Where are you seeing the space between columns? In a data grid or other option. Have you tried defining a new field in the select that combine the 2 columns into one? Can you post your SQL?
    125,805 pointsBadges:
    report
  • carlosdl
    The outer join itself has most likely nothing to do with the spaces you mention, since it produces data in separate columns, without any "separator".

    The problem is most likely being caused by something else you are doing the query, or after executing the query, on the application side.

    Without more details, it would be really difficult to help you.
    84,580 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: