DSXchange

what is the significance of "level number" and "vector occurs" in column generator stage. Can i generate unique integers for all the columns in different datasets without using the 'part' and 'partcount' keywords.

Level number is straight out of COBOL and refers to the ability to create subrecords. Similarly vectors are straight out of COBOL and refer to "repeating groups". The Column Generator stage does include the ability to generate data into these structures, but do you really have a need to do so?

The answer to your second question is "no" unless you force the stage to operate in sequential execution mode.