DSXchange

Exactly how did you use the Count() function? I would recommend

yiminghu- this is an excerpt from the AIX sort MAN pages: -u Suppresses all but one line in each set of lines that sort equally according to the sort keys and options. Could you explain how this does not get rid of duplicate records? If you don't believe it, try it. For the original poster, do a "ca...

The startup time isn't as important as the high-performance throughput you are going to get by using a 64-way partitioned database. PX Jobs should be designed to process a lot of data. If you are worried about startup time then perhaps you should be using server jobs instead of PX jobs for those job...

Go to "CheckForFile" and compile it.

I am not sure if this is possible, as the column name in error is not necessarily written into the log file.

The best way is to use a PEEK stage. But there is little sense in looking at the {binary} result of an encode.

You need to include it in an export from the original project first.

Could you perhaps rephrase that question?

Actually, the best stage to drop columns with is the Modify stage, and since the Filter stage won't let you drop columns I suggest that you use the Modify Stage.

The question is similar to asking "what is better, a Ferrari or a Chevy Van?". Both product versions have particular strengths and weaknesses and their relative merits are very dependant upon what you want to do with them.

How much data is being prcessed and if you do a "reset" what do you see in the entry for "from previous run...."

I'm not going to go into the other questions but will address (3). A Compiler is generally considered to be a program which translates text written in a human-type language into a series of instructions (object code) that can then be loaded and then executed directly by a machine. In the case of UV/...

The same reason as in the original poster's case - your routine, in this case "CheckForFile" isn't loaded in this project.

Sometimes other application installs can overwrite libraries on the client with older or invalid versions. Try de-installing and then re-installing the client on that particular PC

There are two basic approaches you can use, both will achieve the same thing but one uses a DS/BASIC routine which involves programming and the other uses the command line "dsjob" executable options to generate text output, which you can then process either in scripts or DataStage jobs to load your ...