Skip to Content

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


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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers