Hello,
I have an Excel File with 3 columns. The first and second columns are the both the key, the third is a simple text.
I would like to insert or update on a table on AS400.
In order to do that, I put my Excel File like an Input Files. I define the first and the second columns like a key.
I link my ExcelFile to a tMap and the tMap with tAS40Output.
I map the column of excel files to the table of AS400.
The job run and generate an error when i try to insert Data
for exemple
1 a toto
2 b tata
2 c titi
when I look in my table I find
1 a toto
2 b tata
but not 2 c titi
I put on As400Output ,in settings Action on Date : "Update or Insert" or "Insert or Upadte"
I select two columns as a key and set them are updatable
Could you help me please? Have you got an idea to resolve my problem?
PS: If i use a simple key (one column) that's works perfectly.
Thanks
don't look at proc share the same you look at a winpc scheduler... as400 has to provide many guarantees and accounts for timeslices in different way to allow stable multiuser experience... and chiefly talend stuff is quite I/O bound...
