Enabling siebel database manipulation by use of a direct SQL statement

摘要

A system and associated method for manipulating a Siebel database (SDB) with a Structured Query Language (SQL) statement utilizes a SQL-eScript parser, which uses a business component (BC) on a Siebel data model of the SDB, which has data elements corresponding to the data elements of the SQL statement to be performed against the SDB. In the SDB, data of the SDB is stored in relational database tables, accesses to the SDB must utilize a BC which describes and references a part of the Siebel data model. The SQL-eScript parser enables users to access the SDB by use of the SQL statement by interpreting the SQL statement and automatically identifying and utilizing a BC on the Siebel data model having all data elements of the SQL statement and performing eScript BC methods corresponding to operations of the SQL statement in updating the SDB.