Hi,
Is it possible to code NEXTVAL to get a sequence number from a sequence object in the Load control statement while loading using DSNUTILB?

The fol. does not work

LOAD DATA RESUME YES LOG YES INDDN SYSREC00 INTO TABLE
SCHEMA.TABLE
(
USER_UID (NEXTVAL for SCHEMA.SEQOBJECT), PIN POSITION( 1 )
CHAR( 6)
NULLIF( 7)='?',

Thanks in advance

Try using an import, I am pretty sure load bypasses that sort of thing.
IBM DB2 9.7 Information Center for Linux, UNIX, and Windows

sorry azready : DSNUTILB sounds like Z/OS
that is what you get when people do not indicate platform and db2 version...

We are on z/OS platform and DB2 version 10. One of the tables is going to be dropped and recreated with USER_UID as the primary key and a sequence object is being built to get the UIDs. The problem is when I unload data from the old database, the sequence object does not exists. I need to somehow get the UIDs from the seq object during load. Don't know if it is possible. Tried the fol. during load and I get INVALID syntax error.

LOAD DATA RESUME YES LOG YES INDDN SYSREC00 INTO TABLE
SCHEMA.TABLE
(
USER_UID (NEXTVAL FOR SCHEMA.SEQOBJECT),
INVALID KEYWORD - NEXTVAL PIN POSITION( 1 )
CHAR( 6)
NULLIF( 7)='?',

LOAD DATA RESUME YES LOG YES INDDN SYSREC00 INTO TABLE
SCHEMA.TABLE (
USER_UID (SELECT NEXT VALUE FOR SCHEMA.SEQOBJECT),
INVALID KEYWORD - SELECT
PIN POSITION( 1 )
CHAR( 6)
NULLIF( 7)='?',

See if the information on this page helps :

Loading tables with special column types by using generated LOAD statements