Generator(s)

Specify the name of the program to be called to generate Next Keys for rows having a blank value, a to-be-determined value, or a ?-suffixed value in this column. This field can include these types of entries:

  • Program name and all parameters, in Transact-SQL syntax, for example: NextLotSp @Item = @Item, @UseParm = @UseParm, @Prefix = @Prefix, @key = @lot OUTPUT, @Inforbar = @Inforbar OUTPUT
  • Special program name SetNextKeySp, a comma, and a constant value to be passed as the @Type parameter, for example: SetNextKeySp,N'DO'
  • Single program name only.
  • Multiple program names only, separated by commas.