DSXchange

Out of curiosity, what is the error you get?

Use the Pythagorean theorem to calculate a simple distance yourself. distance = square root of ( (x1 - x2)^2 + (y1 - y2)^2 ) where x and y values are your longitude and latitude decimal numbers. It may help to use AsFloat() around each x and y value, such as if they are strings vs. decimals. Then se...

Maybe it's just not showing correctly, but your DSN on the first line is normally surrounded by square brackets. I have run into errors with DSNs that are over 8 characters long. You might try making it shorter, but if that were the problem here, then I would expect a different error message. Have y...

It sounds like you want to change the user registry. See if this Security Setup link helps.

http://www-01.ibm.com/support/knowledge ... rview.html

Gotta love those long java errors...

They are described in the location Mike indicated, and under the Logical functions section.

BitAnd(), BitCompress(), BitExpand(), BitOr(), BitXOr(), Not(), SetBit()

I would think you need to use the BitAnd() function.

"Working as designed."

Correct! :D

I prefer the command line that PaulVL suggested because it's easier and faster.

Another way would be to use Director, View menu, do not Show Folders, and the job count appears in the status bar at the bottom of Director.

I would confirm what ShaneMuir reported. Go with option 3. And if you are talking about loading a lot of data, then also look for a bulk load option. These are faster than insert statements but only if your database support them.

That sounds odd. So, you're not using DataStage Designer at all?

We were able to read DBF files, by copying them to our server (UNIX) and using ODBC. We did not encounter any errors like you have described. I also think you need to contact Support, assuming your organization has a Support contract, that is what it's there for, might as well use it...

Request you to join.

Fix packs are released quarterly or less often. Various products in the suite also have rollup patches release monthly, or whenever they feel like it... You can download these from the IBM Support Fix Central site (search for it). For example, IGC 11.3.1.1 currently has rollup patch "RU13"...

It's not likely a supported operating system, or a supported version of DataStage, which would mean you are inviting problems. Try the install on Windows XP.