Ctrl Y EM in Datastage
Posted: Mon Feb 28, 2005 9:21 pm
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.
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"