DSXchange

Of course there's a 'politically correct solution' for this - license (i.e. buy) the ODBC drivers for use outside of DataStage.

dstechdev wrote:I don't think sorting is the primary issue to the original question.

Maybe yes, maybe no. As you noted, things are still a little... unsettled... yet.

However, the question of sorting came up so it was addressed.

The sort command is slightly different on different platforms. Check man sort to verify what options pertain to your system. For example, a numeric sort may be specified with a -n option rather than suffixing the sort key specification. Which can make a huge difference if you get this wrong. Make s...

I'm curious why something like this would happen. Hello, You are receiving this email because you are watching the topic, "VARIABLE LENGTH VSAM FILES" at DSXchange. This topic has received a reply since your last visit. You can use the following link to view the replies made, no more notifications w...

One caveat. Routines that use COMMON storage can't be used in jobs that have Buffering enabled. At least not reliably used. Plus the fact that while you can use this in the same job to 'pass' values from one Transformer to another, I'm not sure it's valid to say that it would work 'across different ...

I vaguely remember that providing zero for the identity column also triggers it to use an auto-incremented value. Or is that Red Brick? Informix works the same way, from what I vaguely recall, when using its SERIAL field. We would load it with a zero to say "please give me the next available value"...

Actually, just to nit pick: Constraints are one of the odd places where you don't wrapper a job parameter with pound signs. So, the constraint would be @OUTROWNUM < ThresholdParameter And that won't abort anything, just stop any further rows from going down the link. So I take it that the PX version...

I have created a couple jobs to FTP the output from the Transform stage to either our production area or our development area based on an incoming parameter. I was under the impression that the FTP didnt' connect until data went though the link into the FTP Stage. Is there a way to tell the FTP sta...

At 6.x you can't do anything other than a root install. As mentioned, it will ask you where to unpack the cdrom to during the installation. This is the temp space it needs while the install runs. This is not the same as where you intend to install the product. It will prompt for this as well during ...

I added following code in Job Control to asign NAME="rubu". But this routine is giving both the warning messages included in... saying "BAD HANDLE". Why is it happening. Cant I SET parameter of the same job I inside job control? Nope, it's too late at that point. Parameters must be set before the j...

There are no 'files' you need to create in order to install. All you need is the Administrator user setup - which is locked at dsadm in your version from what I recall. Then simply mount the cdrom and start the install. About the only other thing you may need to create if it doesn't exist yet is the...

Never claimed it was a real word Alice.

A quick search of the forums for your error returned quite a number of hints - including this one.

See if it helps.

Just to double-check - are you setting / overriding the CLASSPATH variable in the dsenv file?

Give it a shot - let us know!

Too many variables dependant on your particular system and exactly what you are doing in the job for us to give you a definitive answer.