DSXchange

If you don't use Version Control, how are you handling the promotion? Are you manually setting the read-only attribute as part of that process? Perhaps you could just reverse what you are doing to mark it and then remove the Transform... Unless it's one of the supplied Transforms, these are read-onl...

It shouldn't be prompting you for anything. Something is wrong with the configuration of the dsadm user. Have you checked the readme to see if there are any special instructions for your particular Operating System or version? Also curious, does the .profile for dsadm source the dsenv file, or did y...

Suggest me how to increase the performance... Does 'transferring into Oracle' mean inserting? If that's the case, drop your extracted records to a Sequential file and then bulk load them. SQL*Loader, especially a direct path load, will beat the pants off an OCI insert any day of the week. Otherwise...

Check your Server Job Developer's Guide documentation for the Command Line Interface section. You can use dsjob from your O/S to get a list of all jobs in a Project. You can also write some Job Control code and use some of the various "DSGet" functions available. Sorry, don't recall the exact name o...

Victor,

Searched the forum and found this post, one of several which all seem to point to the same problem / solution.

Or simply post the Stage variable derivations here... that would help.

Yes, it is. Thought for a minute about using "Get Ax. Kill Troll." to continue the theme, but...

Yes I did! And thank you very much, kind Sir. Have to check them out when I get a chance.

The solution for this turns out to be rather simple - delete the Project and restore from backup. Nothing else would fix it. True confessions time - this turned out to be a problem of our own making. Reader's Digest Condensed Version: We needed jobs to handle 478 CDC tables so we built some processe...

ray.wurlod wrote:DataStage does have its own backup/restore utility but I doubt that very many folk use it.

Or perhaps even know about it. I get the impression this is something different from the 'normal' import/export of projects so... what you talking about?

There's a game you can play with embedded CR/LF pairs in your data that magically turns into multiple rows when written out. There is one of a number of posts on this subject here where it is discussed. Seems to me you could do something similar, on a group change add your "dummy" record to the fron...

Thanks Kim. I ran through both the LIST.INDEX and the CLEAN.ACCOUNT steps and while the Cleaner did point out a couple of things, they didn't seem fatal and I didn't let it delete anything. One was something about "DSD_BP" pointing to something it couldn't open - "object/runtime". Plus "DS_PLUGIN_ST...

Josy, this has nothing to do with your user but with the way the ODBC drivers are licensed to be used. There are a number of posts here on that topic, for example this one. As you've found, they are only licensed to be used under the GUI via the ODBC stage. They will work for something like 30 outsi...

Just because you found it on your server doesn't necessarily mean it is supported. I believe you'll find they ship all of them and then (in the documentation) tell you which ones will or will not work per platform. I'm not somewhere where I can verify this at the moment, but there should be an entir...

Strangest thing just happened. Today I imported 478 jobs into an existing Project. They were all in one Category and showed up 'Uncompiled' as I expected. Fired up the Multiple Job Compiler and told it to find all of the uncompiled jobs, which it did. Walked away from it while it merrily worked its ...