DSXchange

First suggestion is always to search the forums for your error, more than likely you're not the first person to have the problem. For you, see if an exact search for "Error calling subroutine: DSR_EXECJOB (Action=5)" turns up anything helpful.

That function is only valid for character data, for those (I assume) packed fields you just need to 'unpack' them. Or are they not packed? Also, have you tried the CFF stage?

If where it lives is in your PATH you can launch it from anywhere. Otherwise, fully path the command: $DSHOME/bin/dsjob from anywhere.

The Administrator client connects to the server. Why not just give it a try?

Right, you'd have to be logged in as "dsadm" to make the change and then bounce DataStage for the change to take effect.

The Inactivity Timeout setting is on the General tab of the Administrator, it's not an environment variable.

Did you try what I suggested?

It would help to state when/where you get this message.

The Pivot stage does a "horizontal" pivot, i.e. columns to rows so unsure why you would think it is not working or that it goes the other way. Can you post examples of your input data and what your pivoted output data should look like? Perhaps there's just a terminology issue at work here....

Use the Pivot stage.

Don't see why not. [shrug] You might want to check again, I've had IBM peoples tell me some pretty good whoppers in the past.

There is no UNIX client, it is Windows only.

The current run's information is stored in one of the "RT_" tables with the job itself. And the information is in the job's log, provided it hasn't been purged. Use the API to retrieve the data: Most recent DSGetJobInfo DSGetStageInfo DSGetLinkInfo Historical DSGetLogEntry DSGetLogSummary ...

The "GUI" is the client software you install on your Windows PC and use to connect to the Server, which can be installed on either Windows or UNIX. There is no Server GUI.

kandyshandy wrote:How do you have 8.0.1 and 8.1 on the same environment? It is not possible at all !!

They're just talking about the client software and for multiple versions of that all you should need to do is install them to different directories. And use the MCM to switch between them.