DSXchange

Beware that 2008-12-31 has 86401 seconds!

Welcome aboard. There are more components that you know. DataStage client authenticates via the login/security service of Information Server, with the service being delivered through a WebSphere Application Server. Chances are that these are all installed on your PC. You need to ask someone who is a...

It would assist future searchers were you to explain how to invoke the side-by-side comparison from the results of a search (or whatever other way you succeeded in doing it).

The Dynamic RDBMS stage was introduced when PeopleSoft decided to use DataStage as their preferred ETL tool. PeopleSoft table metadata is the same irrespective of which database is used for it. And therefore, yes, they can switch underlying databases with just the flick of a switch - given that the ...

The file contains only the date. can u pls brief me how it can be done with user variable activity? U is currently working on a server edition site. I don't believe U has ever worked in the enterprise edition environment. The second person personal pronoun in English is spelled "you", not...

Upgrade to version 8 and use a parameter set, which includes the ability to read parameter values from file.

File, yes. Data Set no (Data Set is "internal" to DataStage). File Set, yes. Database table, yes. FTP, yes. And so on.

What is chg_or_num (I assume it's a Hashed File stage with the delete option set)?

No. As well as the Unicode option for the column, you also need to set the NLS map name used to translate from however the data are encoded in the file. This is done in the Sequential File stage, not in the Transformer stage.

Does the file contain just the date, or is there other information also in the file? There is a very recent Webinar (at www.dsxchange.net) on the very topic of processing data in files from job sequences.

Probably not, because U is currently working at a server-only site.

The second person personal pronoun in English is spelled "you", not "u".

For parallel jobs, which use ICU (full 16-bit encoding of Unicode), the map names are different. Try ASCL1252 or some variant thereof. You can find the map names in the Administrator client.

Or you have a bug in the install script, suggested by a null first argument to setFile() function. Please advise your official support provider.

In each job sequence's log there is a "summary of sequence run" event logged near the end. Everything you need is in that entry. Otherwise you can search within the log for "job run requested" events.