DSXchange

Look in the job log to verify that the job parameters are all being resolved correctly and, indeed, that the correct number of parameter markers (corresponding to the column names on the link) are being supplied. It is in the latter area that the fault most probably lies.

Stick in a Transformer stage with a constraint that does not pass NULL keys to the hashed file.

And it's "hashed" file, by the way, not "hash" file.

Doesn't matter. You have NLS enabled. Oracle reports "three bytes per character" sizing. Go with it - it works.

If you want to you can more closely qualify the data type when creating the table, using one of VARCHAR2(n BYTE) or VARCHAR2(n CHAR).

any suggestions please ! Learn patience. Your two posts were 11:51pm and 3:24am my time. How long does the Oracle query take by itself to complete (not to return the first row)? What is your job design? Are you doing normal lookup or sparse lookup? How many rows are there in the reference data? The...

And Field().

ODBC has its own protocols and rules. The name of the function may be SUBSTRING rather than SUBSTR. You have to use the name that is specified in the ODBC grammar specification.

You did not mention having executed the CLEAN.ACCOUNT command.

VERIFY.SQL

Keep searching.

But one thing you can do is to mark this thread as finished (Resolved). Use the green button at the top of the page.

If "Then" or "Else" is the last word on its line then it opens a block of statements that must be terminated by an End statement. Ans="" Name="ABCD" If (Name Match "0N") Then Ans= Name End Else Ans="" End Return(Ans) or equivalently, Ans="...

It means you have not specified a packed decimal number correctly.

Record the identity of the owner, which is revealed when the "job locked" message box is displayed. Using the Web Console for Information Server choose Session Management and disconnect that particular session, provided that it does not belong to a currently valid user.

Find out from your DB2 documentation what code 1222 means. Then fix that.

Yes, but the question also specified "latest" job entries. So you should have mentioned the other log options of the dsjob command. But if reshmakr researches the command a number of benefits will accrue, including a better learning outcome because of the active learning involved, and the added skil...

No, you have missed one critical point. The restartable job sequence continues to believe that the job in question has aborted (never finished successfully) so will attempt to execute it - and probably succeed if you have fixed the job. The only legal way around this is to reset or re-compile the jo...