DSXchange

Oh! Thanks Ray.

So if config file is not supplied, then it uses the default space. But it should have cleared it right? So he was actually referring to normal datasets instead of virtual datasets. Am I correct?

Are the virtual datasets gets created in datastage home/Datasets directory?

I tried failing a job, it did not create anything there? Am I missing something here?

Oh..thts bad...We recieve bigger XML files with this format. I already have a solution in Java. I was exploring possibilities.

Anyways Thanks Ray!!!

Hi, I'm trying to convert XML to CSV. Is it possible to parse XML tag names with dots. For eg, we have the following structure. <?xml version="1.0" encoding="ISO-8859-1"?> <books.shiporder> <books.item> <books.title>Empire Burlesque</books.title> <books.note>Special Edition</book...

Hahaha... :D Thats not the case with us. I'll not rewrite the code and all. Users will have the ability to write logic and that logic will be executed. That will be small business logic they write in perl syntax. This will be embedded in Perl and executed. Now moving to Datastage,i know they might h...

Using external source stage to call perl programs? That wont be a nice option for us, as this would same as executing the Perl program we have now...

That did not strike me..

Are you suggesting build ops for this logic?

Was waiting for my premium membership. We cannot embed the logic into the code because, the code changes very dynamically. We have about 100s of clients and the logic will be changed by users and our system will run with that logic. Currenly its done in Perl. We do use DS PX for other functionalitie...

Hi, Is it possible to dynamically modify the logic of external CPP routine. So for example i've routine to calculate value for column A. Now there are clients for which the logic changes dynamically say Client X - Logic 1 Client Y - Logic 2 Client Z - Logic 3 The logic will be different but the colu...

Oh. Thanks Ray!!!

Ray,
This question is repeatedly asked in interviews. Is there a way we could use functions in row generator to generate alphanumeric sequence?

Thanks,
Firvin

Looks like its interpreting the outcome of wc -l as string. Try converting the value to integer.

Firvin.

I think the following command will work

wc -l <filename> | cut -f"1" -d" "

Thanks,
Firvin

Hi, I need a clarification regarding Partitions on Filter stage. For eg consider the following set of records. 1,NY 2,NJ 3,NJ 4,NY 5,NJ 6,NY Now i want to filter all the records from NY using filter stage(using two node config file). How does the partitioning works in the following cases. 1. Auto Pa...

Thanks Ray. Was trying different options in Row Generator for long time. Tht clears my confusion.