DML functions

The following DML functions provide a definition of each function and one or more examples for your use.

abs

addAttachment

addDays

addMessageLoggerEvent

addSeconds

addTrace

average

byteSize

ceil

checkBICSubtypes

convertToD

convertToI

convertToR

convertToV

count

countAttachments

countString

countTraces

dayOfWeek

dayOfYear

decimalPortion

exponent

extract

floor

formatString_dates

formatString_integers

formatString_real numbers

generateUniqueId

generateNextIdInSequence

getAttachmentContentId

getAttachmentContentType

getAttachmentData

getAttribute

getClass

getContextAttribute

getDate

getDateAndTime

getDateAttribute

getDay

getEnv

getHours

getInboundUserAttribute

getInputInstance

getInputMessage

getIntegerAttribute

getJMSIntegerProperty

getJMSRealProperty

getJMSStringProperty

getLastTraceCode

getLastTraceMessage

getLastTraceModule

getMessageLoggerId

getMessagePriority

getOutboundUserAttribute

getRealAttribute

getTraces

getMinutes

getMonth

getName

getSeconds

getStringAttribute

getStringLeft

getStringRight

getSubString

getTrackedObjectId

getTrackedObjectName

getTrackedObjectUserId

getTime

getUTC

getYear

index

indexChildInstance

integerPortion

isAbsent

isFirstChildInstance

isKeyPresent

isKeyPresentInPeriod

isLastChildInstance

isNull

isNullOrAbsent

isObjectAvailableOnServer

isValidAmount

isValidIBANCode

isValidBICCode

isValidISINCode

keepJMSChannelProperties

length

makeDateAndTime

max

min

nbDays

nbSeconds

padStringLeft

padStringRight

remainder

removeContextAttribute

removeJMSProperty

replaceIfAbsent

replaceIfNull

replaceIfNullOrAbsent

replaceString

replaceStringAll

returnColumn

returnColumnInPeriod

round

runProgram

selectAllAttachments

selectAllAttachmentsForOutput

selectAttachment

selectAttachmentsForOutput

sendCycleLink

setAttribute

setContextAttribute

setDocumentAttribute

setDocumentAttributeToOutput

setEnv

setJMSDocumentProperty

setJMSProperty

setMessagePriority

setTrackedObjectAttribute

sum

toLower

toUpper

trimString

trimStringLeft

trimStringRight

truncate

updateBICTable

unselectAllAttachments

unselectAllAttachmentsForOutput

unselectAttachment

unselectAttachmentForOutput

Related Links