Yogesh Ajmire Posted March 17, 2022 Share Posted March 17, 2022 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 More sharing options...
Clif Kranish Posted March 22, 2022 Share Posted March 22, 2022 Unless its changed from the context menu for the Adapters folder select SQL APT Status to see a list of the APT (Automatic Pass Through) status for each function by database. If it doesnt say pass as is then its not passed through to that database. Link to comment Share on other sites More sharing options...
Yogesh Ajmire Posted March 23, 2022 Author Share Posted March 23, 2022 Clif Thank you for responding. Link to comment Share on other sites More sharing options...
Manoj Chaurasia Posted March 24, 2022 Share Posted March 24, 2022 Hi Cllf, I can able to see the APT Status report as below. How to change the APT status for a particular RDBMS function like, change the CHAR function APT Convert to Pass as is in MS SQL Server. image.jpg1752688 634 KB Link to comment Share on other sites More sharing options...
Clif Kranish Posted March 24, 2022 Share Posted March 24, 2022 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now