× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Are you sure you got that to execute in iNav?

CREATE TABLE QTEMP.JERRY (MYKEY INT NOT NULL WITH DEFAULT, MYDATA
CHAR (5 ) NOT NULL WITH DEFAULT, PRIMARY KEY (MYKEY))
SQL State: 55019
Vendor Code: -7008
Message: [SQL7008] JERRY in QTEMP not valid for operation. Cause . . . . .
: The reason code is 10. Reason codes are: 10 -- A constraint or
trigger is being added to an invalid type of table, or the maximum number
of triggers has been reached, or all nodes of the distributed table are
not at the same release level.

CREATE TABLE QTEMP.JERRY (MYKEY INT NOT NULL WITH DEFAULT, MYDATA
CHAR ( 5) NOT NULL WITH DEFAULT, UNIQUE (MYKEY))
SQL State: 55019
Vendor Code: -7008
Message: [SQL7008] JERRY in QTEMP not valid for operation. Cause . . . . .
: The reason code is 10. 10 -- A constraint or trigger is being added
to an invalid type of table, or the maximum number of triggers has been
reached, or all nodes of the distributed table are not at the same release
level.

Because I sure can't get it to create in iNav.

Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.