无法在 AS400 上创建具体化查询

发布于 2024-10-15 03:38:12 字数 433 浏览 6 评论 0原文

尝试在 as400 中创建具体化查询时收到错误消息我使用 winSql 进行连接。语法似乎有效。你能指出我做错了什么吗？

这是我试图执行的语句

CREATE TABLE AAA.TEST_MQ AS
(
     SELECT test.*

    FROM
        AAA.TABLE_NAME test

)  REFRESH DEFERRED

这是错误消息：

Error: SQL0104 - Token <END-OF-STATEMENT> was not valid. Valid tokens: IMMEDIATE <IDENTIFIER>. (State:37000, Native Code: FFFFFF98)

我也尝试创建一个立即的消息。

原文

I get an error message when trying to create materialized query in as400
I use winSql for the connection.
The syntax seems valid.
Could you please point out what am I doing wrong?

This is the statement I am trying to execute

CREATE TABLE AAA.TEST_MQ AS
(
     SELECT test.*

    FROM
        AAA.TABLE_NAME test

)  REFRESH DEFERRED

This is the error message:

Error: SQL0104 - Token <END-OF-STATEMENT> was not valid. Valid tokens: IMMEDIATE <IDENTIFIER>. (State:37000, Native Code: FFFFFF98)

I Tried creating an immediate one as well.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

耳钉梦 2024-10-22 03:38:12

试试这个：

CREATE TABLE AAA.TEST_MQ AS (
      SELECT test.*
      FROM
      AAA.TABLE_NAME test  )
    DATA INITIALLY DEFERRED 
    REFRESH DEFERRED 
    MAINTAINED BY USER 
    ENABLE QUERY OPTIMIZATION 
;

我使用 JaySQL Lite 并且它有效。

Try this:

CREATE TABLE AAA.TEST_MQ AS (
      SELECT test.*
      FROM
      AAA.TABLE_NAME test  )
    DATA INITIALLY DEFERRED 
    REFRESH DEFERRED 
    MAINTAINED BY USER 
    ENABLE QUERY OPTIMIZATION 
;

I use JaySQL Lite and it works.

回复收藏 0 原文

~没有更多了~