SQL statement of Business Views

[adeel]

Hello there

Can anyone please provide me all the SQL statment used in Business view in JD Edwards system. ? or guide me how to get ?

Thanks
AD

 

[BBritain]

I'm not sure you can get this without an external piece of software or without some work.

Additionally, I'm not sure if you want a SELECT an INSERT or an UPDATE SQL command but here's how I'd do it.

Create a dummy screen such as a Headerless/Detail add the Business View and a Find button, then run it with logging on and you can get all three SQL statements.

Good Luck, (I know it's not what you wanted to hear)

Ben again,

 

[BOster]

I am not 100% sure what you are after but maybe I can clarify a little.

The SQL statement is NOT stored with the Business View specifications. The SQL is generated at run-time using the Business View specifications and any data selection (set by the user or programatically). As Ben pointed out, you can get this run-time generated SQL by enabling Debug Logging.

 

[DBohner-(db)]

Adeel,

What needs to be understood is that; The BSVW is only the Definition of the Select and Join aspect of the SQL Statements. It contains the list of tables, the columns and the means to join multiple tables.

The BSVW Definition - does not contain the "Where" syntax.

That said - there really isn't anywhere to fully define the SQL Statement(s) prior to execution. UBE, APPS, Functions... that use the BSVW contain the "Where" syntax for the clause.

On a Per Execution basis, you can obtain the SQL Statements in the JDEDebug.Log and the Web / Jas logs...

(db)