My Oracle Support Banner

How to Manually Convert Existing InfoMaker Reports and Forms from Sybase to Microsoft SQL Server Syntax / Format (Doc ID 904167.1)

Last updated on JULY 11, 2017

Applies to:

Primavera Contract Management - Version 11.0 to 13.1 [Release 11.0 to 13]
All Platforms

Goal

Reports and forms created specifically for use with a Sybase database will not necessarily function properly when run against an MSSQL database.  While Sybase and MSSQL are similar in how they handle queries, they have some small differences that may cause report failure and necessitate minor modifications.

 

Note:  Only customized reports and forms need to be converted.  Stock reports and forms for all supported database platforms are available within the Contract Management installation media.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1) Remove any references to sys.dummy. 
 2) Remove brackets, and the letters oj from Outer Joins.
 3) Remove the 'exp'. from any table reference that start like that.
 4) Replace all pipes (||) with plus signs (+)
 5) Change the Sybase today's date function to the MSSQL today's date function.
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.