" in source data and job aborts

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

" in source data and job aborts

Post by vinaymanchinila »

Hi,
I have a descriptin column which has " in it like "cobblers" . To replace it with space or none, is it better to use Change funstion or replace?

Thanks,
amsh76
Charter Member
Charter Member
Posts: 118
Joined: Wed Mar 10, 2004 10:58 pm

Post by amsh76 »

Try Convert...
kbsr
Premium Member
Premium Member
Posts: 3
Joined: Tue Oct 19, 2004 3:51 pm
Location: Silver Spring, MD
Contact:

Post by kbsr »

Hi Vinay,
you may want to refer these links
viewtopic.php?t=93743
viewtopic.php?t=92763
Regards
vinaymanchinila
Premium Member
Premium Member
Posts: 353
Joined: Wed Apr 06, 2005 8:45 am

Post by vinaymanchinila »

Thanks a bunch, it helps. Let me try this out.
Post Reply