DSXchange

Well thanks a lot for your reply.

I will plan to become an premium member asap.

And i can't use server jobs as the client is not going to allow us to deploy server jobs in their instance.

However i got the solution using awk script.

Thanks again for all your replies.

It would be of great help to me if you could uncheck the premium content and we are informed not to use any server jobs.

It would also help if i can get an unix script with support pattern matching and replace only the comma in the string and not the delimiter.

Hello all, I have an requirement where an csv file data should be read such that initial few columns will be fixed and the rest of the columns might be added or removed and any column data may contain comma(,) into it. So i need to get the following: 1. Fixed columns in one link and 2. The columns w...

Thank you all for your reply.

I found a solution..
- I used xml stage instead of xml output stage and mapped the required fields accordingly to get the required results and it works perfect.

Thanks again!!!

Key column is the "rid"

And the XPATH defined for
rid - /Attributes/@rid
referencedTerms - /Attributes/parentAttributes/referencedTerms/termRef/@identity

Hello All, I have a problem to combine all the attributes which have different terms into one. Job design : oracle connector - > Transformer - > xml output stage Obtained target data from the Parallel job : <Attributes> <Attributes rid="6662c0f2.ee6a64fe.l24jqigsp.covj0co.drb6tl.jfop11sr6p7jecl...

Yes, i looked to see for patches and found that there were no patches available for netezza connector.

I am using Datastage v8.7

No i didnot get any solution!

Yes i have set the parameter correctly.

The parameter is "Order_Number,Item_number"

The job executes if i use only one column as key column say for example if i pass only one column as order_number job executes fine problem occurs when i give multiple columns

Hello all, I am using netezza connector to update a set of records through Netezza connector through Datastage. I am using RCP enabled data from dataset and moreover i wanted to resue the same job for different table updates. While using netezza connector and passing the composite key columns to net...

Hi,
Target stage is Sequential file.The job operation is fetching the one record from source and write into sequential file.

Hi,
Source have only one row.So Datastage Designer canvas shows 1 row fetching from source and passing into target stage.But the job is not complete still running state.There is no warning and error message in the job log.

Hi,
I developed a job in windows environment.The job have only source and target stage.I exported the jobs from windows environment and imported into linux environment.After imported into linux environment,I compile and run the job.But the job is in running state without any warning.

Hi all,
I imported job from windows server to linux server.After imports,i compile and run the job.

But the job is in long run state.It is not finished.There is no warnings.

I need solutions for above problem.

Hello all, I have a requirement like to get the query from one ref table from one database and the same should be passed to ODBC stage in a job and there after it fetches the data from database and loads into a dataset My problem is i have different parameter sets defined for all sources (Note : I c...