DSXchange

Are you asking just about the Client component? I still don't believe DataStage has been certified for Vista, and you'll be fine with XP. For the client.

Couple of options. You can execute the UNIX command "test -s" which returns true if the file exists and has a size greater than zero. You could then "not" that or handle that appropriately in your triggers, such that only an empty / zero byte file triggers the next process. You could also use a gene...

[sigh] OK, missed the UV v. TCL difference. I'm not sure how to "not" something like that, I believe you need to do the filtering when doing the 'readnext' processing of the select list created.

Excellent. Please mark the post as Resolved using the button at the top of the page.

Let me be more explicit. You left out the WHERE keyword and you haven't specified what field should not be "like" your pattern.

Where what "not like"?

New topic = new post. Please mark this one as Resolved (button at the top of the page) and start a new one for this question.

Looks to me that the "DateGenericToTimestamp" routine may not be compiled, as what cannot be found is "DSU_BP.O/DSU.DateGenericToTimeStamp".

Cumbersome. Me, I'd make of backup copy of the file first, and if you let DataStage do that for you, a 'reset' of the job will undo the changes automagically. Well, in a Server job anywho, no clue if PX also plays that game.

Yes, we know. And?

1) Sure there is. When you go to "Open" the file in the XML Meta Data Importer tool, there is a prompt for "Files of type". Both "XML schemas and documents" and "XSD files" will work, as well as the ever popular "All files". Unless it has totally changed for 8.x, that is, but there still must be a w...

What are you importing from? An xsd or the xml file itself? Best to get an xsd if at all possible.

Right, we can see that, which means there should be no reason to "convert it to XML in Windows".

krishna81 wrote:"Only one top level element is allowed in an XML document. Error processing resource"

Your answer is right there... nope.

And the extension doesn't matter, txt v. xml, what matters is the content.

There's one for "OK" and another for "Failed", did you try those and they are not working for you?