Re: QTEMP and SQL DDL

Not exactly, Rob. What I meant to say was that I used iNav's "New Table" function within Database/Schemas tab to initially define the table. Which, of course, does create the table. But then I used iNav's Generate SQL option to retrieve the source so that I could put it into a source PF for general use later.

It was when I tried to use that retrieved source via RUNSQLSTM in a CL program that I got the error.

Bear in mind, if it matters, that I'm just a kid when it comes to SQL. My experience is mostly limited to DDL and simple things like SELECT, UPDATE. and DELETE but never with some of the (to me) complicated code that I see you, Charles, and others use. The original database here came from a S/36 so they're just 'flat' files - until I have to modify them or write an RPG IV program over them. At which point I externalize the definition. Decided awhile ago that it would be best to get out of old habits (DDS).
* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
615.995.7024
fax
615.995.1201
email
jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



rob@xxxxxxxxx wrote:

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