DSXchange

Yeah, it figured you're using the DB2 ODBC drivers. Methinks there's a history of that not working right, but don't quote me on it. It might be that the rejected row wasn't being caught or captured to the reject file. The reject button is all that's necessary. If the rejects are properly being sent ...

What's the target database and stage? If it's ODBC or Oracle, DS 4 was good about using the Reject check box constraint in the transformer to capture all database rejects. Make sure this is checked.

As for your "DBMSCODE>0" method, I know it was flaky on a lot of the stages back then.

You must be bored to death. You could, if you so desire, "image" a project and copy the necessaries from one project to another at the OS level, or even at the TCL level. It's still Universe for the most part under the covers. You seem savvy enough, I'm sure given a little time you'll figure it all ...

The row is unavailable as a variable, only as columns. You may consider writing your columns to a sequential text file with a delimiter of "_". You then could read the file back using a single column as metadata and take it from there. Or, write your columns to a hash file, and then use a function t...

Why can't they insert? Is it because of unique key violation? Then why don't you do a lookup during transformation to see if the key is already in the table and if so either send it for update or ignore the row. If it's because the data doesnt' conform to the data types, then you should check each c...

The job aborts because either you have a limit on the number of warning messages at runtime or you have an Abort After N Rows value on the reject link (but release 4 didn't have that feature, are you sure you're on version 4???) So, I'm guessing your issue is the reject from the database exceeds you...

There is no way and still have DS recognize the account as a valid project. The security mechanisms built into the tool disallow a project from being created by anything but the Administrator client or the install program. This is because of some of the internal files that are encrypted are pretty m...

Try it with supplying the server, userid and password options.

For those folks who choose not to install Server jobs, they are giving up both Batch and Sequence style jobs. They are also giving up the ability to develop Server functionality on the Server side because the Server features are more functional and stable, and then encapsulating that in a shared con...

Either a permissions issue or it's your PC and its client. If you're logged in as dsadm, you shouldn't have any issues. As an individual user I can understand variances. Having different users in different groups, with different permissions on files and directories can cause weird effects. Sometimes...

Take a look here for good start in writing your own functions:

http://www.dsxchange.com/viewtopic.php?t=85788

There is no max function. Your question confuses me because I'm assuming you understand how to use DataStage. Maybe I need to state the obvious, but rows stream to the transformer stage. To get the max of anything, you either: 1. Use the aggregator to GROUP by certain columns and derive other column...

ketfos wrote:select max(date_column) from table_name

Okay, so I probably guessed wrong with the "history" word. Most people use history to mean that the table tracks multiple copies of the same row over time (time-variant). Sometimes maybe I'm thinking too hard.

Your question is quite unclear. Are you asking how to get the most current row for a series of rows that have a common natural key? Are you asking for SQL, job design help, what? To get the most current row, how do you identify it? You could use SQL like the following to dump the most current row fr...

And most of our answers don't end with:

You need to wait for the next version...

Or

You need to upgrade to PX...

Or

You need to get some help from Professional Services...

We help get it done now, rather than later, if ever.