Ctrl Y EM in Datastage

[tang]

Hi all

I have a special character Ctrl Y in the data and try to load the data into the sequential file (unix,Datastage version 6).

I've tried several ways to ignore it but still not managed to get it done.
The ways i've tried is belowed:

OCONV(String,"MCP")
This will convert the special character in ? but actually it still remain the special character just displayed as ?

change(Strimg,char(25), "")
Try to convert the Ctrl Y special character to null but DS can't detect it .

Is there any way that i can try?? HELP needed!! SOS.

dmcmActOneWayDataLinkbak1..TraditionalOneWayDataDownload.W_Latest_Policy_Activity_Hash: nls_map_buffer_out() - NLS mapping error, row 28 (approx), row = ""33200746",,0,,,0,"In Force","PAA",,,,,"",,0,0,13.0000,,,,,,,-1979,,,,"1",0,"1",,,,,,"2003-08-01 00:00:00.000",,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,203783858,200094618,200344302,,2003,-1979,-5,0,203794216"

[kduke]

Are you sure it is a char(25)? Your oconv() should change it to a period not a question mark.

[ArndW]

Hello Tang,

you have NLS enabled, and the locale and character set you have for the column attempts to do a mapping of this column and it is not defined. To check this out, turn off the NLS to this column (the job will most likely run, but not correctly).

What is your source map and what is your target?

[ray.wurlod]

More efficient is the Convert function.

Code: Select all

Convert(Char(25), "", String)

However, the Change function should have worked, if the character really is Ctrl-Y.

What you may actually be seeing is the non-first character of a multi-byte character. In that case, it's not Char(25) or even UniChar(25).

What do you see in the data browser?