T4S4  18.1 C7177 A20283
Teamcenter Gateway for SAP S/4HANA API Reference
API::Core::Sql Namespace 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...
 

Variables

 ___showSql
 
 ___transactionName
 

Detailed Description

SQLlite interface to the internal T4x database.

External sqlite API.

Variable Documentation

◆ ___showSql

___showSql
static

◆ ___transactionName

___transactionName
static