DSXchange

Date of the first of the month can be obtained using DateFromDaysSince() or DateOffsetByDays(), using MonthDayFromDate() as the offset argument. Date of the last day of the previous month can be obtained using DateFromDaysSince() or DateOffsetByDays() using (MonthDayFromDate() + 1) as the offset arg...

jerome_rajan wrote:Server Jobs aren't an option in my project. Is there a way to achieve it in my parallel job?

BASIC Transformer stage.

Sorry, that's a local modification here. You can use IsValidDecimal() in the same way.

01 FILLER PIC 9(5) VALUE 50000.

$ $DSHOME/bin/dssh "BLOCK.TERM 50000" 555555555555 00000000 00000000 00000000 00000000 555555555555 0000000000 0000000000 0000000000 0000000000 5555 0000 00 0000 00 0000 00 0000 00 55555555555 00 00 00 00 00 00 00 00 00 00 00 00 555555555555 00 00 00 00 00 00 00 00 00 00 00 00 5555 00 00 ...

There is no solution involving the Field() function.

dsnk wrote:Its really difficult to select each column manually.

No it's not. Be vigilant.

<Apostrophe Man>
It's "it's" when it's "it is", and it's "its" any other time.
</Apostrophe Man>

Server jobs (and BASIC Transformer stages) give you access to the MONTH.LAST and MONTH.FIRST transforms (as well as a host of others). That might also be a nice solution.

Nothing. That's the point. Read the error message again - there must be nothing in the login process that puts unexpected output onto stdout.

What is the umask setting for db2inst1?

Have you involved your official support provider?

The easiest way is to query the system tables (or "catalog" in some databases) in which the tables reside.

Did you modify the .profile file for any of these users, or the /etc/profile file?

Please post YOUR stage variable derivations.

In particular derivation expressions must NOT contain assignment statements.

Not only compilers but also byte-order are likely to be different (I'm assuming your UNIX is not Intel-based here). As a general rule binary code compiled on one platform simply won't work on another.

Create them as job parameters and pass these.

Please answer my other questions too, particularly the one about WAS. It's beginning to look like they've done something with the xmeta user/password (or maybe, coincidentally, that password has expired).