Page 1 of 1
Error while using ExecTCL
Posted: Mon Nov 06, 2006 10:14 am
by 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
Posted: Mon Nov 06, 2006 1:21 pm
by 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.
Posted: Wed Nov 08, 2006 5:06 am
by 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.