I've chosen the *Generate* *As* *Identity* option. There are two other
radio buttion options:

Always
By Default Only

Always is the default selection.

What is the difference between these two options?
Why would I choose one option over the other?

Where can I find the documentation for these options?

Thanks in advance


--
Michael Riley
GySgt USMC (Ret)
www.zilchworks.com

Michael


Can't spot anything in the OLH but a quick web search confirms my guesses

"GENERATED ALWAYS AS IDENTITY" - Derby always provides auto-incremented sequence values to this column. You are not allowed to specify your own values.
"GENERATED BY DEFAULT AS IDENTITY" - Derby provides auto-incremented sequence values to this as default only when you are not providing values.

When you should use which is, for me, given in the definitions as well.

Roy Lambert

Roy Lambert wrote:

> Can't spot anything in the OLH but a quick web search confirms my
> guesses
>
> "GENERATED ALWAYS AS IDENTITY" - Derby always provides
> auto-incremented sequence values to this column. You are not allowed
> to specify your own values.  "GENERATED BY DEFAULT AS IDENTITY" -
> Derby provides auto-incremented sequence values to this as default
> only when you are not providing values.
>
> When you should use which is, for me, given in the definitions as
> well.

Thanks Roy.

Is there a reason why you picked the *Derby* search result over any of
the others?

--
Michael Riley
GySgt USMC (Ret)
www.zilchworks.com

Michael


>Is there a reason why you picked the *Derby* search result over any of
>the others?

Lazyness. It was the first I found that gave what I thought was a reasonable explanation.

Roy Lambert

Michael,

in addition to Roy's answer:

when you use replication, this setting *must* be "By Default only":
otherwise a record would get a different ID (different from the source
table), when it's inserted in the target table.

Uli