DSXchange

bapajju wrote:But I used compile this Sequencer till date and this sequencer used to run everyday. But all of a sudden I got this problem when I tried to compile this.

What's changed? "Nothing" is not the correct answer. Are you using a different/changed PC?

Run a UNIX command (in an Execute Command activity) to determine the latest. For example (your ls may be a little different).

Use the output from this to supply a job parameter with the file name.

Welcome aboard! :D

Alas I don't have version 6 any more, so can't provide a direct answer. You could try searching your on-line help or Server Job Developer's Guide for "proxy mode".

Pre-load a hashed file from Table A. The hashed file contains every possible age - they look like people's ages so there will only be 100 or so rows - and the corresponding code. This should load in well under a second. The rest is a simple lookup based on age. I've assumed here that age is an integ...

This is effected in the same grid where you enter your output link constraint expressions in a Transformer stage. The fourth (rightmost) column in the grid is labelled "Abort After Rows". Put 5 against your rejects link. That's all you have to do to get the job to abort. In its controlling job seque...

... but a cannon can be used to swat a bug, can't it? Seriously, you're trying to use the wrong tool for the job. DataStage is a smart data pump. An ETL tool (extraction, transformation, load). There's no mention of "command" anywhere in there. When you're typing in UNIX commands you're working in a...

Dates can also be strange in Access; depending on the circumstances you may need to surround with "#" characters. For example select * from `Parts_Table` where `Parts_Table`.`Last_Updated` between ##FirstDateOfSample## and ##LastDateOfSample## The inner "#" characters identify a reference to a job p...

When you reset the job, the "from previous run..." event should identify the actual stage in which the problem occurred, even if the original message did not. Did you post the entire error message? It's odd that the message is being reported from DSD.BCIGetInfo. This function is used by ODBC and Uni...

That's correct for DataStage processes, because DataStage is a 32-bit client as far as DB2 is concerned. Environment variables for DataStage processes should be set in the dsenv script. Other client software that you may have may require 64-bit libraries. It's OK to have both in your shared library ...

If your clock stops working, do you remove some component in the hope that that will correct the problem? The RT_... files contain run time information. RT_CONFIGnnn contains the relationships between the various stages/activities, and is re-built each time the job/sequence is compiled. Unless you c...

Stages that connect to persistent storage are properly passive stages; that is, they do not perform any execution. Therefore there is no scope in them to invoke routines. Please advise what you are trying to achieve. It's likely, as Ken suggested, that you can achieve what you want to achieve in an ...

Red Brick should be THE database of choice for star schema designs (data warehouses and data marts) because it was designed from the ground up to do exactly that. By Ralph Kimball, acknowledged as one of the masters of data warehousing theory and practice. Red Brick is not a transactional database. ...

So, what you're asking is for all possible combinations, also known as a Cartesian product. This is achieved simply by naming both tables in your SELECT statement and not providing a join condition. Some databases may require you to enable the use of cross joins, because if table 1 contains 100 rows...

The same Repository is used for all your design-time components, whether they be in server jobs, parallel jobs, mainframe jobs or job sequences, or supporting any of the above (routines, table definitions, and so on). Run-time information for server jobs, parallel jobs and job sequences is also stor...

Where DO the rows go, given that you seem to be implying that they don't go where you expect them to?