problem with special characters while reading from AS400

[throbinson]

Craig must be on vacation.
What is athe ASCII value of the special characters you want to reject? Find that out and only write records that don't contain them. Write those that do to the reject link.
'?' just means the character is unprintable. You need to replace the '?' with the ASCII value (CHAR(x) for example where x is the ASCII number).

[zulfi123786]

Craig must be on vacation.
What is athe ASCII value of the special characters you want to reject? Find that out and only write records that don't contain them. Write those that do to the reject link.
'?' just means the character is unprintable. You need to replace the '?' with the ASCII value (CHAR(x) for example where x is the ASCII number).

Is There any cunction that returns the ascii code of a character in datastage.

[throbinson]

DS Help would have answered your question faster;

Seq(character)

Code: Select all

 
Converts an ASCII character to its numeric code value.

Syntax
Seq(character)

character is the ASCII character to be converted. If character is a null value, null is returned.

Remarks
The Seq function is the inverse of the Char function.

[zulfi123786]

DS Help would have answered your question faster;

Seq(character)

Code: Select all

 
Converts an ASCII character to its numeric code value.

Syntax
Seq(character)

character is the ASCII character to be converted. If character is a null value, null is returned.

Remarks
The Seq function is the inverse of the Char function.