Column Identity and Datawarehouse

[deangelis]

Hi,
I'm implementing a process in DB2. This process is made of an origin table, a SQL step, and a destination table. The destination table has 5 colums, on of these is a code and i generated as always. The problem is that the sql step has to map the 4 columns of the origin table in the 4 columns of the destination. So the column identity isn't mapped. The error is the sqlstate 428c9.
Help me!!!



Ciao da
N@poleone

 

[blom0344]

Give us some details on source, target and the SQL step you are talking about. With such a vague description there is little to comment on......

T. Blom
Information analyst
tbl@shimano-eu.com