DSXchange

No, you will need to adapt it. Your number is in seconds, the function expects an argument in days. (There are, in general, 86400 seconds in a day, so a simple division will suffice.)

Is this the only table that contains a date/time/timestamp column? Does the problem happen every run, or only once?

Create a server routine that can wait for *.* or timeout, and use a Routine activity rather than a Wait For File activity.

In that case what are the permissions on /dir1/Ascential/DataStage/DSEngine/dstmp and what user ID are you using when you start DataStage?

Write jobs that don't abort and therefore don't need to dump memory images.

If the data are coming from a database table, you can include an ORDER BY clause in the extraction SQL. If the data are coming from a file you can use an operating system level sort utility to sort that file - you can do that in a before-job subroutine as mentioned or in a Filter command to the Sequ...

Check the input properties of the transformers, there is option of partitioning, in that there is option of sort 1. Stable :- This is for previously sorted datasets.. 2. Uniq :- This will retain only first record if there are duplicates on the sorting key values. hope this helps ----------------- M...

... which is what dsjob -ljobs does.

The advantage of dsjob in this case is that you can create a script to loop through the list of project names on the server.

To get a count, simply pipe the output into a wc -l command.

Resolve the symbol referencing errors. Somewhere in your code exists at least one symbol for which no entrypoint can be found in any of the referenced objects/libraries.

You can not call Transforms from Routines. You must mimic their definition expression instead.

Check in the SDK transforms/routines for those that deal with 1970-based dates.

Learn about Parameter Sets, which can read values from named files, and simply edit the named file ("values file"). You did not mention which Parameters page you are describing, but I will assume it's the one in the job properties dialog. You need to edit the cell (double click or right cl...

Export jobs from the old project using the Export menu in Manager clients to export "DataStage Components". Make sure you have everything you need in that dialog - you may need to use multiple passes appending to the file, if you want to export more than one but not all jobs in a category....

I think only the word "manual" was missing. Have removed premium status from message.

I had assumed that NLS_LANG was OK because you could access Japanese data in other tables satisfactorily. You did not mention DB2 in your original question, so I assume that DB2CODEPAGE relates to your common metadata repository (XMETA) and its associated services or that your IA database (IADB) is ...