System Procedures Index
You are looking at an older version of the documentation. The latest version is found here.
Procedures in SYS
- getXMLSchemas deprecated
Procedures in SYSADMIN
- addCliTemplate
- addRole
- addSystemProperty
- addUser
- addUserRole
- batchUpdate
- changeCopyOverSourceTableJob
- changeCopyOverSQLJob
- changeIncrementalOptimizationJob
- changeJobParameters
- changeOptimizationJob
- changeSQLJob
- changeUserPwd
- checkSortOrder
- cleanOrphanMatTableEntities
- cleanUpStaleMatTables
- copyOver
- createBackupJob
- createCleanupTaskIfAbsent
- createConnection
- createCreationParam
- createCopyOverSourceTableJob
- createCopyOverSQLJob
- createDataSource
- createGatherStatisticsJob
- createIncrementalOptimizationJob
- createIndex
- createOptimization
- createOptimizationJob
- createOptimizationQuery
- createSchedule
- createSQLJob
- createVirtualSchema
- deleteOptimization
- deleteRole
- deleteSchedule
- deleteSchedulerJob
- deleteSlackNotification
- deleteStatistics
- deleteSystemProperty
- deleteUser
- deleteUserRole
- deployModularConnector
- disableJobSlackNotification
- dropCliTemplate
- dropIndex
- dropIndexById
- dropIndexByName
- dropVirtualSchema
- editBackupJob
- editCliTemplate
- editCreationParam
- editSystemProperty
- enableJobSlackNotification
- enableOptimization
- enableSchedule
- enableSchedulerJob
- execExternalProcess
- executeCli
- gatherStatistics
- getAllDataSourcesMetadataDiff
- getCatalogs
- getClientSecret
- getConnProp
- getCurrentDWH
- getCurrentVdb
- getDataCatalogAttribute
- getDataLineage
- getDataLineageRelationsOnly
- getDataSourceMetadataDiff
- getDefaultOptionValue
- getEncryptedUserPwd
- getGeneratedColumnNames
- getInstalledLicense
- getJobProperty
- getReplicatedTableDiff
- getResourceDependencies
- getSchemas
- getServerBuildInfo
- getServerVersion
- getSchemaTmpValue
- getTypeOfResource
- getViewAndProcCreationOrder
- getXMLSchemas deprecated
- gitIntegrationActivatePushJob
- gitIntegrationDumpSystem
- historyUpdate
- importConnection
- importDataSource
- importIndex
- importMatTable
- importOptimization
- importProcedure
- importRecOptSymbol
- importUser
- importView
- isLoggable
- killQuery
- killSession
- logMsg
- md5
- recreateConnection
- refreshAllDataSources
- refreshAllSchemas
- refreshDataSource
- refreshLdapUserCache
- refreshMatView deprecated
- refreshMatViewRow deprecated
- refreshOptimizations
- refreshSchema
- removeConnection
- removeDataCatalogAttribute
- removeDataSource
- renameRole
- renameUser
- renameVirtualSchema deprecated
- resetCliTemplates
- sendLicenseFile
- sendOracleADWCWallet obsolete
- setColumnStats
- setCurrentDWH
- setDataCatalogAttribute
- setDefaultOptionValue
- setIndexStatus
- setJobProperty
- setOptimizationFrequency
- setPermissions
- setProperty
- setRecOptAllowIndexCreationByType
- setRecOptAllowIndexCreationByStatus
- setRemark
- setSchemaTmpValue
- setTableStats
- stopJob
- sleep
- testConnection
- translateColumnName
- translateColumnExpr
- updateSchedule
- webBusinessDataShopPublish
- webBusinessDataShopUnpublish
- writeConnProp
Procedures in SYSADMIN_VDB
- createSSHKeyPair
- createSSHTunnel
- createVdb
- importSSHKeyPair
- removeSSHKeyPair
- removeSSHTunnel
- renameSSHKeyPair
- importSSHTunnel
- getJavaProp
- setJavaProp
Procedures in SYSLOG
- clearFinishedJobLogs
- clearHistory
- clearJobLogs
- clearPerformanceLogs
- clearQueryLogs
- getQueryLogPlan
- getQueryLogDataLineage
Procedures in UTILS
- arrayToTable
- cleanTable
- convertCSVtoTable
- createTable
- csvExport
- detect_file_encoding
- displayRuntime
- download_sftp
- formatTableName
- getModularConnectorDatasourceCreateStatement
- getSmtpConfiguration
- getTableIntersection
- importSmtpConfiguration
- incrementalReplication
- internal_expandProperties
- isBigQueryTable
- prepareTargetTable
- returnExtremeValue
- sendCsvExport
- sendMail
- setSmtpConfiguration
- tableExists
- tableToJson
- tableToXml
- tryCast
- tryCastDate
- tryCastTimestamp
- unzip
- upload_sftp
- upsert