Error while using ExecTCL

[rameshrr3]

Whilw updating a hashed file using ExecTCL , in an after job subroutine , i get the following error

Code: Select all

AfterJob (ExecTCL): Error when executing command: UPDATE SOIRecordCountHash SET SOIRecordCount =21
*** Output from UniVerse command was: ***
SQL

How do i suppress the SQL+ prompt? Or is it something that i cannot do while using Universe SQL through a data stage job?

Thanks
Ramesh

[ray.wurlod]

This prompt indicates that your SQL command is incomplete, and it's awaiting more. Append the missing trailing semi-colon to your statement and the prompt will not appear.

[rameshrr3]

Oh Thanks
The command executed succesfully. Never thought on the lines of the semi-colon though. .

Code: Select all

HistoryUpdaterExtract..AfterJob (ExecTCL): Executed command: UPDATE SOIRecordCountHash SET SOIRecordCount = 0 WHERE DUMMY=1;
*** Output from UniVerse command was: ***
DataStage/SQL: 1 record updated.