DSXchange

Are you certain that this is a TX question? There is insufficent information to make any recommendations at all. 50 Million records with a key and one column is quite different from 50 million rows with 100 columns. Just reading & writing the columns could be complex (partitioning, key distribut...

Try executing your compile command from the command line directly to see if that works, cxx -O -IC:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c C:/Ascential/DataStage/Projects/AC/RT_BP1.O/V0S1_TEST_TFM_Transformer_1.C -o C:/Ascential/DataStage/Projects/AC/RT_BP1.O/V...

Another approach is to use a database sequence directly, or use the new V8 sequence functionality in Transform stages

Perhaps DataStage can; but I don't know what format or application "EV4" files are. Could you expand on that?

Both MSQuery and DataStage will use the same ODBC connection. You need to define the system DSN in windows (which you probably have already done) then use that ODBC identifier when calling up MSQuery. If it works, then chances are very high that DataStage will work as well; if it doesn't work, then ...

An error has occurred within the external SQL loader, if I recall correctly the error message itself will point to a file on disk which, in turn, contains the detailed error message(s) which caused the job to abort.

Craig has already asked you to define "month" in your context. For example, are 61 days 3 months or just 2 or does it depend upon which months?

Could you say something about the jobs that are taking a long time to start? How many nodes (and does startup time change if you add/remove nodes) and how many processes get started?

Use MSQuery to get connectivity established. Once that works, DataStage connectivity should work as well.

Maria, the PX record rejection mechanism uses a reject link from the DB stage itself, not the from a preceding transform stage. If you draw the output link and activate reject handling in the stage itself, you should be getting reject records in raw format along with SQL error codes passed down that...

What is your error message? Can you access the Excel sheets with your system DSN using another ODBC connectivity tool such as MSQuery?

Are you sure that, during installation, you gave the appropriate answers and licensing information in your keyfile to get this installed?

The warning are there for a reason (although in today's systems with much more memory some are a bit conservatively set) and should not be trifled with. For the same reason, it is impossible to just give tuning suggestions without knowing exactly what the problem is; this is somewhat akin to going t...

At Version 8.x just having the UniVerse/DataStage engine running is not sufficient, you have the WAS components to consider as well. Can you enter into the control panel?

I would go and remove all traces of any clients first. That includes going into the registry (I can't recall offhand which keys they are, probably "Vmark" or "Ascential" keyword searchs would work - and a "search" here probably would as well). Then make sure your user h...