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 Member]

When i use this code "Select * from {$Test_Table}" in SQL transformation, below attached error I get to see. If you notice second last row there is single quote for the table name which am not storing it in the script. Maybe that is the issue for the hana database to read in single quote.

Appreciate your thoughts.

[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?