Re: Help on SQL Server 7 to AS/400 conversion on V4R4

At 22:04 03/25/2000 , Kirk Goins wrote:
>  ALTER TABLE COPYLMS.ACTIVITYTYPE
>         ADD CONSTRAINT DF_ACTIVITYTYPE_OVERRIDECREDITCOMPANY_ID
>         WITH DEFAULT '0' FOR OVERRIDECREDITCOMPANY_ID,
>
>         ADD CONSTRAINT DF_ACTIVITYTYPE_OVERRIDECREDITLOCATION_ID
>         WITH DEFAULT '666' FOR OVERRIDECREDITLOCATION_ID,
>
>         ADD CONSTRAINT PK__ACTIVITYTYPE__69C6B1F5 PRIMARY KEY
>         (
>                 ACTIVITYTYPE_ID
>         ) WITH  FILLFACTOR = 90
>;
>
>The AS/400 is complaining about the WITH DEFAULT with error msg
>
>SQL0199  30    1486  Position 2 Keyword WITH not expected. Valid tokens:
>                      CHECK UNIQUE FOREIGN PRIMARY.
>
>According to the book I have...
>"DEFAULT is a constraint that determines which value is inserted into the
>column if no value is specified for the column on an insert"
>
>How do I do this on the AS/400??

If these are numeric columns (probably integer), try removing the 
apostrophes around the literal values. Their use indicates that the target 
column is alpha. You could also use one of the cast functions, but I 
wouldn't think that would be necessary. This is just a guess but the WITH 
DEFAULT clause is valid on the AS/400. What version of OS400 are you running?



>The AS/400 is complaining about the WITH FILLFACTOR with error msg
>
>SQL0199  30    1525  Position 4 Keyword WITH not expected. Valid tokens:
>ADD DROP ALTER.

<snip>

>Do I even care on the AS/400 about the FILLFACTOR parm ?

No you don't. Just delete WITH FILLFACTOR.
Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---