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