DSXchange

But you could if you really needed it. All you have to do is set it up, the drivers come with the product.

It may, give it a shot and let us know. Make sure you only have the first 4 fields in the Column tab of the OCI stage. Also, try it first with just SYSDATE in the fifth 'value' position, I'm not positive you need to actually use the function in that case. If it doesn't work like that, try it again w...

All that advice is great, problem is it is only applicable to DataStage on a UNIX server. For a Windows server you have to play a different game, a game that I'm not familiar with or I would have chimed in earlier. You do have a 'configuration' issue of some kind. I would think that the Configuratio...

Wow... someone that actually reads the upgrade logs. Since all this was meant for support personel in the event of a problem, not us mere mortals, and since you don't seem to be having a problem - I wouldn't worry about it. At a guess, you'd need to open a support case to find out what exactly it wa...

Post your question over in the TX forum and we'll see!

In order to compare dates for something other than equality, you must make sure they are in a format that supports that. Two choices: 1) Internal format 2) Year first numeric: YYYYMMDD Make sure both streams use the same format and then you stand a chance of knowing if one is greater than the other....

I'm not familiar with any 'CurrentDate' function but there are several things like that you could use. Ones like DateCurrentDateTime or simply DATE.TAG with @DATE if you don't want the time. That's the confusing part for me. I'm surprised you've got one of the new TIMESTAMP fields and all you want i...

How did you try to use them? They can be made to work just fine as long as they are formatted properly. A couple of questions for you: 1) Out of curiousity, how are you defining the TIMESTAMP field in the job? As far as I know, the OCI stage doesn't really support these new datatypes. 2) Do you want...

How comfortable are you with writing BASIC job control code? That would be the 'simplest' approach in my mind, provided you've done work like that before. Your directory can be opened and read like a file to get the list of filenames in it. Probably an easier approach would be to use the DSExecute f...

Here is the cutter I mentioned. No need to reinvent the wheel.

T42 wrote:I believe there IS an option to export as XML.

Unless there is something new in 7.5, command line exports are strictly dsx format. Yes, you can do xml exports from the Manager, but they must be done manually.

Sure! There is a lovely little DOS batch job over on the ADN website that will automate this for you. If you are subscribed to it, then here is a direct link to the DataStageBackup.zip file in the Product Application file library there. It will export all jobs from all projects on a server. Only thi...

So you must have found this post by Roy where he asked the same question and posted what little he found out. Well, as long as you used the 'exact match' search, that is.

Perhaps someone has some additional light to shed on this?

As noted in the post you quoted, it is GA or Generally Available. You'd have to check at the eSupport site to see if it was available for your particular platform. And, yes, my general advice to peoples is to replace stored procedures like this with a DataStage 'equivalent'. Lastly - please avoid th...

No, a Universe table is something else and you would use DROP TABLE on it, from what I recall.