DSXchange

Ok. Was wondering because there wasn't anything that resembled an output OCI stage in your "diagram".

So, did you get your commit question answered?

There's no way to not commit your work. You do, however, have control over the commit level using the Transaction Handling tab on the OCI stage via the Rows Per Transaction setting. Default is 0 which means only after all rows have been worked successfully and the stage closes the connection. That b...

This post may help.

Unfortunately, no. I haven't promoted things via export/import or via the dreaded Packaging Wizard since VC came on the scene in 4.x. Hopefully, someone will pop in with some words of wisdom.

Your other option would be to call Ascential Support and see what they have to say.

Exactly. Or just type 'dsjob' from the command line without any arguments and it will remind you of the proper syntax. FYI, you have a couple of different options on what kind of status information you want to pass back as well.

(Version Control was not considered an acceptable overall method by the organisation). Ok, let's see. Promoting to Test via Version Control works fine. Promoting to Production using exp/imp doesn't. Hmmm... Use Version Control for the Production promotion as well. Continue to mark everything as 'Re...

It's not a 'Routine' in the sense you are used to. On your DataStage CDROM are several 'Utilities'. Under Utilities / Unsupported / Oci82Oci9 you'll find the piece of code you are looking for - oci8to9.b. There is a readme that explains how it is used.

Aha! Was just going to ask if you were promoting to a Protected Project, as this seems to be a known "issue" with Version Control. Not sure if there is a work-around or not, but you're not the first to have this problem.

In case people aren't aware, there is a whitepaper on DataStage and SP2 available in the File Library on ADN. As with most things SP2, it seems to concentrate on the Firewall changes.

I have yet to be exposed to SP2 at either work or home, so can't offer any personal insight.

If you find out it is not running, and bouncing your server doesn't magically fix it, check this thread for one of several examples on how to start it up in debug mode. This will help identify the problem. Not necessarily the solution, but at least the problem.

From a private message: Is there a way I can validate the length of a field? Do you know if this will work in a Parallel job? I only 'do' Server, so can't speak for the PX side of the house. However, my understanding is that anything you can do in a Transformer in Server, you can do in a BASIC Trans...

I don't think the OP meant "multi-valued" in the Universe sense, did they? Seems like they were just looking for a column where the values are seperated by commas, which seems like simple concatenation to me.

There are many functions that can help in your quest. Define all of the fields in your input Sequential stage as character and then run sanity checks in the transform. For example, use num to check to see if a field is numeric. If you are not familiar with what functions are available, check the onl...

Exactly. :D

Understood. I personally haven't seen where backups change the dates, but that could depend on the system and what is being used to perform the backup, I suppose. But in general though, I would think they would be reliable as long as one understands the type of actions that actually do update the ti...