Re: sql insert into and increment id

[Niels Liisberg <nli@xxxxxxxxxxxxxxxxx>]

I would use a SEQUENCE and the is just insert and NEXT. First time you have
to set your sequence to select max(yourKey) ... and a bonus side effect is
: it super fast

lør. 25. maj 2019 kl. 15.38 skrev midrange <franz9000@xxxxxxxxx>:

> Have a normal file keyed by one column.
>
> It is not an option to change this column to auto increment...
>
>
>
> I can add single records with insert statement where the key field is
> "max(field) + 1" -
>
>
>
> In the values
>
> (select keyfld = max(keyfld) + 1), itemName,itemType.
>
>
>
> But if I do an insert that has selected multiple records - I get an error
> the keyfld not unique
>
>
>
> Insert into itemMast
>
> (keyfld, itemName, itemType, qtyOH, Location)
>
> Select  (select keyfld = max(keyfld) +1), itemName, 'A', 0, Location
>
> From   itemMast
>
> Where itemType = 'B'
>
>
>
> Is there a way to do this without altering the definition of the file
> (package software)?
>
> We need to duplicate a large number of records, but with unique keys.
>
>
>
> Jim
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com