EAR9.2: Build View PS_DFW_AR_ERROR_CD Fails With SQL2021N In DB2 in Image 13
(Doc ID 2056194.1)
Last updated on MAY 16, 2019
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
The create view failed with the following error:
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL20211N The specification ORDER BY or FETCH FIRST n ROWS ONLY is invalid.
CREATE VIEW FSDEMO.PS_DFW_AR_ERROR_CD (AR_MSG_NUM, AR_ERROR_CD, MESSAGE_TEXT) AS SELECT DISTINCT E.AR_MSG_NUM , E.AR_ERROR_CD , M.MESSAGE_TEXT FROM PS_AR_ERROR_TBL E , PSMSGCATDEFN M WHERE E.AR_MSG_NUM=M.MESSAGE_NBR AND M.MESSAGE_SET_NBR=6035 ORDER BY E.AR_MSG_NUM.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document