View Full Version: Schema

LawsonTalk > HR/Payroll > Schema


Title: Schema


Mil0n023 - October 3, 2006 09:03 PM (GMT)
"what Oracle schema are the Lawson HR objects under?"

Don't know how to answer this...?

cjmart - October 3, 2006 11:57 PM (GMT)
The database owner of the Lawson tables is the schema. If you do a "Show SQL Query" on your ED Epic report, the schema precedes the table and field in the From clause. This is the format you will see...

CODE
SELECT ...
FROM "schema"."table"."field"

Mil0n023 - October 4, 2006 02:51 AM (GMT)
Cool.



Hosted for free by InvisionFree