DSXchange

More complete answer: from the Administrator client Command window for the project. Alternative answer: from the TCL prompt on the server, which you need to get to via telnet then invoke when attached to your project directory (and having run the $DSHOME/dsenv script) using the uv or uvsh command.

First thing to check is whether the dsrpcd process is running.


If it's not running, you need to find out why. Search the forum for dsrpc, netstat and debugging to get some techniques.

But, if you really, really wanted to, you'd need an appropriate DEFFUN declaration
ExecSH is in DSU (not DSD or DSG) because it is supplied as an example of user-written before/after routine.

Every DataStage job has a unique number, and the mapping is in the DS_JOBS table.
Beware that the SQL is case sensitive.

Nothing on Windows automatically uses other than the current drive. Why did you think DataStage would be an execption? You can specify the location of a hashed file in two ways: by creating it in a folder on the F: drive by creating a DataStage account (project) on the F: drive and specifying that t...

That won't be enough. At one time a DELETE.INDEX has failed to complete, which is why you're seeing what you're seeing. To get back to a clean, no-index situation: delete the I_... directories associated with your hashed file execute the UniVerse command SET.INDEX hashedfile NULL This form of the SE...

True, I had my DataStage context hat on.

Quotes inside quotes can sometimes be detected by counting the quote characters - if the number is odd you've got a problem. Unfortunately if the number is even, you still may have a problem - two problems! If you know how many character string fields there should be (call it N) then there should be...

Welcome aboard! :D This message usually indicates that the column definitions in your job design (in the OCI stage) do not match the data type in the actual columns in the Oracle table. Make sure that they match absolutely. Import the table definition using the OCI plug-in (in Manager use Import > T...

If you Save the column definitions from your jobs to the Repository, Usage Analysis should be able to report on them.

The message queue format specifies four pipe-delimited fields. The data contain more than four pipe-delimited fields. Message queue format is just like a table definition. It must match the data, otherwise errors or warnings will be generated. Set up a message queue definition that describes ALL the...

This is the kind of stuff that Quality Stage does very well. Check it out.

Get to a TCL prompt (or use the Administrator client Command window). Use SETFILE to create a VOC pointer to the hashed file if necessary. Query the hashed file from here as follows. SELECT Field1, Field2 FROM UNNEST hashedfile ON Field2; Let us know what you get there. This will isolate the cause e...

One recent colleague coined the term "camel case" because of the humps.
I liked it.

Example svDromeDary

The Everyday Happenings of Weebl and Sometimes Weebl's Friend Bob forumbut I mainly go there for the animations

The International UniVerse and UniData User Groupforum also uses PHP BB.

Also GalahTech, a community-based technical support site.