DSXchange

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

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 wron...

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

anbu wrote:Use string

Code: Select all

IsValid("string", StgVar10thChar) 

Thanks for your rapid reply.It is working.
Thanks alot

Thanks
Pavan kuamr

Hi, i am using this function in stagvariable. IsValid("varchar", StgVar10thChar) it is throwing error like "invalid type:varchar" StgVar10thChar may be contains number or charecter. so could anyone please help me how to declare VarChar datatype in IsValid function. Thanks in Adva...

ray.wurlod wrote:Compile it with your C++ compiler. There should be a Compile control in the Visual Studio suite. ...

Thaks ray.
i have tried,it was resolved...

thanks
Pavan Kuamr

chulett wrote:Or just convert it to an empty string rather than a space, save the whole 'trim' part. ...

yes it is resolved.
my input is 12345-3-2
expected output is:1234532

for this i used StripWhiteSpace(convert(columnname,'-',' ')).

Thanks
Pavan Kumar

ray.wurlod wrote:Without the actual error message we can not help.

"not working" is merely a synonym for "unemployed" - it is not useful for diagnostic purposes. ...

Thanks for u r reply.

actually i got import error.Now it is resolved.

Thanks for your help.

Thanks
Pavan Kuamr

Sainath.Srinivasan wrote:Can you let the forum members know why you want that to be solved.

An exact replica was posted few days ago.

Any interview slots to fill ? ...

THanks for your reply.

I have created stage variables to resolve this issue.

Anyway thanks everyone.

Thanks\
Pavan Kumar

ETLJOB wrote:Try "LongVarChar"

THANKS FOR YOUR REPLY.

But it is not working.

Thanks
Pavan Kumar

Hi,
i have varchar column in a flat file, that has 16000length data.I am unable to read the data from the sequential fie.

so can anyone please tell me how to read that file in the datastage.

Thanks in advance

Thanks
Pavan Kumar

A) It's not urgent for us but I just happen to be up and posting at this time. B) Why not spell out your requirements in words rather than code? Tell us what you have to do, not how you think you need to do it. i want to implement that for loop in the datastage,so can anyone please suggest me how t...

Hi
How to do some calculation in a loop ?
loop is given below.. its urgent..
for ( i = 0, n = 0; i < 9; i++ )
{ n += (10 - i) * x.charAt(i) };

Quick help will be appreciated a lot

Please anyone can help me on this issue.

Thanks
Pavan Kumar

nani0907 wrote:hello .that correct.you are converting it to space .trim it also

yes
that is working,Thanks RAY
Thanks
Pavan

ray.wurlod wrote:Convert() ...

hi ray,
i have used convert function like
convert('-',' ',inputlinkname)

can you please let me know whether it is right or not.

THanks
Pavan Kumar