Hello All,
So far I implemented the following :
VARA.SQLI.GET_RUNIDS
SELECT AH_Idnr FROM GAED.AH WHERE trunc(AH_Timestamp4) <= to_date('2017-09-13','YYYY-MM-DD');
Note : this SQL statement was made on SQL Server, if you're using Oracle you'll need to convert the timestamp. SCRI.DEACTIVATE_TASKS
:SET &HND# = PREP_PROCESS_VAR(VARA.SQLI.GET_RUNIDS)
:PROCESS &HND#
: SET &RUNID# = GET_PROCESS_LINE(&HND#,1)
: SET &DEACT# = DEACTIVATE_UC_OBJECT(&RUNID#)
: SET &TASKNAME# = GET_STATISTIC_DETAIL(&RUNID#, NAME)
: PRINT Task &TASKNAME# with RunID &RUNID# has been deactivated
:ENDPROCESS
But when i execute the script Ive got bellow error :
U00020274 Wrong SQL statement in 'VARA.SQLI.GET_RUNIDS'. DB error: 'U00003754 Database-error in SQLI-variable: 'U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-00933: SQL command not properly ended''
I had a chat with member of Database team and he confirm that this statement is correct and he is able to execute it.
Would you share your opinion?
I suppose Im doing something wrong but can not find out what.
P.S. Ive tried to run this with and without DB service agent.
Much appreciated.
Krum Ganev