DSXchange

No that's the problem. there are no error or warnings. Here is the log

Sequential_File_37,0: No further reports will be generated from this partition until a successful export.
Sequential_File_36,0: Export complete; 0 records exported successfully, 74 rejected.

I am trying to write a sequential file and for some unknown reason, all my records are being rejected, The flow shows that records are being passed to the stage but the job detail show the records being rejected. I selected "overwrite", "Final delimeter" :end, Delimeter: comma, a...

What sybase software do I need to connect to a Sybase DBMS? Do I need to install the software on same box as DataStage EE? Is there any configuration changes that need to be done?

Thanks

This is the real file: <?xml version="1.0" encoding="ISO-8859-1"?> <!-- Edited with XML Spy v2007 (http://www.altova.com) --> <CATALOG> <CD> <TITLE>Empire Burlesque</TITLE> <ARTIST>Bob Dylan</ARTIST> <COUNTRY>USA</COUNTRY> <COMPANY>Columbia</COMPANY> <PRICE>10.90</PRICE> <YEAR>19...

I used the metadata imported to load the layout. My input is one field called TITLE. All the infomation is correct until I reach the numeric values. THe XML File is: - <CATALOG> - <CD> <TITLE>Empire Burlesque</TITLE> <ARTIST>Bob Dylan</ARTIST> <COUNTRY>USA</COUNTRY> <COMPANY>Columbia</COMPANY> <PRIC...

Sorry Ray, I agree, my message is very vague. I am taking a XML file (sequential stage) and parsing it using the XML Input stage. On the output tab, I loaded the XML format in the description column. It is defined as /CATALOG/CD/PRICE/text(). But my price comes out as zeros. I am not sure if I am su...

Two of my output columns are float and decimal.

The input is 8.99 and 1998

When I parse the input, zeros come out on the numeric fields. Is there a way to see my output correctly without putting a XML transformer in the stream.

Thanks

I got the record to come in but I get 0 records out. Is there another setting?

Thanks

I have been rading the manual and forum t see if I cold somehow figure out how to get the following into a readable format. I have run into many problem. Below is a snipit of what the input is; <!--BEGIN--> <?xml version="1.0" encoding="UTF-8"?> <CQMetricsRecord xmlns:xsi="h...

Yes, I agree, the documentation is difficult to comprehend. We have MQ working with a local queue but we cannot figure out how to connect to a remote queue. Hopefully someone has the solution.

We use the EE version and the MQ plug-in works locally. We are still working on remote issues. Has anyone use the MQ plug-in remotely.

Make sure you receive the 8.0.1 software. We initially received 8.0 a few months back and continually encountered problems. We finally received the latest version and all of our problems are being resolved. The GUI and documentation are also different with some stages.

Make sure you have the 8.0.1 version. We started with 8.0 and it is not the right version Full of problems.

As for authentication, your port is the problem. Make sure you have an available port. The installation default sometime collides with existing port usage.

No, we received a patch and then a newer release was issued called 8.0.1. I think there is some confusion with the release. After talking with an IBM rep, the latest version is 8.0.1 for Windows.

Hi all, We are coming up on three months now and we still do not have our Windows version of 8.0.1 working. IBM has been contacted and we are continually opening tickets. I would be very interested to hear if anyone using the Windows 8.0.1 version has it working properly. We use an 8 node box on a P...