BODS Script

[Former Member]

Hi All,

We have a requirement to extract the data from Hana where the Information Steward (IS) is creating the table. The issue is for every landscape IS appends an auto generated id at the end of table. Thus, we would not know the table in every landscape to be used in DS.

So, what i did is I wrote a script to identify my required table from table "IS_FD_TABLES_MAP" in hana and I get to know my required table.

$Test_Table = sql('Hana','SELECT A.TABLE_ALIAS || \'_FD\'

FROM "SCHEMA"."IS_FD_TABLES_MAP" A

WHERE A.FQ_TABLE_NAME LIKE \'TEST_%\'');

And I try to use the SQL transformation to read the table that is now stored in variable $Test_Table. Just select statement like this "Select * from $Test_Table" but DS throws an error.

Appreciate your thoughts.

Thanks,

Vinay

[former_member187605]

DS doesn't throw an error. It just shows the error you get from the underlying database.

What's the error message like?