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...
Though I can not test with DB2 and reproduce the issue, and the error message shows that you have the permission "read only", so could you please check whether you have the "write" authority of the data source?
The problem is not solved yet. I understand that the db2 connector is not top priority for Microsoft. But is there any chance an admin here on the forums can check if the issue is somewhere "noted" at the development team for Investigation and/or fixing.
I have created a ticket at Microsoft 1/2 months ago but have not heard anymore from them.