Differences for On-Demand

In SBM on-demand, certain actions would not be safe and are prevented as described below.

Functions that are not supported in SBM on-demand:

• AppRecord
  • ReadWithWhere
  • Add
  • Update
  • UpdateWithLock
  • Delete
  • SetFieldValue
  • SetName
  • Lock
  • Unlock
• Change
  • Not used in an on-demand environment.
• AppRecordList
  • Update
  • ReadWithWhere
• AppDb
  • GetConnectionInfo
  • ReadDynaSQL
  • ReadFolderItems
  • ReadIntWithSQL
  • ReadIntegerPairsWithSQL
  • ReadIntegersWithSQL
  • ReadTextWithSQL
  • ReadTextValsWithSQL
  • WriteBlobToFile
  • UpdateBlobFromFile
• Ext
  • NewTask
  • NewTaskWait
  • CmdLineWait
  • ReadTextFile
  • WriteTextFile
  • AppendTextFile
  • FileExists
  • AcquireLock
  • ReleaseLock
  • LockIsAvailable
  • HasLock
  • Sleep
• VarRecord
  • StartTransition
  • StartTransitionWithLock
  • FinishTransition
  • QuickTransition
  • StartSubmitToAux
  • FinishSubmitToAux
  • QuickSubmitToAux
• ProjectBasedRecord
  • StartSubmitToProject
  • FinishSubmitToProject
  • QuickSubmitToProject
• Log
  • Log
  • Open
  • Close
  • SetBackUpLogFile
  • SetMaxSize
  • SetWantTimeStamp
  • SetReportingLevel
  • IsOpen
  • GetFileName
  • GetReportingLevel
  • Message
• Field
  • GetRequiredFlag

Functions that behave differently in SBM on-demand:

• CreateObject
  • AppRecord-based objects can only be created if they are based on a table that is from the current user's namespace, such as a primary or auxiliary table, or from a system table that has a TS_NAMESPACEID column (rows from namespace-striped tables can only be read if they match the current user's namespace).
  • SBMLibrary is not allowed on-demand.
• Ext.CreateAppRecord
  • AppRecord-based objects can only be created if they are based on a table that is from the current user's namespace, such as a primary or auxiliary table, or from a system table that has a TS_NAMESPACEID column (rows from namespace-striped tables can only be read if they match the current user's namespace).
• Ext.CreateVarRecord, Ext.CreateProjectBasedRecord
  • The record must be for a table that is valid for the user's namespace.
• Ext
  • Functions that refer to table data, such as TableDatabaseName, must refer to a table from the user's namespace or a system table.
• AppRecord.Read, AppRecord.ReadByColumn, AppRecord.ReadByColumnAndColumn
  • No data is read from tables that are not directly tied to the namespace or have a TS_NAMESPACEID column. No records are returned in namespace-striped tables in which the TS_NAMESPACEID is not the current user's namespace.
• AppRecordList.Read, AppRecordList.ReadByColumn, AppRecordList.ReadByColumnAndColumn
  • No data is read from tables that are not directly tied to the namespace or have a TS_NAMESPACEID column. No rows are returned in namespace-striped tables in which the TS_NAMESPACEID is not the current user's namespace.