Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Hello WebFOCUS/DM Experts I am looking for Data Migrator fun...


Yogesh Ajmire

Recommended Posts

Hello WebFOCUS/DM Experts

I am looking for Data Migrator function that are not directly converted to SQL. We are working on a project where lot of data will be moved to the target tables. We have to make sure we are writing efficient code so we do not bring all that data to report server for processing.

thanks

Yogesh Ajmire

Link to comment
Share on other sites

That CHAR function is a FOCUS construct. Theres no direct equivalent in MS SQL Server (or any SQL) to pass through to.

The MS SQL Server function CHAR serves a completely different purpose; it converts a number to the ASCII character. You could call it using for example DB_EXPR(CHAR(184)).

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...