procedure in UDB V9.5, It creates properly in UDB 8.1:
$ db2 -td@ -f FUMT_SP_001.SP
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following "|
' I_ASCOS' ". Expected tokens may include: "<psm_semicolon>". LINE
NUMBER=1832. SQLSTATE=42601
=====================
The code at line number 1832 is :
1828 SET L_CURRENT_TS = CURRENT TIMESTAMP;--
1829 SET L_INPUT_DATA = ' I_LINE_OF_BUSINESS_CD:' || I_LINE_OF_BUSINESS_CD ||
1830 ' I_COVERAGE_CD:' || I_COVERAGE_CD ||
1831 ' I_OPERATING_COMPANY_CD:' || I_OPERATING_COMPANY_CD ||
1832 ' I_BUSINESS_UNIT_CD:' || I_BUSINESS_UNIT_CD ||
1833 ' I_STATES' || I_STATES ||
1834 ' I_ASCOS' || I_ASCOS ||
1835 ' I_COUNTRYWIDE_IN:' || I_COUNTRYWIDE_IN ||
1836 ' I_FORM_DISPLAY_IN:' || I_FORM_DISPLAY_IN ||
1837 ' I_FORM_TYPE_CDS:' || I_FORM_TYPE_CDS ||
1838 ' I_WITHDRAWN_IN:' || I_WITHDRAWN_IN ||
1839 ' I_EFFECTIVE_DT:' || CHAR(I_EFFECTIVE_DT) ||
1840 ' I_WRITTEN_DT:' || CHAR(I_WRITTEN_DT) ||
1841 ' I_CLASS_CDS:' || I_CLASS_CDS;--
1842 /************************INITIALIZATION OF VARIABLES ENDS******************************************/
Any direction on this error would be greatly appreciated. This is my first time submitting a question to this forum. If improperly done please let em know and i will redo it.
Thanks Jimmy Rowe