DSXchange

I need to create a ticket for reporting this to the official support provider. They will be taking this up with IBM. I am doing it right now.

This was solved by manually validating the delimiters. But this is surely a bug in datastage which IBM needs to handle. An alphabet or a special character cannot be accpted in place of a "/" delimiter which is the part of a datastage function. Solution : If Col[3,1]<>"/" Or Col[6...

Hi, I am running with a problem where I am reading a flat file with Seq file stage. I have a timestamp field with value 11/30/2012.22.05 without seconds values. I have set the format string in the column definition as "%mm/%dd/%yyyy.%hh.%nn" and reading the field as timestamp. The values a...

Ernie, What I got was a bit different. I managed to pivot the data and write to XML. But I wanted something like this. <Items ReasonText="20111222102212" ShipNode="5868" YantraMessageGroupID="5868.20111222102212.303919.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema...

In the seq file stage what datatype you have given for the date columns. The date columns are not in proper format. Change those column types as Varchar and try reading it.

Ravi, I tried the pivoting option. But could not understand the repetitive element option you told. So my output is coming as below. Need to tune this now. <Items ReasonText="20111222102212" ShipNode="5868" YantraMessageGroupID="5868.20111222102212.303919.1" xmlns:xsi=&...

Thanks Ravi for your response. But I did not understand your solution. Let me explain my understanding here. You want me to define Supply type 1 to 5 in Transformer with values as ATS,EIP,OIP,RIP and TROUBLE in transformer. Here my questions is regarding the next sentence "For respective Quanti...

Craig, The I am not provided with the XSD. The original format yielded me the below XPATH expression for the columns. Items/Item/Supplies/Supply/@ATS Items/Item/Supplies/Supply/@EIP Items/Item/Supplies/Supply/@OIP Items/Item/Supplies/Supply/@RIP Items/Item/Supplies/Supply/@TROUBLE Thr original forma...

Craig,

I dont have an XPATH written yet. I am creating the XPATH from the sample output that I have here. I have to split this single row into multiple rows for the Supply category here.

I guess it will be /Supplies/Supply/@SupplyType
/Supplies/Supply/@Quantity

Hi, I have a requirement where I need to convert flat files to XML files. I am able to do it. Problem arrived when the customer changed the XML format. I need to trnaform it now as per the requirement. The input looks like : UPC-NUMBER | WMITEMNUMBER | DESCRIPTION | ATS| TROUBLE| RECEIPT-IN-PROGRESS...

Craig,

I took off the copy after the XML ouput and it worked without any other stage after XML output. I would start a new thread on the validation part again. Thanks for the help !!

Craig,

I tried without the %% in the file name and it failed again because of XML validation. I unchecked the box and then it worked. Not sure why it failed for validation. I had imported the metadata by using a sample XML file.

Thanks.

Craig, I tried that. But my job is failing with a warning "Invalid filepath. Cannot use %%%% or %%@@ when the stage has no output link" and also an error "Error occured in call to ORPHCCallActivePluginInitialize()" Thats why I have added the copy stage to get the output tab in th...

Hi, I am trying to create multiple XML files from a sequential file using the Trigger column method. My requirement is for every different value of a field an XML file has to be created. My design looks like this. Seq file --> Transformer --> XML output --> Copy Stage Here used the Trigger column op...

There are around 250 datasets. I was thinking of some shortcuts to do this So thought of going for the RCP. I managed to keep it to one job. I guess I need to get the column names from the schema files then. Thanks Ray.