Mapping Services 3.3.1 DML Users Guide Save PDF Selected topic Selected topic and subtopics All content 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
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