Dear all, I am trying to create a data source definition dynamically. I have succeeded in creating the definition by using BDF_DATASOURCEDEF_CAPI.DATASOURCEDEFCREATE function but now i am stuck on attributes. Do attributes have to entered manually or is there a procedure that would do this for me? Best regards, Blaž |
Hi Blaz, You need to use BDF_DATASOURCEDEFATRIB_CAPI for the attributes. You also might need BDF_DATASOURCEDEFBINDVAR_CAPI to create bind variables. Thanks, BR, Blaž
(12 Nov '13, 07:22)
bepl
Just a few more important notes: Use, BDF_DBOBJECTACCESS_CAPI.dbobjectaccessCreate to create Datasources based on Datasource Definitions. BDF_DATASOURCEDEF_GEN.datasetTableCreateOrReplace and BDF_DATASOURCEDEF_GEN.datasetPackageCreateOrReplace to generate the required DB objects. There may be a few more API's that you need. But off the top of my head these are the API's that matter. Most imporantly, these API's don't do any validation. They just insert data to tables. So if there are any inconsistencies in the data you are providing you might run into some issues.
(12 Nov '13, 07:28)
Yalim Gerger ♦♦
|
Hello Blaž and Yalim, i've read your comments and tried to create datasource-definitions. I want to transfer a lot of db-views to the formspider-IDE, by using a sql-script. When i use the mentioned statements, a test-datasource-definiton and datasources are visible in the IDE. But i am missing the column-descriptions (datasourceattributes?). So i can't change this dynamic created datasource-definiton in the IDE: when i commit my changes, an error is shown. ORA-06512: in "PSFSDEV_PI.BDF_IDE_DATASOURCEDEFCOMMIT_II", Zeile 92 ORA-06512: in "PSFSDEV_PI.API_APPLICATION", Zeile 33 ORA-06512: in "PSFSDEV_PI.BDF_IDE_INTERFACE_PKG", Zeile 1692 I think, there is an api-function to create the missing attributes?! Please, can you explain me how? Thanks! Best regards, Hermann |
Hi Blaz,
What is your use case for this? Depending on the use case maybe I can offer a suitable solution.
Hi Yalim,
I want to "copy" the datasources from powerbuilder. BR, Blaž