db2 - Birt/Set Schema and Set Path -
i'm using schema changed schema in couple of months. not not want have remove schema_name multiple times each report. reports far have format:
select column_name1, schema_name.user_defined_function(column_name2), column_name3 schema_name.table_name i want remove schema name query looks this:
set schema lrouim; set path lrouim; select column_name1, user_defined_function(column_name2), column_name3 table_name i need "set schema" table name , "set path" user defined function. code works in squirrel sql, if insert code birt data set of type sql select query, error because of
set schema lrouim; set path lrouim; how implement set schema , set path in sql select query in birt?
i think birt uses jdbc connexion, , can modify connection parameters specifying default schema.
Comments
Post a Comment