Cant we extract # sign in data using ABAP EXTRACT STAGE

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
goriparthi
Charter Member
Charter Member
Posts: 57
Joined: Fri Feb 24, 2006 7:44 am

Cant we extract # sign in data using ABAP EXTRACT STAGE

Post by goriparthi »

Hi,


we are using abap extract stage to extract data from sap r/3 and in one of the jobs , i have a "#" sign in my data and i cant extract that , i mean the # symbol gets dropped when i am writing it to a sequential file.


Can any one of you guys help me out on this.


Thanks

Goriparthi.
sud
Premium Member
Premium Member
Posts: 366
Joined: Fri Dec 02, 2005 5:00 am
Location: Here I Am

Re: Cant we extract # sign in data using ABAP EXTRACT STAGE

Post by sud »

Hi,

As far as I know the '#' and '$' characters are special characters in datastage. Generally the problem comes when you have these characters in metadata, I am not sure why these characters in the data should affect anything. But, you can try by setting the DS_ENABLE_RESERVED_CHAR_CONVERT parameter as true.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
goriparthi
Charter Member
Charter Member
Posts: 57
Joined: Fri Feb 24, 2006 7:44 am

Post by goriparthi »

hi,


Thanks for your reply,

I tried it with the parameter enabled in both server and parallel job but it didnt work out . Is there any other work around for this.



Thanks
Goriparthi
Post Reply