DSXchange

Try changing the table to "VOC" and do a view data on it? Do you get the same error message or one stating bad column names?

sanath1234 - explain

i tryed but failed

- what didn't work?

remove the alias, and set your path to read

Try "PATH=$PATH:$DSHOME/bin"

That probably means you the appropriate PATH command isn't in your dsenv. If you do "env | grep PATH" do you see the path added?

Also, the command is ". ./dsenv", otherwise the changes made are discarded.

can the dsadm user read the /etc/services file? If yes, is there an entry for dsrpc in it (should be at the end)

pravin - the alias is a solution to your problem. Or you could add the path to the $DSHOME/bin directory to your PATH environment, that will solve your issue as well. I prefer the latter solution, but both will work.

See Craig's response to your other thread

Since Ray's example might not be visible to you, I suggest you open up the PDF Parallel Job Developer's Guide and read Chapter "The Parallel Engine
Configuration File", perhaps looking at one of the sample multinode files such as the one on page 58-24.

Go to your Manager, open up Tools->Configurations. Activate your current configuration and check it.

Your first fatal error is

Job IBTLoan_Update_Chkpnt_Complete_Job cannot be multiply invoked

That is pretty clear, concise and descriptive to me.

It should work, but I can't test or answer that for you.

If it won't work for (simple) MSQuery then it won't work for (complex) DataStage.

Have you looked in the web or the ODBC documentation to see if this is supported functionality?

I can see and understand the design specs you posted; but I cannot see a question. Are you asking someone to change your specs into finished code?

Did you follow us1aslam1us's suggestion (perhaps adjusting the path if your installation is different)?

us1aslam1us wrote:Your DS engine directory is missing in the path.

Code: Select all

  alias dsjob='dstage/Ascential/DataStage/Engine/bin/dsjob'

Hello and welcome to DSXchange, cipsy.

Your error message indicates a runtime error, but your subject line states that you cannot compile the job.

Which is it?

It might also help to understand the issue if you could explain what stages are used in the job.