DSXchange

This only happens when exported to isx
dsx export dont have any issues.

not sure if it helps. but wanted to provide more information.

Hi All, I am getting an error while exporting one of the Rleset's TBL file as an .isx file. ======================== Failed: Error exporting design time data: An invalid XML character (Unicode: 0x90) was found in the value of attribute "content" and element is "DataStageX:DSDataQualit...

Hi, I am able to read the data from HDFS files. the folder structure as below. /data/projectname/zonename/dbname/tablename/partfilexxxxx* Question: How do I read the read if the data is stored in partition on business_effective_date like below /data/projectname/zonename/dbname/tablename/effective_da...

I am creating a before job subroutine It looks as below. My aim is to set a parameter. but Para=DSSetParam(DSJ.ME,'ParamName','JobName' ) always returns -1 to Para full code ================================= $INCLUDE DSINCLUDE JOBCONTROL.H ErrorCode = 0 JobName = DSGetJobInfo(DSJ.ME,DSJ.JOBNAME) Par...

Hi,

As a first step, you can or ask your admins to monitor the resources on Datastage server and the Oracle server to find out the bottle neck and then take the necessary actions.

you can call the job as a service.
Read below for more details.

https://www.ibm.com/support/knowledgece ... ogies.html

Well I have the domainname/mdmqs instead of only mdmqs it worked perfectly.

Thanks for the help guys.

login window opens up with domain name as the project name.
when I don't give /D then, in the login window which opens project name is empty.

Sorry for the delay.
mdmqs is the project name.

Hi, I am having a problem. when I trigger the dsexport command instead of exporting the login window opens up. the command I am triggering is dsexport /H MDM2BCCPP03:9080 /U user /P user01 /JOB S000_Duplicate_Contract_Component_Remediation mdmqs C:\Export\S000_Duplicate_Contract_Component_Remediatio...

Hi Andy,

I checked the MSG HANDLER.
There is nothing to suppress any NULL related warnings.

Regards,
Samyam

Hi,

yes it turned out to be a metadata issue.
specifically turned out to be NULL handling capability in the transformer.

Once we added the NULL handling function the code worked as expected.

The only surprising thing about this whole episode is there are no warning on the director.

Regards,
Samyam

Nope no warning.

File is empty.

So the code is extracting data from DB2 into a transformer and then writing it into a seq file.

In the performance stats I can see 10 records extracted from the DB2 and 0 records after the transformer.