Do Not Perform DDL Operations in Transactional Projects

Database target or interface combinations behave differently for data definition language (DDL) transactions, so avoid performing DDL operations in a preprocessing sql statement and postprocessing sql statement for transactional projects. If needed, perform DDL operations in a nontransactional project.

For example, create a job that has three projects:

  • Non-transactional setup project (including DDL)

  • Transactional project

  • Non-transactional cleanup project (including DDL)

Parent topic: Best Practices for Working with Sybase IQ InfoPrimer Server