FREE TRIALS

TEST: invalid database ddl (4283687)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

TEST: invalid database ddl
Description

The script which is generated by Toad for the database is not working. Generated is:
PAGESIZE 4096 Pages
but Pages is not a valid DB2 Syntax. If I try to recreate the database I get error:
SQL0104N An unexpected token "Pages" was found following "< identifier >".
Expected tokens may include: "RESTRICTIVE". SQLSTATE=42601
Resolution

The script which is generated by Toad for the database is not working. Generated is:
PAGESIZE 4096 Pages
but Pages is not a valid DB2 Syntax. If I try to recreate the database I get error:
SQL0104N An unexpected token "Pages" was found following "< identifier >".
Expected tokens may include: "RESTRICTIVE". SQLSTATE=42601

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Leave a Comment

Recommended Content

Product(s):: Toad for DB2

Topic(s):: Technical Solutions

Article History:: Created on: 4/17/2010
Last Update on: 5/7/2023

Search All Articles