DSXchange

Thanks Kumar!
Your answer was very informative.

But unfortunately i shouldn't either edit the .dsx file or go for Kim's parmeter Nav here.

So, i've manually entered all of them.

Actually, i am creating a new datastage job for which there are 50-60 jobparameters to enter manually which is a very tedious work.So, i'm working around for the solution..

Hi,

I have around 50-60 parameters which needs to be entered into the job parameters of the Datastage job. So, do we need to enter manually or is there any other way around??

Got the answer by searching in the database!

Hi, Can any please give me the reason why i am getting the below warning in my PX job? main_program: Warning: the value of the PWD environment variable (/etld/etl/ascential/Ascential/DataStage/DSEngine) does not appear to be a synonym for the current working directory (/etld/etl/ascential/Ascential/...

Hi ajith,

Thank you very much!!
For exporting this, do we need to be in the root or in DSEngine subfolder??
Can you please give me the steps involved for executing this 'dsjob' command?

Hi ajith, Do you mean that first i have to be in bin subfolder and execute the following?? ./dsjob -run -mode NORMAL ./etl/ascential/Ascential/DataStage/Projects/<project> ./etl/ascential/Ascential/DataStage/<jobname> I am getting ld.so.1: dsjob: fatal: libvmdsapi.so: open failed: No such file or di...

Hi ray, Thank you for the reply. Here is the way i was executing the command. I was in 'bin' subdirectory,then gave.. dsjob -run -mode NORMAL /etl/ascential/Ascential/DataStage/Projects/<project> /etl/ascential/Ascential/DataStage/<jobname> but still i am getting the same error.. Please let me know ...

Hi all, I'm new in running datastage job on unix. So, just wanted to know the way it is done. After browsing to the DSXchange database, i could find the following steps.. In the unix prompt 1)went to the Datastage home. Our dshome is --> /etl/ascential/Ascential/Datastage/DSEngine 2) then ran the co...

Hi,


Thanks for your responce.
Do we need to update the odbc.ini file also.
And can you clarify me on 'putting the DB2 profile into dsenv' part?

Hi,


I am very new to AS400 systems on which our present database (DB2) is present.
Now, we need to interact with the DB2 database using Datastage EE.
Can we connect to the DB2 database on AS400 servers directly from Datastage DB2 stage??
If not how do we do that??

Hi thanks for your replies.. ArndW, My data is like this.. Col1 10 10 10 20 20 30 30 30 30 I should get the total no. of groups for this column. I mean in this case i should get 3. ray.wurlod, Do you mean to say that, i should do groupwise counting in first one and total groups counting in the secon...

Hi all, I have a requirement where, i have some groups coming up from the source and i have to capture the number of groups and pass the count further. I believe we cannot do this in aggregator because it will count the no of records for each group. Ex: Col1:- 10,10,10,10 col1:- 20,20 Col1:- 30,30,3...

Hi Balajisr,


Thanks a lot!!!
Your cleansing really works fine...

Hi Balajisr,


I tried doing that..
But it isn't working....