Topic
  • 1 reply
  • Latest Post - ‏2008-12-31T05:44:58Z by thisisgaurav
Nehashri
Nehashri
12 Posts

Pinned topic String concatenation in Passthru statement

‏2008-12-19T14:17:43Z |
Hi,

I need to use passthru statement in esql to execute one sql query. I am using db2. In that query I have to concatenate 3 columns. firstname middlename and lastname in between like the below.

C.FIRSTNAME|| ' ' ||C.MIDDLENAME|| ' ' ||C.LASTNAME as CUST_PERSON_NAM

The query works perfectly fine. But I am really strugglin to put this piping symbol and the single quote in my passthru statement. Can someone pls help me out on this one. Thanks.
Updated on 2008-12-31T05:44:58Z at 2008-12-31T05:44:58Z by thisisgaurav
  • thisisgaurav
    thisisgaurav
    12 Posts

    Re: String concatenation in Passthru statement

    ‏2008-12-31T05:44:58Z  
    Can you explain the problem better - "I am really strugglin to put this piping symbol and the single quote in my passthru statement". What error are you getting?