DSXchange

Oh. Do you have more details on the fix pack ? Can you please share it ? Because, we also see that the Update Commands are failing randomly in many jobs. Example of error message shown below, DB2_Tgt_Opty_Brand_Updt,0: Statement UPDATE RMT.OPTY_BRAND SET SYS_MODIFIED_BY=?,ACV_EXPIRED=?,ACV_RENEWED=?...

Hi, We have an Update job, which uses DB2 connector stage to update the DB2 table. The job finishes successfully if there are rows to update. But it fails, if there are no rows found to update with the below error message. DB2_Tgt_Opty_Brand_Updt,0: SQLExecute reported: SQLSTATE = 02000: Native Erro...

HI I have a source table that contains the different kind of the 10 departments information is available. I need to retrieve and load the alternative records from the each department. EX OF DATA: employee table contains the different departments like, savings department,current department,fixed depa...

HI can anyone help me how to resolve the below xml issue. i am using one sequential file stage--->>xml input---->copy stage. as i am taking source file of : <customer> <custname="suma">suma</custname> </customer> XML input document parsing failed. Reason: Xalan fatal error (publicId: , sys...

HI i am getting the below error while compiling the xml job.

failed to invoke Genruntime using panthom process failuer.


could any please help

thanks in advance

suma

HI I am using the below sample xml source to read from xml job, but i am n ot able to make it success. i am using the external source-->xml input---->copy stage. but job is getting hang not able to sucess <Customer> <CustNo Value="suma536784">suma536784</CustNo> <CustName Value="sumal...

HI

could any help me to create the xml job in parallel please. i need to read the xml data and load into the target.


thanks in advance.

Suma.

HI I have one requirement i am tring to load data into the target like: my input data size is numeric(10), if i get the data like 25685, i need to load into the taget like 0000025685 if data is coming 5 digit , remaining preceeding zero's should come, if 2 digit data is coming 8 digit zero's should ...

Hi I am loading the xml file to sequential file using the server jobs. my job design is like: folder stage--xml input---transformer-sequential file my source is like: <customer value="123">123</customer> <custid value="234">234</custid> but after loading this file i am getting on...

Hi I am trying to load the data from xml source to taget file, i am able to load from the key column only, remaming columns will be getting one record data menas (name=kiran,kiran kiran) like all the records are coming in name column, evern though i am passing unique data in that column. could any o...

Thanks buddies for your valuable inputs.

I understand MONTHS_BETWEEN database function will work.

Can any one suggest if there is any datastage function similar to the above one? or any combination of functions available in datastage which can be used in transformer?

Cheers.

HI Query Busters, Can any one help me to find out number of years between 2 dates using transformer stage in Datastage 8.1? Eg: 1900-03-20 (yyyy-mm-dd) to 2010-11-20 (yyyy-mm-dd) I need to find out number of years(decimal value like 12.4 years) between the above dates. Leap years between the 2 dates...

I have wriiten as small script to get list of all jobs in a sequence. I am using dssearch utility to extract the list. Currently i have used this script in 2 sequences Seq1 and Seq2. In dev and test environment it runs fine for both sequences but in prod, it runs fine for Seq1. For Seq2 it gives Sta...

I am using oracle 10g, i tried with many ways but its not allowing to continue, its giving same as below error, it needs to be closed, please help needed on urgent issue close. thanx in advance Regards Kumar HI I am trying to implement the data stage server job, one of the column i am trying to conv...

HI I am trying to implement the data stage server job, one of the column i am trying to convert the CLOB data type to char or varchar, ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4450, maximum: 4000) could any one suggest me how to proceed the above issue. Immedia...