DSXchange

i am Using Teradata connector stage in Target ,seeting there is access Method is BULK ,configured all the bulk seeting in the teradata stage , Trying to update a view of a table ,nearly 1.4 million rows need to update in the After sql i am collecting stats on the table and expilicitly supplying the ...

Can someone please tell me what is Param 1 in Match Stage. I am aware of m and u probability, but not exactly sure what impact Param 1 has on match and what are the acceptable values for this.

I am unable to use UCERT match without supplying a value for this.

Any help is much appreciated.

Thanks!

Can someone please let me know what is the difference between RPC and DOCLIT ?

Hello, I am trying to load a file with 6000 records in DB2. The job loads 48 rows out of 6000 and throws the following warning for remaining : [IBM][CLI Driver][DB2] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not vali...

Making the right decision here involves understanding the various topologies availabe in an RTI or WISD Job..... Job parameters can indeed be passed into an RTI or WISD enabled Job, as input for the SOAP or SOA client, but only when the job does NOT have a WISD input. Then the Job will be invoked o...

Is it possible to pass the value that the user provides through WISD Input Stage to some global variable that can be used anywhere in the job ? Thanks ! How about the User Variable stage? This will allow you to use the variable anywhere within that sequence job. Thanks for your response ! But I thi...

I have developed a parallel job and made it RTI enabled using WISD input and output stage. I am using DB2 stages to fetch data from database. The problem is that if I dont pass any parameters to the DB2 stage huge volume of data is selected.. resulting into an abend because of space issues. I am not...

Hi, I have developed a parallel job, published it as a webservice. I am calling this webservice using a Java Screen. The java screen displays the results correctly as long as I dont make any d/b changes. If I change an value in the d/b its not displayed on the java screen unless I undeploy and re-pl...

Hello, I have a master sequencer which calls multiple jobs. If any of the jobs fail then the master sequencer fails automatically. In all the jobs I have set the property 'Reset if required, then run' so all the jobs are automatically reset but the master sequencer remains in "aborted" sta...

Sorry ! I forgot to mention, we dont have MVS Edition. We need to develop parallel jobs.

Thanks Ray ! We are doing a POC. Our project requires us to pull data from IMS database. We can achieve this by using Classic Federation Server or/iWay Connectors, but that would require installing certain components on IMS. Since thats a long process and it might take a couple of weeks to get the p...

Hello,

Is it possible to call COBOL Routines from DataStage v8 ?

Thanks !

Hi, I was planning to use classic federation server to access data from IMS. Somebody suggested that Datastage can read data from IMS via the iWay connectors. Could someone please give some insight on iWAy Connectors ? How they work ? Which one is better etc .. Any response is much appreciated. Than...

Sorry ! I didnt notice that happening ! Will take care in future.

You choose a directory (not a symbolic link) where you want to install the DataStage engine. You also need to provide a directory that can be used temporarily during the installation process. As you create each project, you specify a directory for its location. There are defaults for all of the abo...