DSXchange

I am not that experience in BuildOps, I go for routines. But instead of comparing with 89, specify a const float and initialize it with 89. Do your comparison with that variable. Also before you try that, try changing your data type to float and then run your code, unchanged, and see if the error pe...

B-trees or linked lists in C are very powerful datastructures and widely used in the C world. You can explore that possiblity and code your solution in C.

The basic STATUS() command can be used on an open file. The command retrieves a dynamic array with all sorts of info. Fields 15 and 16 is what your interested in. Refer to the Basic Guide for more info.

Now that is something I hardly use. Get to learn something new every time from this website.

From unix cmd, you can only import. And really why dont you have access, me curious ???
These .exe files are at the client end and if you have access to datastage, you have access to these files.

Ray ji recently posted a fancy piece of code to get that info. You could probably run that and get your desired info. Search will help.

Your explanation is vague, or maybe its just me. Can you give some sample data from file1 and file2 ?

There is a readme document that ships with the product. It has a section "Whats new". You will be able to find your answers there.

Whatever sails your boat

I had director instead of administrator. Sorry about that. I fixed my previous post.

kaps wrote:acef 020c

Ray wrote:adef010c indicates 32-bit, adef020c indicates 64-bit.

I don't see any contradiction. Other than the fact that its acef and not adef. The main part to look at is the 010c for 32 bit hashed file and 020c for 64 bit hashed file.

That means that all your hashed files that will be created will be 64 bit hashed files.

No you dont need to if it comes in as char. I was under the impression that it was in integer format.
Lets take a step back. How many filter where clauses do you have. Start with one, see if that works. Add on more conditions later.

Make sure you have the correct qualified name for the database table.

...which is no different then any other application using the client server architecture.