YShuai。 2022-02-16 14:01 采纳率: 100%
浏览 301
已结题

SQLCODE=-206, SQLSTATE=42703


SELECT
    *
FROM
    (   SELECT
            REC_CREATOR                                        AS "recCreator",
            REC_CREATOR_NAME                                   AS "recCreatorName",
            REC_CREATE_TIME                                    AS "recCreateTime",
            REC_REVISOR                                        AS "recRevisor",
            REC_REVISOR_NAME                                   AS "recRevisorName",
            REC_REVISE_TIME                                    AS "recReviseTime",
            ARCHIVE_FLAG                                       AS "archiveFlag",
            ARCHIVE_TIME                                       AS "archiveTime",
            ARCHIVE_STAMP_NO                                   AS "archiveStampNo",
            SEQ_NUM                                            AS "seqNum",
            COMPANY_CODE                                       AS "companyCode",
            SALE_ORG                                           AS "saleOrg",
            CURRENCY                                           AS "currency",
            DELIVERY_DATE_6                                    AS "deliveryDate6",
            RATE                                               AS "rate",
            VERSION_NUM                                        AS "versionNum",
            DISC_DAYS                                          AS "discDays",
            DISC_BASE_DATE                                     AS "discBaseDate",
            DISC_MODE                                          AS "discMode",
            REMARK                                             AS "remark",
            REMARK1                                            AS "remark1",
            REMARK2                                            AS "remark2",
            REMARK3                                            AS "remark3",
            NOTE_TYPE                                          AS "noteType",
            PAPER_TYPE                                         AS "paperType",
            RATE_START_DATE                                    AS "rateStartDate" ,
            DECODE(RATE_END_DATE,' ','99991231',RATE_END_DATE) AS "rateEndDate"
        FROM
            ISMS.TSAHYSA16 
        WHERE 
            NOTE_TYPE = 'B61'
        AND PAPER_TYPE ='1' ) A16
        WHERE 1=1
        AND A16.RATE_START_DATE<= '20220201'
        AND A16.rateEndDate >='99991231'

这个报sqlcode=‘-206’,我看了字段啥的都没问题啊

  • 写回答

3条回答 默认 最新

  • 关注

    删除select前面的(`)符号再试试:

    img

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论 编辑记录
查看更多回答(2条)

报告相同问题?

问题事件

  • 系统已结题 2月24日
  • 已采纳回答 2月16日
  • 修改了问题 2月16日
  • 修改了问题 2月16日
  • 展开全部