Topic
  • 1 reply
  • Latest Post - ‏2010-11-23T22:01:54Z by PWConner
PWConner
PWConner
44 Posts

Pinned topic Create Table with a CTE in a SQLRPGLE program

‏2010-11-23T20:39:01Z |
I tried to create a table using a CTE in SQLRPGLE program. Is this allowed?

I received error:
Token FGDISPO was not valid. Valid tokens: , FROM INTO.

The statement pulled from a debug session starts as:
create table QTemp/BOM as ( with FGDispo as ( select nCdSto,
nRecTy, nCdKe1, nCdKe2, nCdKe3, nCdKe4, nCdKe5, nCdQua, nCd...

I have verified the statement works outside of RPG using StrSQL and System i Navigator.

Currently at V5R4.

Thank you
Updated on 2010-11-23T22:01:54Z at 2010-11-23T22:01:54Z by PWConner
  • PWConner
    PWConner
    44 Posts

    Re: Create Table with a CTE in a SQLRPGLE program

    ‏2010-11-23T22:01:54Z  
    Nevermind. I found the last field listed did not have a space after it and before the 'From' clause.