How to get the value of a Data area from a AS400 database

Data Abstract
1

We have a AS400 database and I need to get some information from a data area. Is there a way to get this via the Schema?

Or do I need a stored procedure? If so how do I cal the stored procedure. I tried different ways but none worked.

2

Hello,

We have a AS400 database and I need to get some information from a data area. Is there a way to get this via the Schema?

You can use system SQLs to get some information (if db supports it).

Or do I need a stored procedure? If so how do I cal the stored procedure. I tried different ways but none worked.

What AUX driver do you use? Can you call stored procedure using stSQL?

3

We use an ADO driver.

According to my colleague I need to make a command in the schema and call the command.
In the command I can call the stored procedure as call (params)

4

Hello,
Before using it in your application and SchemaModeler please apply the following workaround:

uDAADODriver.pas

function TDAEADOStoredProcedure.Execute: integer;
…
params := GetParams;
if (Connection as TDAEADOConnection).fProviderType in [oledb_Oracle, oledb_ODBC] then pstr := ‘’ else pstr := ‘@’; //<==FIXED

Then you should recompile DAADODrv.dpr driver and put new DAADODrv.dad file to SchemaModeler folder.