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?
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?
I created a support case at MS and the issue is confirmed. Hopefully they can fix this soon.
The "read-only" message is when i try to update through a view not directly on the table. This is by design as i understand, although when i use Ms flow i can update through a view.
If you get the solution, hope to update here and it will help more people who meet the same issue as yours.
Thank you for your post.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand