DSXchange

Is there any way to pass an oracle table name as parameter from input data? I have a column table_name in my input data and I want to use it to update that table. I have such table: FOR r_ct_map IN (SELECT fermat_contract_type, view_name, table_name FROM e_contract_type_map) LOOP And for every recor...

Does pack for sap r/3 allow to connect to mySAP app?

In job properties select Parameters tab and then click Add environment variable and then New. In a name put 'date' and in prompt '$ENV'. And now you can use that variable in transformer. It will return system date. In default value put also '$ENV' and when you run the job you should put value '$ENV'...

But the xml input stage implies using a folder stage to read xml file. And I am wonder that it would be a problem to read a huge files by that stage...

Read using XML Input
If there would be difficult in processing such large files, is there any other way to extract data from xml file to flat file? And not writing a basic routine
Or maybe the easiest way is to use some external tool to process that file?

Regards,
Piotrek

Would be DS able to process a big XML data? There will be about 20milion records in one input file, each record has 75 columns.

Regards,
Piotrek

Can I process such a xml document: <ASN1> <I> <C> <P>aaabbb</P> <P>cccddd</P> </C> </I> </ASN1> to an output file like this: P1,P2 aaabbb,cccddd //one record ? Not: aaabbb //in different records cccddd Is there some way to make that by XML plugin? Regards, Piotrek

Hi, It was just an example of a SP. I was wondering about capabilities in making some logs while using SP stage. I know that it could be easily implemented via DS, but our company's customer is using some SP's to upsert data to oracle and there is a possibility that he won't agree to stop using that...

Is there any method to get summary of stored procedure execution on oracle database? I use a target method in stored procedure stage. My SP is just inserting data in a oracle table. The most valuable information would be how many records were succesfully inserted into oracle table. Thanks in advance...

Can we use an external libraries(*.h - not from C standard) in custom stages code? I have some libraries, written by myself, and I need to use them in a build op stage. If so how to use them? Where I need to put the files?

Regards,
Piotrek

Do you have some examples how to write that in DS? Maybe it would be easier to implement that in DSEE build op stage?

Has any one some advices how to proccess ASN.1 files in datastage? I know that I can use some external coverter, but I am wondering if I can handle it without an external tool...

Best regards,
Piotrek

Thanks a lot for your help. I will try to set up db2 connection properly.
If I get some errors I will post it

I have got working properly DB2 UDB API stage. And I have a DB2 client installed on my ds server machine. And I want DB2 Buld load stage to use DB2 client software to connect to a remote db2 server machine. But it is not working. I suppose that db2 client is installed properly, cause I have tested a...

You mean that I need install DS client on that machine where I have db2 server? Or DS server? And it will solve the problem? Any further steps to do in configuration?