DSXchange

Take a look in the SDK Transforms and Routines. There are many of these "multiply by a constant" already supplied with the product. Why re-invent the wheel (and risk getting a triangular rock on a square axle)?

This is not the same as 7.5x2. Check with your vendor or support provider.

From the name I would suspect "DataStage job sequence generator". Remember (or search) that some of the compilation of a job sequence is performed on the client machine.

You also need to change a mindset; DataStage Engine does not provide any resources - it demands them. It is the operating system that must provide the resources. If you are getting code -14 errors either the demand level is too great or the supply level is too small. Basic economics.

There is no way you can say that the Count() function is causing the problem. Element 1 of STAGECOM.ARR contains InLink.TheString (by now a variable named Pin%%V0S1P1.Column%%5); this is moved into register #11 (named $R11) for the Count() function. The value of the stage variable svCRLF (by now a v...

Try running them via the START command (which also allows you to assert their priority).

You do have either a variable or column name called Stamp somewhere in this design. You may have to search for it (as others have suggested).

Is the More button enabled (in the compiler dialog) when this error occurs? Have you clicked More to see precisely what the compiler is complaining about?

Is the string hard-coded then, if so, can you put the entire command in the command field (leaving nothing in the command parameter field)?

Have you tried it without the quotes around the newline (\n)?

What does the log entry tell you is the command being executed?

A new (well, revamped)brief on building a Data Warehouse has just appeared on IBM website.

Unfortunately, no-one in IBM seems to be aware that they own a specialized Data Warehouse database called Red Brick, so offer a DB2-based solution.

This White Paper describes the nested relational model and the technical advantages it has over fully normalized models.

So you expect me to be a SQL Server expert too ?

The ODBC standard (published by Microsoft) is based on the SQL CAE Access Group's SQL standards, and does provide for a TimeStamp data type in the format YYYY-MM-DD HH:MM:SS using a 24-hour clock. This format, in turn, is based on the ISO 8601 standard for date and time representation. If your ODBC ...

Any sufficiently advanced form of technology is indistinguishable from magic (Arthur C. Clarke). In this case it was sufficiently advanced in the late 1960s!

SPINTRIES and SPINSLEEP relate specifically to mutex locks (one way to implement semaphores). No Windows operating system uses mutex locks. It is possible to wait on a semaphore in Windows with a specified timeout (probably hard-coded in DataStage), but this is a "sleep" wait; when the semaphore is ...

Draw an output link, right-click on that link and choose Convert to Reject from the menu.