Information icon IBM InfoSphere DataStage and InfoSphere QualityStage, Version 8.5
space Feedback

SQuote Function

Encloses a string in single quotation marks.

Syntax

SQuote (string)

string is the string to be quoted. If string is a null value, an unquoted null is returned.

Example

This is an example of the SQuote function adding single quotation characters (') to the beginning and end of a string:

ProductNo = 12345
QuotedStr = SQuote(ProductNo : "A") 
* result is "12345A"

PDFThis topic is also in the IBM InfoSphere DataStage Server Job Developer's Guide.

Update timestamp Last updated: 2010-09-30