Home > IT Answers > Business Intelligence > How to use PL/I command LIKE with DB2
Sccsofti
5 pts.
 How to use PL/I command LIKE with DB2
DB2, iSeries programming commands, PL/I
I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable "xxxxxxxx" is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns. SQLSTATE=42802 Is there eny way to use LIKE ?

Software/Hardware used:
ASKED: January 16, 2008  2:57 PM
UPDATED: March 8, 2010  4:01 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Can you clarify? Is this SQL PL/I on your iSeries or are you trying to use a LIKE option in a different language the same as you would in PL/I? What is your OS version?

Tom

TomLiotta
 108,260 pts.