What Is Ab_local Expression Where Do You Use It In Ab-initio?
Ch KashifEnlightened
Power BI
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this answer should be reported.
What Is Ab_local Expression Where Do You Use It In Ab-initio?
Ch Kashif
ablocal_expr is a parameter of itable component of Ab Initio. ABLOCAL() is replaced by the contents of ablocal_expr. Which we can make use in parallel unloads. There are two forms of AB_LOCAL() construct, one with no arguments and one with single argument as a table name(driving table).
The use of AB_LOCAL() construct is in Some complex SQL statements contain
grammar that is not recognized by the Ab Initio parser when unloading in parallel.
You can use the ABLOCAL() construct in this case to prevent the Input Table
component from parsing the SQL (it will get passed through to the database). It also specifies which table to use for the parallel clause.