DSXchange

Thanks ernie.. Two links from xml input stage?? Thats where am getting this error...

yes, this is a sample xml... I tried to replicate the original one..Since i cannot post it..

Thanks

Hello All, I facing problem in laoding data into multiple tables. I have a single xml file and it looks like, <Item> <Item Number>001</Item Number> <Item Name>Rod</Item Name> <Item Code> P001</Item Code> <Item Desc> Iron type </Item Desc> <Item Desc> Red Colored</Item Desc> <Item Desc> 0.2 dia <Item...

Look at the output link of your XML Input Stage.....go to the Descriptions of each column..... chances are, the elements you are retrieving are missing the final /text() from the xpath syntax. Without the "text()" it means "get the whole element"....... ....so it should be .../....

Hello All, I am trying to read from a xml file and load the data into SQL Server. My job design is as follows. External Source Stage -> XML Input Stage -> Transformer -> ODBC Here, the problem is the data in table is entered along with the XML Tags :( Eg: <Name>Meena</Name> <DOB> 21121986 </DOB> In ...

Hi all,

Can anyone give me some basic information on how to connect to the following products from datastage in unix and windows?

1)primavera
2) sap
3) ariba
4) maximo

Thanks in advance.

ray.wurlod wrote:

Harini wrote:But i would want all the jobs as a single dsx file. Is it possible to do that?

It is not possible. You could construct a single DSX file out of the individual job DSX files, w ...[/quo

It's a premium content..

No, it's either one job or all jobs. You'll need another solution, perhaps something like the DSX Cutter posted here or an iterative loop, for category exports. ... Craig, Iterating the loop would give me a seperate dsx file or each job. But i would want all the jobs as a single dsx file. Is it pos...

Thank you all. Yes i use 8.1, but am not sure whether istool patch is installed. I would give it a try if we are able to get it. From a windows environment, I believe the following command would do the export for me if it is whole project. C:\IBM\InformationServer\Clients\Classic\dscmdexport /D=serv...

Hi all, Is there a Unix shell scripting solution to acheive this? Thanks Hi all, I have to take the back-up of all DataStage jobs from the project repository every week, this is a requirement of the client. I can export the whole project at one shot, but the client want us to export by folder. This ...

ray.wurlod wrote:This particular operation is not possible in the Modify stage. ...

Oh, thank you.. !

anbu wrote:Use convert function to remove unwanted characters

Code: Select all

Convert("() -","",Phone_No)

Is the syntax same, to use in both modify and transformer stage?

yes, it is just that, i was not confident whether one can execute a xmla file, from unix, like running a shell script.

I would have to write this is "After job sub-routine" in my job properties..

E:\Practise\filename

Hope i got it right..

- Harini

Yes, i got your point. Thank you..

Am not quite sure of the command used in Unix to run the XMLA files.. Any idea pls?


Thanks and Regards,
Harini

No.. I meant executing the script is Unix's headache, isn't it?

I would like to know the command which would run the xmla file..

What datastage does is, it gives a option to run unix commands...
We can't say that datastage execute the script, can we?


Thanks and Regards,
Harini

Thank you Craing.. Below is the sample file: <Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Parallel> <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas....