Hi all,
At the moment i am writing a powerapp that reads data from a DB2 database on an Iseries machine on-premise.
I use the DB2 connector and use port 446 (DRDA).
Reading data from the DB2 is no problem. I am running into trouble when i want to create a new record or update an existing one.
In the table that i want to insert a new record in there is an autogenerated identity column. For powerapps it is mandatory that i supply a value for this field when using the patch functionality, of course this doesn't work and i receive an error from the DB2 database that it is an auto generated column i should not supply a value too.
So i thought, let's create a view without the identity column in it and use the view to update the table.
unfortunately, when i want to use the view to update it tells me that the datasource is "read only"??? I guess this is because it is missing a primary key?
How can i overcome this issue, too me it looks like a bug in the DB2 connector.
I also tried to create a record through Microsoft Flow:
- When using the normal table i have the same problem that i need to supply a value for the auto generated identity column.
-When i use the view in Microsoft Flow i am actually able to create a record!!! So this would be kind of a workaround...
Any ideas on this?
