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.
Pinned topic String concatenation in Passthru statement
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2008-12-31T05:44:58Z at 2008-12-31T05:44:58Z by thisisgaurav
thisisgaurav 270000Q4WT12 Posts
Re: String concatenation in Passthru statement2008-12-31T05:44:58ZThis is the accepted answer. This is the accepted answer.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?