How to auto increment a field?

[khsaunderson]

I am trying to insert into a table and need to add to an ID field that is auto incremented by a Cobol program, so I need to replicate this in my SQL script. Eg,

INSERT INTO Table
(ID,
Name)
SELECT
xxxx,
ISRC
FROM TEMP_ISRC

Thanks