Neoview Character Sets Administrator's Guide (R2.4, R2.5)

^ (25 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
>>
Example of a Syntax Error in a Multi-Line SQL Statement
This is an example of a syntax errors on a command that uses more than 945 characters. The
character-identifying text with a carat is provided at the end of the syntax error.
SELECT T.WK_END_DT
, TRIM(TRAILING
FROM T.FCL_YR_ID)
, TRIM(TRAILING
FROM T.FCL_PER_ID)
, P.PKY_ID AS PRIM_KEY
, TRIM(TRAILING
FROM P.PKY_DSC_TX) AS KEY_DSCR
, SUM(A.TG_SL_QT) AS SALES_QT
, SUM(A.TG_SCN_QT) AS RNDM_WGT
, SUM(A.TG_SL_AM) AS SALES_AM
, ZEROIFNULL(SUM(A.TG_SL_AM ) - SUM(A.TG_DMGN_AM))AS MPC_COST
, SUM(A.TG_DMGN_AM) AS DIRECT_MARGIN
, ZEROIFNULL((SUM(A.TG_DMGN_AM ) / NULLIFZERO(SUM(A.TG_SL_AM))) )AS DMGN_PERCENT
, ZEROIFNULL((SUM(A.TG_T_MKDN_AM) ) / 1)AS MARKDOWN
, ZEROIFNULL((SUM(A.TG_T_MKDN_AM ) / NULLIFZERO(SUM(A.TG_SL_AM ) + SUM(A.TG_T_MKDN_AM ))) )
AS MKDN_PERCENT
, ZEROIFNULL((SUM(A.TG_INV_QT) ) / 1)AS INV_QUANTITY
, ZEROIFNULL((SUM(A.TG_INV_CST_AM) ) / 1)AS INV_COST
, SUM(A.TG_PTS_AM) AS PTS_SALES
, SUM(A.TG_PTS_DMGN_AM) AS PTS_DIRECT_MARGIN
, ZEROIFNULL((SUM(A.TG_PTS_DMGN_AM ) / NULLIFZERO(SUM(A.TG_PTS_AM))) )AS PTS_DMGN_PERCENT
, SUM(A.TG_PTS_MKDN_AM) AS PTS_MARKDOWN
, SUM(A.TG_CLRN_AM) AS CLRN_AMOUNT
, SUM(A.TG_CLRN_DMGN_AM) AS CLRN_DIRECT_MARGIN
, ZEROIFNULL((SUM(A.TG_CLRN_DMGN_AM / NULLIFZERO(SUM(A.TG_CLRN_AM))) )AS CLRN_DMGN_PERCENT
, SUM(A.TG_CLRN_MKDN_AM) AS CLRN_MARKDOWN
, ZEROIFNULL((SUM(A.TG_CLRN_INV_CST_AM) ) / 1) AS CLRN_INV_COST
, ZEROIFNULL((INV_QUANTITY / NULLIFZERO(SALES_QT)))AS STR_WK_SUPPLY
FROM WK_ZN_PRMKY_HST A
, WK_END_DT_INF T
, PRMKY_INF P
WHERE T.WK_END_DT = A.WK_END_DT
AND P.PKY_ID = A.PKY_ID
AND (T.WK_END_DT IN ('20060610'))
GROUP BY 1, 2, 3, 4, 5;
*** ERROR[15001] A syntax error occurred at or before:
...TG_DMGN_AM) AS DIRECT_MARGIN , ZEROIFNULL((SUM(A.TG_DMGN_AM ) / NULLIFZERO(S
UM(A.TG_SL_AM))) )AS DMGN_PERCENT , ZEROIFNULL((SUM(A.TG_T_MKDN_AM) ) / 1)AS M
ARKDOWN , ZEROIFNULL((SUM(A.TG_T_MKDN_AM ) / NULLIFZERO(SUM(A.TG_SL_AM ) + SUM(
A.TG_T_MKDN_AM ))) )AS MKDN_PERCENT , ZEROIFNULL((SUM(A.TG_INV_QT) ) / 1)AS INV
_QUANTITY , ZEROIFNULL((SUM(A.TG_INV_CST_AM) ) / 1)AS INV_COST , SUM(A.TG_PTS_A
M) AS PTS_SALES , SUM(A.TG_PTS_DMGN_AM) AS PTS_DIRECT_MARGIN , ZEROIFNULL((SUM(
A.TG_PTS_DMGN_AM ) / NULLIFZERO(SUM(A.TG_PTS_AM))) )AS PTS_DMGN_PERCENT , SUM(A
.TG_PTS_MKDN_AM) AS PTS_MARKDOWN , SUM(A.TG_CLRN_AM) AS CLRN_AMOUNT , SUM(A.TG_
CLRN_DMGN_AM) AS CLRN_DIRECT_MARGIN , ZEROIFNULL((SUM(A.TG_CLRN_DMGN_AM / NUL
LIFZERO(SUM(A.TG_CLRN_AM))) )AS CLRN_DMGN_PERCENT , SUM(A.TG_CLRN_MKDN_AM) AS C
^ (1057 characters from start of SQL statement)
*** ERROR[8822] The statement was not prepared.
>>
34 Using SQL Language Elements to Define and Manage Database Encoding