As a routine, I am listening to mind music. Then I got an idea to write a post on DB2 SQL errors starts with 3**.
Recently, I found some errors, while writing SQL query.
The major part of your work is writing SQL query. So when you complete this work, you are good to go ahead.
Let me give an example:
from A_Table A INNER JOIN B_Table B
ON A.Invoice_id = B.Invoice-id
Where A.Cust_Name = 'Test1'
AND B.Bill_Number = '180000'
Here, :WS-BILL-TAX ===> Output host variable
:WS-Bill-date ===> Input host variable
Data-types of these input/output host variables must match to the table column data types ( char to char, integer to numeric, comp to comp etc), else, you will get these kind of errors.
The errors -300,-301, -302, -303,-304 usually occur with host-variable related issues.