substring option is not there in the paralle jobs.

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
pavankatra
Participant
Posts: 86
Joined: Wed Mar 03, 2010 3:09 am

substring option is not there in the paralle jobs.

Post by pavankatra »

Hi
i have string like pavankumar.
my output is avankum.

substring option is not there in the paralle jobs.

So anyone please suggest me on this.

Thanks in advance.

Thanks
pavan kumar
pavankatra
Participant
Posts: 86
Joined: Wed Mar 03, 2010 3:09 am

Re: substring option is not there in the paralle jobs.

Post by pavankatra »

pavankatra wrote:Hi
i have string like pavankumar.
my output is avankum.

substring option is not there in the paralle jobs.

So anyone please suggest me on this.

Thanks in advance.

Thanks
pavan kumar

i am sorry,i got one idea to solve this.
columnname[1,1] means it will display 1st character.

correct me if i am wrong.

Thanks
Pavan Kumar
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

[ ] operator is available in parallel job.

Code: Select all

var="pavankumar"
var[2] gives avankumar
You are the creator of your destiny - Swami Vivekananda
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Re: substring option is not there in the paralle jobs.

Post by anbu »

pavankatra wrote:
pavankatra wrote:Hi
i have string like pavankumar.
my output is avankum.

substring option is not there in the paralle jobs.

So anyone please suggest me on this.

Thanks in advance.

Thanks
pavan kumar

i am sorry,i got one idea to solve this.
columnname[1,1] means it will display 1st character.

correct me if i am wrong.
Thanks

Pavan Kumar
You are right.
You are the creator of your destiny - Swami Vivekananda
pavankatra
Participant
Posts: 86
Joined: Wed Mar 03, 2010 3:09 am

Post by pavankatra »

anbu wrote:[ ] operator is available in parallel job.

Code: Select all

var="pavankumar"
var[2] gives avankumar
thank you.It is working fine.

Thanks
Pavan Kumar
Post Reply