I met this following library load error when executing one XML stage against DS standard edition v7 (AIX v5.0.1) at customer site. It seems that the plugin library couldn't be load. I want to know whether i can re-install these three XML plugin stages( input/output/transfer) instead of re-installing ...
In the article "Transform and integrate data using Websphere DataStage XML and Web service packs" an example is used using DB2 Table definitions to create XML output. Is this XML pack a requirement to create a correct XML output file from XSD files in the standard DTX mapping process? I need to bett ...
We are using XML stage for loading data from files which contain multiple records. There appears to be a problem in using XML stage when file size exceeds 300MB. Has anyone observed this and if so, what are the possible workarounds for addressing the issue. ...
I have both server and parallel extender jobs that use the XML stage. I was wondering whether anyone has a list of XPath functions that work in the XML stage in DataStage7.0? Currently the only XPath function that I can get to work is 'text()'. The documentation provides very little information othe ...
I have a requirement where in i have a XML of the form. I need to aggregate all the customers and the parts that they supply. The input to the XML stage is at part level. I need to know the transformation settings on the XML output stage.ThanksChaitanya. A partial schema is given below.<xsd:schem ...
I am arunkumar.while i am working with XML stage,I am getting this error.Not only for this stage.Stored procedure stage(STP),WebService stage also.Please help me regarding this issue. This is the error I am specifing here.XML_Input_0,0: Error occurred in call to ORPHCallActivePluginInitialize(). ...
I remember seeing a rather nice XML based dynamic tree on this site a day or two ago, but now I can't find it...I've scoured my history and even did a Google search on my local comp, but I can't find it. It is similar to this http://gosu.pl/demo/mygosumenu/1.5/example1.html but is done with XML. Can ...
i am new to XML and need help from you:i have created a HTML file that does the following: using select and option tags a list of names and ages are provided. every name has a predefined age. the user has to select a name and an age and click on the submit button. if he selects the correct match, a ...
I am using XML Output stage to convert data from CSV into XML formats. For some reasons, only the first row of repetitive nested elements written out to the XML file.I have set up the input of the repetitive nested elements as the keys based on the given documenation but it still doesn't work. Would ...
I have been banging my head against the wall for TWO days. I have gone back and forth with a very patient guy on thescripts.com. You can see the ridiculous thread here http://www.thescripts.com/forum/thre...8777-1-10.html If you have time, at least peruse that so we don't go in circles. Anyway, if y ...
I am a newbie to datastage and am working on XML stages. I came across a best practices document "BestPracices.doc" by Hernando Borda in the net at Duke's site http://www.duke-consulting.com/Downloads/XmlPackBestPractices.zip. (Last update Apr-23-2003) I was wondering if there might be a recent vers ...
I would like to find out whether ABAP Stage can be used to trigger/execute an existing ABAP program in the R/3 System? If not, can DataStage trigger an ABAP program? If yes, use what and how? ...
We have a requirement where we have to send out a message which is in XML format. The Message has an envelope and payload. The payload is itself a XML document. The Payload is enclosed within a "CDATA" tag to indicate that the contents of payload should not be encoded (the < , > being replaced ...
We have a requirement where we have to send out a message which is in XML format. The Message has an envelope and payload. The payload is itself a XML document. The Payload is enclosed within a "CDATA" tag to indicate that the contents of payload should not be encoded (the < , > being replaced ...
I've got an XML-file which can contain different values and keys. I manage to parse it and print it out, but I'd prefer to have a dynamic array. And I don't want to take it the hard way with xx loops and stuff. And if evals shouldn't be the way either...I don't know if the criterias I've given makes ...
I am trying to deeplink to a state in my Flex application using a dynamic output from CF.Here's what i'm trying to do, i have a ColdFusion script that takes my database items and turns them into XML<cfquery name="qGetList" datasource="#dsn#">select *from myTablewhere xmlOut ...
I am trying to create an XML based set of nested drop down menus. Essentially you would have three (or n) menus (i.e. Make, model, year). Each menu is dependent on the value of the previous box to populate itself and is dynamically updated via JavaScript when its parent box is changed.I know how to ...
I am trying to create an XML based set of nested drop down menus. Essentially you would have three (or n) menus (i.e. Make, model, year). Each menu is dependent on the value of the previous box to populate itself and is dynamically updated via JavaScript when its parent box is changed.I know how to ...
Im working with a hierarchial tool that has unlimited levels. Im trying to design a element that will build out infintely with tree nodes depending on the inbound data. There is basically 1 EID root, then below it there can be an unlmited tree build out. I want the xml structure to build out like th ...
System Specifics:DS = v 7.0.1OS = AIX 5.2I am having a problem when using the FTP Stage to dowload data from a remote AS400.My Job:FTP Stage => Transform (straight mapping) => Flat FileFTP Setting:Data Representation Type = "ASCII"Check Data Against Meta Data = "YES"Line Termination = "No Term ...
I see something strange with a sort with the stage Oracle_OCI_9i: I'm in an Oracle_OCI_9i_0 stage and I put the following request: select * from (select 'aa11' from dual union select 'aa22' from dual union select '22aa' from dual union select 'bb11' from dual union select '11aa' from dual) order by ...
I'm trying to import an XML file that have imbedded XML document with data type binary base64 in it (xmlns:dt="urn:schemas-microsoft-com:datatypes" dt:dt="bin.base64"). I'm not sure if I can use DataStage XML stage to decode/convert this tag to its original file format (pdf/doc). We are running DS v ...
We're having issues properly using the Ascential DataStage XML Input Stage components in version 7.0 on AIX 5.2. We are trying to gather job statistics in a database table by selecting the "DSJobReport" routine to be executed after we run our job. We are specifying that the "DSJobReport" routine cre ...
I am going to be processing some recursive XML definitions and am wondering if the DataStage XML input stage will handle this. Has anyone had any experience using DataStage with recursive XML? ...
I'm new to using the XML Input/ Output stages in datastage.recently i have been asked to find/ build a solution to validate an XML file fed in as input. I believe that i would need an XSD/ DTD file as a comparison base which has to be supplied to the XML stage.However what I need to know is, can thi ...
How to generate XML with multiple node occurrence using datastage XML output stage?Our issue if we have source file containing the following data(first line is the header)"DeptID","EmpID1","EmpName1""EmpID2","EmpName2"10,1,ham,2,samOur target XML should be like the following<dept>< deptid ...
I try to display a Dynamic xml by a Servlet which refer a Xsl file. it show the Following errors.............. [b]The stylesheet does not contain a document element. The stylesheet may be empty, or it may not be a well-formed XML document[/b][i]But I can display the Dynamic Xml File (with out referi ...
While parsing the XML message using XML input stage, for some of the Xpaths (mentioned in Output tab) we don't have values in the source XML file. But for this the values needs to populate as Null.I have tried with options available in XMl stage, but no luck.Also i am getting the below mentioned war ...
ok so i have this xml based dynamic 3d carousel...and i want to make it to where i can load another xml file when you press a button to toggle between the "new animations" page and the "old animations" page. i thought loading the new xml file in an onrelease function....but all i ...
ear Friends, I try to display a Dynamic xml by a Servlet which refer a Xsl file. it show the Following errors..............The stylesheet does not contain a document element. The stylesheet may be empty, or it may not be a well-formed XML documentBut I can display the Dynamic Xml File (with out refe ...
I have an XML-FILE, there I see the Name of a brasilien company as follow (I put the blank now in that you can see it normaly they are out): Thyssen Fundi & # 231 ; & # 245 ; es When looking it with MS-Explorer it is correctly shown as: Thyssen Fundições But when I load it with DataStage X ...
I have problem while reading xml file and I don't how to use xml stage. Can any one help please.I got only below xml file and I'm getting problem while importing MetadataJob I Design for xml reading.External Source(Stage)------>xmlinput(Stage)------->Sequential file(Stage)<?xml version="1.0 ...
On DS 8 Enterprise Edition and when running the Part II of the "Transform and integrate data using WebSphere DataStage XML and Web services packs" tutorial, I am getting the following error message:Tutorial_XML_3..XML_Input_21: The name '{0}' is not a valid NCName.expression = '/:CustomerInfo' Remai ...
I would like to use a MPG or XML firewall dynamic back-end for some services. Reading thru the documentation the only reference I see is creating an XSL style sheet which will pull the server names and address from the client request. Is it possible to route the client request based on the incoming ...
folks... I'm stupmed.I am working on a part of my shopping cart for the item administrationpart. In it, I want the admin to choose where to place this item.First, he will select the category:<?echo "<select id=\"item_category\" name=\"item_category\" class=\"input ...
The problem with the reporting is:- if you want flexible, enhanced reports you can't use the report engine- PDF output works only with the report engineMeans: At the moment you can't do enhanced, printable reports with HTML DB without using OAS & Developer.Is there some possible way to generate ...
We have a requirement to create an XML message from our system (Oracle 9iR2 with Oracle Apps 11.5.10). The XML is generated from a query in our HR tables, and must be in a specific format (schema and example XML has been provided to us). Newbie question is this: What is the best way to create this X ...
I am importing an XML data file into an XMLType field in a table, then extracting data within a tag. I am using Oracle Database version 10.2.0.2.0The data file I am using looks like:<?xml version="1.0" ?> <_PARENT><_EXAMPLES><_ITEM_NO>1</_ITEM_NO> <_PAX_NO>1</_ ...
My problem is simple, but I am having difficulty solving it. Simply, I have an XML file with multiple records in it, with the tag <Row> identifying each record. I am attempting to retrieve each of the values in the leaf nodes within the <Row> parent, where the XML data is stored in a tab ...
XML parser failed in oracle 10g product version is 10.2.0.3.0I am getting the fallowing error message XML-24521: (Error) Element not completed: 'PurchaseOrder' Parser Exception: Element not completed: 'PurchaseOrder'Here is the sample PL/SQL code CREATE OR REPLACE PROCEDURE transform_xml ( p_process ...
i find xml very dynamic and rich, many portfolio websites are in flash(makes sometimes ugly). I decided and tried making a website in html, but it lacked the elegance, richness and no much user rich experience?? i showed my website on a localhost to my friends, but they quiet din't like style of htm ...
Please help me to resolve this issue.. Im trying to fetch records from xml to database... The XML is likeisrMasterData>- <safeGuardRatingList>- <safeGuardRating><code>HS</code> <name>Highly Satisfactory</name> </safeGuardRating></safeGuardRatingList ...
I have both server and parallel extender jobs that use the XML stage. I was wondering whether anyone has a list of XPath functions that work in the XML stage in DataStage7.0? Currently the only XPath function that I can get to work is 'text()'. The documentation provides very little information othe ...
As per my observation, each transformer and XML stage is converted in one process when RTI job is running.To provide the output to front end, I have do get data from 2 tables. As these lookups are dependant on each other, I can take 2 approaches:1. Use 2 Db2 stage and 2 transformers (i.e. lookups), ...
I am working on a voice command driven program. The recognized commands change depending on the current content available at the time the program initializes, so I have a .xml grammar file that is updated between uses of the program. The problem is that when I use LoadCmdFromFile, it always returns ...
Environment : Datapower XI50 3.7.3.1XML Firewall, Dynamic BackEnd (using LoadBalancer) Question : I would like to know how can I identify the current (or to be selected) LoadBalancer memeber as a BackEnd server in a programmatic way. ...
Environment : Datapower XI50 3.7.3.1XML Firewall, Dynamic BackEnd (using LoadBalancer)* Question : I would like to know how I can get HTTP Status Code from the back end server. ...
I have an xml saved as clob. The xml is as<EntitlementRule logical="Or"><Criteria match="Equal"><LegalEntityAttribute name="type" value="SME"/></Criteria><Criteria match="Equal"><LegalEntityAttribute name="type" value="abd"/></Criteria><Criteria match="Eq ...
I am hoping someone might be able to offer some advice with the following project. Please seehttp://www.vrwebdesign.co.ukPlease click and drag the mouse, I would really like this to control the panorama on the monitor screen. All the project is in the same flash file. At the moment click and draggin ...
I got this error while installing Oracle applications R12 on linux AS4 or Oracle unbreakable linux (I got the same error on both OSs)During step 2 in the installation (Configuring Database) i got the following error:RW-50004: Error code received when running external process. Check log file for deta ...