xml stage ds_loadlibrary: error in dlopen

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 ...

DataStage XML Pack

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 ...

File size problem using XML Stage

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. ...

XML Stage and XPath Expressions in DS7.0

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 ...

Help on XML stage with Header and Detail nodes

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 ...

Error while working with XML Stage

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(). ...

Can't find the XML based dynamic tree

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 ...

XML for dynamic data

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 ...

DataStage - XML Output Stage

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 ...

XML with dynamic attributes based on column values

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 ...

Datastage XML Best Practices document

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 ...

DataStage: ABAP Stage

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? ...

XML Stage is parsing the contents tagged as "CDATA&quot

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 ...

XML Stage is parsing the contents tagged as "CDATA&quot

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 ...

XML to dynamic array

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 ...

number/pound sign in XML through dynamic ColdFusion?

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 ...

XML based dynamic dropdown menus in ASP

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 ...

XML based dynamic dropdown menus in ASP

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 ...

XML Recursion / Dynamic Tree Structure

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 ...

DataStage: FTP Stage Sourcing an AS400

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 ...

Problem with SQL sort in Datastage server - stage: Oracle_OCI_9i

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 ...

XML binary base64 Data Type

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 ...

Ascential DataStage 7.0: problems using XML Input stage

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 ...

Handling Recursive XML with the Input Stage

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? ...

XML file validation in Datastage 7.5.3

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 ...

Generating XML with multiple node occurrence using XML output stage

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 ...

Dynamic xml by a Servlet

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 ...

How to pass the missing value for XPath from Xml Input Stage

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 ...

replace an xml file

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 ...

Display xml By Servlet

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 ...

XML object

/*DOM XML ticker- © Dynamic Drive (www.dynamicdrive.com)For full source code, 100's more DHTML scripts, and Terms Of Use, visit http://www.dynamicdrive.comCredit MUST stay intact*///Container for ticker. Modify its STYLE attribute to customize style:var tickercontainer='<marquee align="cent ...

Mysql to XML problem

The following code works fine to convert mysql to xml but one of my databases contains html tags e.g. I get an error when trying to put a </p> tag in the xml. My code is:<?header("Content-type: text/xml");$db_name = "Dynamic"; //This is your database Name $link = mysql_c ...

XML and UTF

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 ...

xml file rading problem

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 ...

XML error "The name '{0}' is not a valid NCName"

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 ...

Creating XSL stylesheet for MPG dynamic back-end

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 ...

Dynamic php/js select options

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 ...

Oracle PDF rendering with PL/SQL dynamic region

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 ...

Oracle Newbie - How to create XML based on given schema

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 ...

Ubuntu xml vs html vs flash website?

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 ...

Help Need Urgent

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 ...

XMLStage and XPath support in DS7.0

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 ...

Perfomance issues

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), ...

How to get the current(to be selected) load balancer group member.

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. ...

How to get HTTP Status Code from the back end server.

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. ...

Oracle Problem using XMLDOM API

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 ...

mouse moves panorama, x and y coordinate changing

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 ...

Oracle RW-50004 while installing R12

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 ...

Oracle Applications Release 12.1.1 installation on windows 2003 failed

I am installing oracle 12.1.1.0 on windwos 2003 SP2.I received some errors at the step 1 of 5 and till 13% of installation.THe following are the errors reported in the Install log file located at: Database logfile - F:\oracle\VIS\db\tech_st\11.1.0\appsutil\log\VIS_stccspr018101732.logE:\StageR12\sta ...

Oracle RW-50004: Error code

i have this error if any one please help me with it "" RW-50004: Error code received when running external process. Check log file for details.Running APPL_TOP Install Driver for PROD instance ""and his my log file .... _____________________________________________________________ Processing DriverF ...