DSXchange

Can you share the Xpath you have defined in the XML input stage?

/Sankar

We don't need to use the @INROWNUM instead assign zero to initial value for stage variable.

Pls try using VARCHAR(999999999) datatype..

Hi,

The Stored procedure that I'm executing returns array value. How do we need to handle in terms of output parameter and datatype..

Please advise. Thank you.

Thank you all for your responses...

Hi,

We have a requirement to read the MS access database and the datastage is installed in linux server. Can we use ODBC stage to acheive this scenario. Please advise.

Thank you...

Thank you for your response...

Hi, I'm getting the below error message while executing the stored procedure through Datastage. Please let me know the cause of the error. Thank you for the help.... Fatal Error: Fatal: ORA-06550: line 1, column 7: PLS-00201: identifier 'OSS_TEST.PR_PROC' must be declared ORA-06550: line 1, column 7...

Hi - If I don't specify anything on the data element, I can be able to read the XML records but it doesn't seems to be a valid one. I'm getting the below error message on the XML input stage. APT_CombinedOperatorController,0: Fatal Error: Fatal: XML input document parsing failed. Reason: Xalan fatal...

Hi - I removed the prefix soapenv from the xpath and the job ran fine.

Hi - I'm getting the below error message while reading XML records from MQ connector stage. This happens when I set the data element in MQ property as XML. MQ_Connector_ReadXML: ?? (IIS-CONN-WSMQ-000003; Argument uszDataElementName has invalid value XML; CC_WSMQUtil; buildWSMQDataElement(); CC_WSMQU...

Hi - This issue got resolved. Thank you.

Hello -

I have a requirement where I need to decode the encoded images which present on the each XML transaction. Then each decoded images should be saved in tif format. Could you tell me how this can be achieved?

Thanks

Hi - Do I need to parse each and every tags using XML input stage and then write them to the sequencial file stage. Please advise.

Hi - I'm facing an issue while reading the XML file using XML input stage. Below is the error messge. I have also provided sample XML file. Could you please help me to resolve this issue? Error msg: ERI01_ExtractReinsXML..XML_ExtractTiff: The prefix 'soapenv' is not declared. expression = '/soapenv:...