Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need help with configuring this scenario.
I have Delimited File with ID and data associated with it. And I have DB2 table with ID and SeqNbr as primary key and data columns. While reading Delimited File and inserting to DB2 I need to generate SeqNBr.
Sample of how the Delimited file looks:
ID
-----
ABC
ABC
ABC
XYZ
XYZ
DEF
LMN
LMN
Here is how I need to generate Seq nbr
ID SeqNBR
----- ----------
ABC 1
ABC 2
ABC 3
XYZ 1
XYZ 2
DEF 1
LMN 1
LMN 2
Can you please suggest how to achieve this?
Thanks,