DSXchange

So what do you want to see? More to the point, what is DB2 expecting? 2 is interpreted as 00:00:02 in time context which, when converted to internal format, is 2 seconds after midnight. 258 is interpreted as 00:02:58 in time contect which, when converted to internal format, is 178 seconds after midn...

Much of such a book has been written. Ascential placed too many legal obstacles in the path of its publication.

The Maximum() function that Cameron referred to is to find the largest element in a dynamic array. It is not suited to the requested purpose of finding the maximum value in a column over N rows.

I'd prefer to grab it from source if that were possible, using MAX(colname) in SQL.

The dscmdexport command is issued on the client, not on the server.

You also need to make some decision about how to handle NULL if it is possible that one may occur. Basically, you have to omit any NULL from the calculation.

Let the log purge finish. Yes, it can take a long time. I've just waited almost an hour to purge 6 million events (though the system was heavily loaded at the time). Even if you kill processes (definitely a last resort), that doesn't release the locks that they hold. Indeed, using kill -9 doesn't gi...

Here we're having no problem with NUMBER(38) in the Dynamic Relational Stage with access method set to "Oracle" (which uses OCI software). Datatage 7.1, in case anyone's interested.

Nice catch. I couldn't see the dot because of the tiny font (would you believe)?

I doubt that it's really hanging, I suspect that you're being too impatient waiting for the millions of records in the log to be sorted for presentation! You can view the log using SQL and will get quick but meaningless report. It's meaningless because it's not sorted in time order. To get a meaning...

It suggests that the Run method of the CoSort stage could not be found, probably because it had not been registered. I believe you need to re-install the CoSort stage after upgrading to version 7, so that the method functions can be re-registered. Run is the only one for normal operation, but there ...

Quite simply the only reliable way to do this is to have the DataStage job record when it writes is some persistent store - a table of some kind that can be updated is best. The next run can interrogate this previous date.

... but definitely do-able. The fourth field is the one between the third and fourth occurrence of the delimiter. You need two Index() functions. TheString[Index(TheString,"v.",3)+1,Index(TheString,"v.",4)-1] This is not a complete solution, as it does not handle ...

If you can "math the range" down to a constant for each possible range, then you can look up this constant as the key value in the hashed file.

If you can't, then you can't.

Contemplate how you might build the math, and therefore how you might populate the hashed file.

Welcome aboard! :D There IS some setting up to do. Add database-specific environment variable settings to the dsenv script in the DataStage Engine directory. If you want ODBC access, you will also need to edit the .odbc.ini file, and the uvodbc.config file in the project from which access is require...

The group dsadm is nothing special for DataStage. Only the user dsadm has any special meaning. The new user needs to belong to a group that has write permission to appropriate objects in the project, and to some in the DataStage Engine (UV) account, such as DS_LICENSE. In general DataStage users nee...