DSXchange

If "OCONV(ICONV(YourDate,YourDateFormat)+1,'DD')=1" then YourDate is the last day of the month.

Have you set the DataStage library paths? This is usually done in the "dsenv" script in the $DSHOME directory.

The internal date of the last day of the month of February 2008 is ICONV('2008-03-01","D4-YMD[4,2,2]")-1 . You didn't specify if you wanted a full date, a day-of-the-week, a day-number in month or another format as output so I can't suggest any OCONV() function to use, but all...

Hint: Get the first day of the following month in internal format, then subtract one from it to get the last day of the prior month.

Set it as nullable in the upstream stage, just to see. If you "edit row" on the column you can see and change numerous attributes, including how nulls are handled (if at all, in this case they shouldn't be handled). I assume that this link is the reference link in the lookup, not the column in the m...

And the column is declared as nullable and there is not default null value set for that column?

What about the sessions listed in the web client for IIS, that can show a session and hold a lock that might not be visible from the DataStage engine.

Is "look1.COD_GR_EMP_FIC" a key column for the lookup? The result of a TRIM() function (of any type) on a NULL value is always null.

Tej,
in this case it would make more sense for you to act as suggested, check to see if you have write permissions or perhaps if there is no space on the device.

From Unix, go to the project directory and do a "ls -l *113*", which files or directories are listed?

If you search the forum for posts about the "job monitor" you might find some useful pointers into the possible cause.

What do you mean by "no data being processed" - that the jobs run but don't do anything or that the log files contain no entries? (or both)?
I recall having seen a similar problem that ended up being caused by system changes - a restart of DataStage solved the issue that time.

Define another parameter such as "CurrentTime" and, from the calling sequence, pass in a string formatted the way you want. You can use a number of functions or system values to get the date, i.e. TimeDate(), @DATE, @TIME.

I would pre-sort the data before the aggregator stage in DataStage and tell it that the data is already sorted, the job will just fly through the data. If the same data is to be used more than once then sort it into a dataset and use that. The more nodes you sort into and use at runtime, the more th...

In which case it is time to start thinking about writing a eulogy for your dearly departed Datastage directory