DSXchange

Hi,

i have loaded the datas into XML output stage, i want to use the same XML file as an input in another job.
In order to use the XML file i used XML Input stage, but i couldn't extract the XML file.

Can anyone of you help me in this

Thanks in advance.
Siva

Hi All,

Wat is the exact difference between the Normal transformer and XML transformer in Datastage Server edition.
Is their any difference in XML transformer and how can we hardcode a value in an XML transformer.

Thanks in Advance,
Siva Kumar N

Hi,

Suppose you have 100 records with different salary values from source.

I need to get the Nth max value from 100 records.

Example:

I need to load only the 5th maximum salary value alone into the target table.

How can we achieve this?

Thanks in Advance,
Siva Kumar N

Hi ,

how to remove duplicate rows using transformer stage?


Thanks in advance,
Siva Kumar N

Hi ,

if 3 table having different columes. like first table
having 4 columns , second table having 3 columns and third
table having 2 columns then how to capture the data by
using funnel stage in parallel jobs

This error is due "not having permission to some developers".There are developer in different default groups...change everyones default group to 'dstage'... :) Details of different error codes are mentioned in kumar_s post in the below link: :lol: http://www.dsxchange.com/viewtopic.php?t=...

Hi All,

Colud any body let me know the reason for the Error "DSJE_REPERROR" Job Return Code: 255.

This i am getting while i am ruuning the jobs through the scheduler. But if i am running through the Unix that job is running fine .

Thanks in advance

Is their any possible way to convert an Datastage Server Job to parallel extender, (ie., to implement the parallelism concept in server jobs).

For the above scenario Pivot stage can be used to convert the rows into columns.Use the Derivation field in the output link column grid to specify the pivots.

Hi , While running the job through the script i am getting the following error Status code = 0 Host Name : grmetltest01 Project Name : ADWCED Error running job Status code = 30107 Error running job Status code = -2 DSJE_BADSTATE Job Return Code: 255 Status code = 0 Job Status : RUN FAILED (3) Job Co...

Hi all,

For deleting Datasets i am using
orchadmin rm <Dataset Name>
But if i execute this through Unix box its giving "orchadmin not found'

Can u pl help me....

Hi, i am getting an error in the aggregator stage. It is ' Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use the modify operator to specify a value to which the null should be converted. ' i have enabled the "Stage Options : Allow Null Output=False&qu...

Hi , in aggregator i am getting an waring "Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use the modify operator to specify a value to which the null should be converted." But i have enabled in the "Stage options: Allow Null Output=False&quo...

Hi All,

when we are running the job through the script we are getting an erroe like -99 DS_BADSTATE Missing paramter values. even the job is compiled and also all the prameters are passing through the scripts.

Can u pl. Put all views on this

I am getting the following error while running the DS jobs. This is due to File Sysytem Space. So what could be solution for this.
"code -968: SQL0968C The file system is full. SQLSTATE=57011"