![]() |
T4S4
19.1 C8540 A23673
Teamcenter Gateway for SAP S/4HANA API Reference
|
SQLlite interface to the internal T4x database. More...
Functions | |
begin databaseRef | |
Marks the begin of a database transaction. More... | |
commit databaseRef | |
Marks the completion of a database transaction as successful. More... | |
connect databaseRef databaseFileName | |
Opens a connection with a database. More... | |
createIndex databaseRef indexName tableName columnNameList args | |
Creates an index. More... | |
createTable databaseRef tableName columnNameTypeList args | |
Creates a table. More... | |
delete databaseRef tableName whereCondition | |
Deletes one or more rows from a table. More... | |
deleteIndex databaseRef indexName | |
Deletes an index. More... | |
deleteTable databaseRef tableName | |
Deletes a table. More... | |
disconnect databaseRef | |
Closes a connection with a database. More... | |
executeSql databaseRef sqlStatement | |
Executes an SQL statement. More... | |
explainSql databaseRef sqlStatement | |
Retrieves the execution plan of an SQL statement without executing the statement. More... | |
export databaseRef tableName filePath | |
Exports the content of a table to a CSV (tab-separated) file. More... | |
getIndexInfo databaseRef indexName | |
Retrieves meta information about an index. More... | |
getIndexInfoList databaseRef | |
Retrieves meta information about all indexes in the database. More... | |
getShowSql | |
Tells, if SQL statements are shown. More... | |
getTableInfo databaseRef tableName | |
Retrieves meta information about a table. More... | |
getTableInfoList databaseRef | |
Retrieves meta information about all tables in the database. More... | |
import databaseRef tableName filePath | |
Imports the content of a CSV (tab-separated) file to a table. More... | |
insert databaseRef tableName columnValueList | |
Inserts a row into a table. More... | |
optimizeSpace databaseRef | |
Optimizes the database with respect to space. More... | |
optimizeTime databaseRef | |
Optimizes the database with respect to time. More... | |
rollback databaseRef | |
Marks the completion of a database transaction as not successful. More... | |
select databaseRef columnNameList tableNameList whereCondition args | |
Retrieves one or more rows of one or more tables. More... | |
setShowSql showSql | |
Changes, if SQL statements are shown. More... | |
update databaseRef tableName columnNameValueList whereCondition | |
Updates one or more rows of a table. More... | |
SQLlite interface to the internal T4x database.
External sqlite API.