Skip to Content

Static Inserts in Data Services DataServices XI 3.2. How to avoid and go to dynamic ones.

Mar 27, 2017 at 09:26 AM


avatar image


I have a job in DataServices XI 3.2. The same job in development and production environments.

In my development environment, the inserts SQL are generated as dynamic of the type: INSERT INTO TABLE VALUES (:VARIABLE)

However in the production environment I look to the SQL Inserts generated by the tool and they are dynamic inserts of the type: INSERT INTO TABLE VALUES ('X'), which is much slower than the dynamic ones.

Is there any configuration t be done to force Data Services to to allways dynamic inserts?

The system is configuration is the following:

  • BO XI SP 3
  • DataServices 3.2 SP2

Sistema Operativo: Red Hat Enterprise Linux Server release 5.5 (Tikanga) 2.6.18-238.5.1.el5

Oracle RDBMS:

Thanks a lot,

Jose Manuel.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers