SQL EXPRESSION

[Former Member]

hi

what is the use of SQL expression in the field explorer  suppose if my database is SAP BEx query or SAP BW INFOPROVIDERS.

tnx,

[abhilash_kumar · Accepted solution]

Hi Praveen,

SQL Expressions cannot be used with SAP Datasources.

Please google to find out how SQL Expressions work.

-Abhilash

[Former Member · Accepted solution]

hi abhi

sorry for posting basic question. i have searched google but i am little bit confusing . so this SQLexpression is used for what datasource

[abhilash_kumar · Accepted solution]

Hi Praveen,

SQL Expressions are not available with all databases. They are available with databases like SQL Server, Oracle, MySQL etc (SQL Databases).

Sometimes when using PC databases, you might find that you have an option to create a SQL Expression, however creating one doesn't really improve performance since they're not really client-server databases.

More often than not, you would want to include a SQL Expression to make use of some database specific function that otherwise would need a CR function.

-Abhilash