DSXchange

"Reference Link with multi row result set" can you only use in ODBC stage Both the ODBC and UV stages, actually. And the UV stage can be dropped 'over' a hash file, so technically it is possible to do this with hash files. Not very efficient without tweakage, and the hash must be in an account or h...

True, but the FMT command can do that for you.

You haven't properly configured DataStage to support the OCI stages. Follow the steps outlined in the Plugin Configuration Guide or the OCI reference, both available in your Docs directory as pdf files. If you think you've already done that, let us know what steps you did do and we'll see about gett...

Or the chapter in the Server Job Developer's Guide that documents the Command Line Interface.

You only 'need' to compile everything if the import doesn't contain the executables. Some people do it regardless just to be 'safe' and that's not necessarily a bad idea, depending on exactly what and from where you are importing. Your version includes the Multiple Job Compiler tool, available from ...

It is a new CD setup. I have no idea what that means. You had so many issues with your installation before this, we'd need a better idea of what the last things or steps were that you took to get to this point now. When you say "new CD setup", do you mean you tried to install it on another server, ...

Sure... multiply your source field by the number of decimals after the implied decimal point and then use the FMT command to right justify and zero pad the field. Or use the FMT command to do the whole shebang, check out the 'descale' option in the online help - the command can do both at the same t...

Unfortunately, I don't have a Windows based server to try this out on. It "should" work fine once you figure out whatever the issue is, as I've done things like this from the UNIX side more than once in the past.

Sorry.

That should mean that there are no files in your directory that match your wildcard pattern.

What happens if you take your exact same filter command and execute it from the command line in a 'Cmd window'? I'm guessing you'll get the exact same error.

In the Filter command of the sourcing Sequential file stage. Note that doing it this way will only remove 'duplicates' where the entire row is duplicated. If that's the case here, then that is pretty simple to set up.

You can call me Ray if you like.

Yes - you do have to put something in the filename box. As far as I know it doesn't use it, but you need something there.

Try this instead:

Timestamps (as a DataStage data type) don't support milliseconds. And as Arnd noted, if you succeeded in changing the type to a string in all of the appropriate places, it would stopped throwing the error.

No problem, happens all the time. Ray's suggestion of leveraging the Filter command of the Sequential file stage would be best, I would think. Only issue after that would be how you keep it from reprocessing the same files later. And the answer to that will depend on how 'dynamic' the list of files ...

What did you do to be "able to proceed installing"?