DSXchange

Because that's the limit its author imposed.

Perhaps no-one has an answer.

DateFromDaysSince() is another way.

Have your system administrator unlock the xmeta account.

Install on the local machine, not over the network.

Show us the rest of the warning. From what you've given I am guessing that you have a sequence job that includes an Execute Command activity that executes - directly or indirectly - a script called /bcpsetenv.ksh. The root directory is a very unusual place to store scripts. Did you mean to have ./bc...

Note: the following WILL NOT WORK if the hashed file was created by a UniVerse stage or using a CREATE TABLE statement. cp -ipr HashedFileName targetdirectory ; cp -ip D_HashedFileName targetdirectory If the hashed file has any indexes, things get a bit more complex - it's probably easier to build t...

Use the Num() function in constraint expressions. Num() returns true if its argument is a valid numeric form, or false otherwise. In your case it is the comma that renders it non-numeric. You can convert to numeric form using Iconv() function with "MD2" as the second argument, or by trimmi...

IBM do offer a class (DX437) on Information Server administration, which includes some DataStage administration. You really can not administer just DataStage any more.

Welcome aboard. There is nothing in the thread so far to indicate that consulting (the nick chosen by the original poster) ever did get it working. However, the solution is obvious. APT_CONFIG_FILE must contain the pathname of a configuration file that is valid. You can check whether a configuration...

Make sure the Extended property ("Unicode" or "") consistent.

You (or the DBA) needs to have created a row in the table before applying the FOREIGN KEY constraint. It's not a DataStage problem.

EACH lookup stage has option to return multilple row only for one reference link.

Wherever you've switched it on, for example by not compiling jobs in trace mode.

Welcome aboard. How are "duplicates" identified? If there is a key column (or set of columns that you can use as a key), you could write rows into a Hashed File using that key. Then read back out from the Hashed File. The most recent row written for each key value becomes the (unique) surv...