DSXchange

No I don't find any PATH variable that has the value $ASBHOME/apps/jre/bin.
Not much familiar with dsenv file.

Edit your dsenv file and put $ASBHOME/apps/jre/bin and $ASBHOME/apps/jre/bin/classic in the LD_LIBRAY_PATH and put $ASBHOME/apps/jre/bin in the PATH. This way you fix both web service problem and also the Java stages for parallel jobs. Part of my dsenv file LIBPATH=$APT_ORCHHOME/lib:`dirname $DSHOM...

Don't know what exactly you are trying to do but creating user variables using User Variable stage in a sequence job can help you.

I believe you can use them in a routine and call them using Basic transformer in PX.

I read the blog and was able to design the job with webservice transformer followed by regular transformer then a peek stage. I did everything suggested in the blog but when I run the job I get this warning warning Web_Services_Transformer_1,0: Error: TJClient::initialize: unable to create Java Virt...

Or If Isnull(col) then '' else col ...for both columns.

I have imported the metadata but i am not sure sure what stage to use and what will be the next step.

I used Num() and it gave me the result I want.

thanks bart12872 and jdmiceli.

I have a column with apha, alphanumeric and numeric values, I want to pass only numeric values and want to make apha & aplhanumeric values empty. I tried using if len(convert("ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefhijklmnopqrstuvwxyz","",col)) = 0 then "" else col but its...

Yes Craig we have a web service call to do that, but I have never used web service package in data stage so I don't know how to call it from data stage job.

I will try it and let you know.

Normally we just go to the Windows IIS server and bring it down/up the site manually. We also have asp.net webservices by which we can do the same.

But now we want to automate it, may be using datastage (web services).

I am new to web services and have searched the forum for the solution but couldn't find anything helpful. We have a website published by asp.net on Windows machine and we need to bring it down before we start our batch cycle and then bring it up once batch cycle is completed. And data stage is on Un...

Couple of options -- 1.You can try joining the tables in the same query using better indexing (test on toad first if you are using it). 2. Try using join stage if your reference data is more than source. 3. Not sure if you can use surrogate key stage to generate your sequence number. 4. Use hash par...

Even I believe Ray that there should be no reason it shouldn't work, but in my case I tried different option still its not working.

Since this is a new addition to Data stage, I think not many people have tried using this.

Then what should be default in the value file ?

What I observed is what ever you default in value file is what its using ..... No matter what you have in Parameter tab default.