DSXchange

Thanks for the information . So for my scenario I should be using ORAOCIBL stage as I have to load it to Orcale 9i. I am planning to have this design approach now. ODBCstage -----> Transformer ------> ORAOCIBL stage And in ORAOCIBL stage have a after job subroutine to invoke the sqlldr to load the O...

1. What is the difference between ORABULK & ORAOCIBL stage. 2. What is the best scenario in which to use to use this stages Scenario in which i want it to use. 1. Unload data from Redbrick database (I am using an ODBC stage to unload record and it is working fine) 2. Load the unloaded data to Or...

Scenario. i have 3 fields coming in as an input say( ID, Name, Age). And i want to introduce one field call "Indicator". Now if i have duplicate combinationcoming in the output should look like ID Name Age Indicator 1 Surjit 25 1 1 Surjit 25 2 1 Surjit 25 3 2 XYZ 26 1 2 XYZ 26 2 3 rty 34 1...

In DS version 6 always use transformer before and after XML parser .

Once i put a transformer between folder stage and Xml parser the job executed as if there never was no error.

thanks all for ur reply

The job runs without any error and i see the rows being picked up but it is not being written to the file i am getting this error now. CopyOfContracttrial..XMLInput_1: Xalan warning (publicId: , systemId: , line: 0, column: 0): An exception occured! Type:RuntimeException, Message:Warning: The primar...

Can someone throw some light into this

Can someone please forward this document XMLPACK_20_Designer.pdf to surjit.meitei@gmail.com

it doesn't come with my installable cd but i need it badly

Yes indeed its a big XML but i have given just the starting information of the XML ...

I have used folder,XMl input,transformer and seq file stages..

Please refer the chain to get the way i have proceeded

How to import xsd metadata into DataStage via the Manager

My XML look like this

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<qaar_na_pi xmlns:ns1="http://www.drivelogic.com/services/qaar ... ataobj/xml">
<report_info>
<rpt_date>01/19/2007</rpt_date>

I have tried out this option taking hints from discussion postedbefore 1st stage - Used Folder Stage. In the OUPUT tab of the FOLDER stage, i have defined this 2 columns FILENAME (DEFINEd as a key with SQLtype VARCHAR) RECORD(Defined as SQLtype LONGVARCHAR with length like 99999999) 2nd stage - used...

Hi i have come across two features in DataStage 1. XML Input 2. XML Reader My requirement is to read XML from a folder(which contains lot of xml) and populate it to a sequential file . Which one of the above feature suit my requirement? I have used XML input before to fetch XML from a MQ and populat...

It is known that an XML reader can be used to process XML but .... Can DataStage Process Blob file to get information from the blob and put it into a table .... Explanation of the requirement.. I have Table A, where in one of the column XML is stored as BLOB.. I have to retrieve this XML from the Bl...