How to call function in .sma file of birt report
Hi All,
I am calling db2 function (finding positive values from one column from db table )in my .sma file,if we provide schema name before function name (schema.function) it works properly, but my db schema is not same on all environment which we are using,so I have to call function without schema name.
1. Is it possible to call function in .sma file without schema name?
2. In my .sma file no schema name is provided for any table ,so from where .sma file picks schema name for tables?
Please let me know which is correct solution .