DSXchange

Thanks Ray

Hi Ray

What would be the service names I should be looking for ?

Regards

Hello everyone

Which process/processes on red Hat Linux I should be checking to make sure all three data stage tiers are up and running?

Thanks in advance

Yes pretty much what you understood, I need to do. So you are suggesting that no options in Parallel jobs and I may be looking at writing custom code. Is that correct?

3. 1st PUR record will get a value 4050.9797 - 449.0203 in the column allocated_saleunits and then balance will be taken to the next PUR record for setting value in allocated_saleunits column of PUR record. This will continue until the sale_unit_balance is 0. This is the 1st step When sale_unit_bala...

it is difficult to explain exactly in words what I need to do. let me try again. 1. Read the 1st Record in the example above (which is 1st SALE transaction) and get the value from column salelog_unitssold 2. Go to 1st PUR Transaction which is the 4th record in the example 3. IF salelog_unitssold > p...

Hi Everyone, I have complex case of transactions where I have to match sale to the purchase transactions by say starting with a sale transaction and compare to the purchase transaction for units sold . Based on the units sold GT or LT units purchased I have to split the sale or the corresponding buy...

I am having an issue with following select statement when running a DS job Strange thing is that it works from ODBC stage when I cut and paste this statement interactively in ODBC stage Select LocateRef, PlaceRef, REPLACE(REPLACE(REPLACE(TheAddress, CHAR(10), ' '), CHAR(13), ' '), CHAR(9), ' ') AS T...

I had checked the links you suggested. You have understood it correctly. I am totally new to datastage and trying to figure out how it works. Your suggestion worked. Thanks for your help

I don't recall the exact syntax off the top of my head but a search here should turn it up if you look for 'counter' I would think. From what I recall you need to index into the list of parameters using the counter and you usually create a delmited list all at once for the StartLoop stage to iterat...

The Port number is not provided and did you also modified uvodc.config file in project folder?

Hi I have created a job sequence in this flow ExcecuteCommand --->StartLoop--->UserVariableActivity--->Jobactivity--EndLoop I am doing a cat in ExcecuteCommand to get the content of a txt file which looks like this ABN,Acct_BfwdData,Acct_CGTList,Acct_DiffList I am looping around this file with a com...