DSXchange

Hi, Before loading data form flat file......I am trying to search a character in a file and remove it from that file using unix command.... My file looks something like this: test1.txt ckj12300_00|123|var1|10.2 ckj00200_12|444|var2|11.2 ckj00200_14|4556|var3|33.5 c00200_00_000|4558|var4|33.5 ckj0020...

Hi, I am extrating data from DB2 using DataStage native API for DB2/UDB. I have a User defined SQL. Based on the SQL logic the data is extracted weekly to a pipe delimited file and FTPed. I need some giudance with a portion of SQL query below. I extract one week data from the table with the logic be...

Hi, I am using an email notification stage in a sequence to deliver an email once the load finishes. The sequence runs mulitple jobs..... Is there a way to modify the default job status that is sent in the email. Actually I am trying to add: Total number of rows processed by the Sequence in the end ...

Hi Muroor.... There are couple of ways to read XML file. You can use sequential file stage, Folder Stage or XML Transformer Stage. I am using the Folder Stage to read the XML file. In the folder stage under the columns....there will be two columns one with the name of the source XML file and the oth...

Hi, I am trying to generate a fixed width flat file from pipe delimited flat file. Basically, I am extracting from pipe delimited flat file, perfoming transformations and loading into the fixed width flat file. The fixed width file has 15 columns and the width of all the column adds up to 925. But w...

Hi, Thanks for the help and suggestion. Finally it helped. I tried importing the metadata again and I added a wild character in the folder stage(under properties)...something like *xyz_filename.xml*. This tells folder stage to read the filename that begins with the above filename. I was getting repe...

Hi, I have a situation where I am using XML Input stage to parse the XML file. I am reading the XML document through the folder stage and send the output of folder stage as input into the XML Input Stage. The output goes into the sequential stage. I get pipe dilimited flat file. But I see quite a fe...

HI Guys...Any Input on this one....

Thanks
Raj

Hi, I have a situation...I have One Input XML source file and am generating another XML file in a desired format as an output using stylesheet. I am using the XML transformer to read the input.xml and produce the output.xml. The job runs fine and am getting the desired output data in my output.xml f...

Hi, I am trying to load an XML Document to a flat file through a XML input Stage. I am able to load data into the flat file that is pipe delimited. But I am getting two rows of data in my flat file for every one row in XML document. Below is my single XML row. Hence since xml below have two <perm> t...

Responding to rkumar: DataStage Job 67 Phantom 2588 Program "DSD.StageRun": Line 295, Square root of a negative number. DataStage Phantom Finished. This is a known problem with the XML pack on Sun Solaris. You should find that your job finished successfully despite this warning message, s...

Hi Kim, I have something similar situation as Chaitanya. I am trying to read a XML source and write to a flat file. When I validate it I hit this error: DataStage Job 67 Phantom 2588 Program "DSD.StageRun": Line 295, Square root of a negative number. DataStage Phantom Finished. I have unch...

Hi, We get this file from third party vendor secure website and they are not supporting FTP (ONLY HTTPS connection to their website). Currently, we are converting all process from INDIGO(another java based ETL tool) to DataStage. Indigo currently has a capability of making HTTPS connection. Looks li...

Hi, I have a situation....where I have to make a [url]HTTPS://[/url] connection to the third party web site to grab 5 files from their server. and load the data into relational table using DataStage. Can anyone please help me with the shell script for making this connection and grabing or reading th...

Hi, I have a XML source and the data from XML source needs to be loaded into the relational table. My issue is: How to read an .xml file using XML Input stage. I saw the Datastage PDFs, I need to create the xPath(I am not sure what it is) using XML Metadata Importer. Is this tool a part of DataStage...