DSXchange

Hi Chullet,

No I want to achieve this using existing Datastage EE. I don't want to purchase DS SOA just for triggering my DS Job using Java.

Thanks,
-Amit

Hi All, I am new to RTI and MQ stages. Can anyone please explain what is the main purpose of these stages? My requirement is to trigger my datastage jobs from Java (not using shell or perl script). I am thinking to go with work around solution. 1. Java class will send the message having job paramete...

Hi All,

Can I use WS Pack to achieve above functionality in Datastage EE?

Thanks,
-Amit Jaiswal

Hi All, I would like to know what are all the things we can achieve from Java Pack? In short the requirement is as below: We need to create a web based application/package/service which will do following tasks in batch as per the scheduler and configuration information: 1. Fetch files from various v...

Hi All,

Can we get evaluation version of Datastage SOA Edition? If yes, please provide URL.
Can anyone provide me pdf of Datastage SOA please.

Thanks in advance.
Amit

Hi All, Thanks for all this valueable information and suggestions. I'm thinking on the alternate solutions which is use of two jobs. One job to change the source file format to predefined format and another multi-instance job is to do actual transformation. I have another query related to same topic...

Hi, Requirement is to make everything flexible. As per that any new vendor can be added and he can send the file in his own format. Since data may come in millions of records (1-2 gig file) I am thinking it will be regular heavy overhead to reshuffle the columns and bring those into some common stan...

Hi All, We have some critical requirement in which any new file can come in any format and we have to just plug that file with the existing transformation logic. Source file can be anything like fixed width flat file, csv file, XML, SOAP, etc. I am thinking on following approach: Creation of datasta...

Thanks Ernie for valueable information!!!

-Amit

Hi, I am new to Datastage SOA Edn. I have few doubts in my mind : 1. Can we use DS EE jobs in DS SOA Edn.? 2. If yes, is it that the entire setup/architecture will be as it is which we are using for DS EE and we are simply invoking these jobs as web services? 3. What are the other benifits we can ha...

Hi,

I don't want to use shell script or perl script to invoke my datastage job. I want to invoke it only through JAVA. Is it possible to achieve it? If its possible in Datastage SOA Edn what is the method?
Thanks in advance.
-Amit

Hi All, In the existing requirement, we are using Java adapters to fetch the file using different protocols and store it on ETL server. Java is also used to do some intermediate stuff like scheduling, etc. Just wanted to know if it is possible to invoke DS Job or Sequence directly from Java. Present...

Yes you can do this by using sparsed lookup option instead of normal lookup. In case of db2 udb this is possible only with EE stage.
-Amit

We are using complex flat file stage in our datastage jobs. The data is coming from oracle stage then processing it and final creating complex flat file as the per the mainframe file layout. One of the field is defined as decimal but it is not having any scale that is no value after decimal. After p...

Hi All, We have tested Remove-Duplicate stage without using any Sort Stage before it. It is working fine and gives expected results. However, in DS help, it is specifically given that data should be presorted and Sort Stage should be used before using Remove-Duplicate stage. During development we ar...