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_BUSIN ESS_CD:' || I_LINE_OF_BUSIN ESS_CD ||
1830 ' I_COVERAGE_CD:' || I_COVERAGE_CD ||
1831 ' I_OPERATING_COM PANY_CD:' || I_OPERATING_COM PANY_CD ||
1832 ' I_BUSINESS_UNIT _CD:' || I_BUSINESS_UNIT _CD ||
1833 ' I_STATES' || I_STATES ||
1834 ' I_ASCOS' || I_ASCOS ||
1835 ' I_COUNTRYWIDE_I N:' || I_COUNTRYWIDE_I N ||
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_EFFECTIV E_DT) ||
1840 ' I_WRITTEN_DT:' || CHAR(I_WRITTEN_ DT) ||
1841 ' I_CLASS_CDS:' || I_CLASS_CDS;--
1842 /*************** *********INITIA LIZATION 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
$ 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_BUSIN ESS_CD:' || I_LINE_OF_BUSIN ESS_CD ||
1830 ' I_COVERAGE_CD:' || I_COVERAGE_CD ||
1831 ' I_OPERATING_COM PANY_CD:' || I_OPERATING_COM PANY_CD ||
1832 ' I_BUSINESS_UNIT _CD:' || I_BUSINESS_UNIT _CD ||
1833 ' I_STATES' || I_STATES ||
1834 ' I_ASCOS' || I_ASCOS ||
1835 ' I_COUNTRYWIDE_I N:' || I_COUNTRYWIDE_I N ||
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_EFFECTIV E_DT) ||
1840 ' I_WRITTEN_DT:' || CHAR(I_WRITTEN_ DT) ||
1841 ' I_CLASS_CDS:' || I_CLASS_CDS;--
1842 /*************** *********INITIA LIZATION 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