DSXchange

Define performance. 500,000 rows is not really many for this kind of test. Try with 5 crore rows and you will begin to see some differences. It is probably also the case that at least one of your stages (Oracle) is operating in sequential mode. Are you using the Oracle enterprise stage? Is the Oracl...

The row count on a sparse lookup link will depend on exactly which key values the job looks up. Presumably, on different runs, you are looking for a different set of key values.

where stage variable svLF is initialized to Char(10) and stage variable svCRLF is initialized to Char(13):Char(10).

kduke wrote:It is well documented perhaps over documented.

Done properly there is no such thing as over-documented, imho.

DataStage is really row-oriented. Perhaps you could re-format the page into a single row (or at least some appropriate chunk between starting and ending tags) then use appropriate techniques (for example lots of Ereplace() invocations in a routine) to substitute tags and the like. Do you have the co...

Because it needs to determine/verify from this table how the partitioning of the table is organized (or, indeed, if there is any).

Do you have an ODBC driver for FoxPro? If so the way forward is clear.

What happened to it? You might also be able to restore it from backup.

When you say "restarting the server" do you mean restarting DataStage or re-booting the operating system? The latter is pretty much guaranteed to work (since locks are held in memory) unless your Repository database(s) have been corrupted.

You can use SQL wildcards (% or _). The ^ character is not an SQL wildcard (based on the SQL CAE Access Group's 1992 standard) so would be interpreted literally.

There is no "compile from the command line" utility in the product.

No idea. Try it from a telnet connection.

As soon as it finds a function of the name for which it is searching it stops looking. That's why you need to have the 32-bit libraries first for DataStage processes, since DataStage (except on a very few platforms) is a 32-bit application.

Take more time. Check with netstat that there are no active connections.

JeroenDmt wrote:This problem occurs in every project though, including projects that have been running without any problem.

What has changed? "Nothing" is not the correct answer.