topic Re: Problem with the conversion between a db2 database and sap hana and function module in Water Cooler

Problem with the conversion between a db2 database and sap hana and function module

geogou1973 — Fri, 07 Feb 2020 22:40:25 GMT

Hello,

I have the following problem.

I read a db2 database from as/400 system. After that i take a field and i put it in a variable.

So far all it is OK. Then i put this variable in the function module that i call from a BAPI connector and i don't take any result.

When i put manually the name of the file from the field i have results.

DB2:

LOAD
MEMBLE
WHERE MEMBLE= 'AP1933202';

SET bpcsvar="=MEMBLE";

IF I PUT SET bpcsvar='AP1933202'; MANUALLY THE FUNCTION MODULES I TAKE RESULTS

SAP_HANA_FUNCTION_MODULE:
[Z_TOTALS_BPCS_FILE_LT_TOTALS]:
LOAD *;
SQL {
"function":"Z_TOTALS_BPCS_FILE",
"output":"LT_TOTALS",
"parameters":
[
{ "direction":"out", "name":"LT_TOTALS", "optional":false },
{ "direction":"in", "length":70, "name":"LV_FILENAME", "optional":false, "type":"CHAR", "value":"$(bpcsvar)" }
]
};

I think that is conversion between the db2 and sap hana.

Have anyone an idea how can i fix this problem ?

Thank you in advance.

Re: Problem with the conversion between a db2 database and sap hana and function module

geogou1973 — Mon, 02 Dec 2019 15:39:26 GMT

I think the problem is in the variable.

The value that i can see is bpcsvar="=MEMBLE" from the variable overview and in the other hand the value is bpcsvar='AP1933202' that i see in the the variable overview.

How can i solve this ?

Re: Problem with the conversion between a db2 database and sap hana and function module

Sue_Macaluso — Mon, 02 Dec 2019 19:13:54 GMT

@geogou1973 Hi, are you using QlikView or Sense? I would like to move this into the correct product forum.