I-descriptor was not compiled error
Posted: Wed Jan 13, 2010 7:54 am
Hi,
The requirement is that for all control log entries success/failure/aborted/reset I need the MSG.ARGS populated with jobname.inovationid if multi-instance job else jobname. Currently for every aborted entry MSG.ARGS is empty.
Below query works for me to get the jobname.invocationid from the RT_LOGXX file when job is aborted but the same when used in if condition throws me I-descriptor was not compiled error.
Working:
$DSHOME/bin/uv "SELECT SUBSTRING(MSG.TEXT FROM 5 FOR (CHAR_LENGTH(MSG.TEXT)-13)) FROM RT_LOG21 WHERE TYPE=5;"
Not Working:
$DSHOME/bin/uv "SELECT EVAL \"IF MSG.ARGS='' THEN SUBSTRING(MSG.TEXT FROM 5 FOR (CHAR_LENGTH(MSG.TEXT)-13)) ELSE MSG.ARGS\" FROM RT_LOG19 WHERE TYPE=5;"
IF MSG.ARGS = THEN Unidentified type "SUBSTRING".
SUBSTRING syntax error
I-descriptor "IF MSG.ARGS='' THEN SUBSTRING(MSG.TEXT FROM 5 FOR (CHAR_LENGTH(MSG.TEXT)-13)) ELSE MSG.ARGS" was not compiled.
The requirement is that for all control log entries success/failure/aborted/reset I need the MSG.ARGS populated with jobname.inovationid if multi-instance job else jobname. Currently for every aborted entry MSG.ARGS is empty.
Below query works for me to get the jobname.invocationid from the RT_LOGXX file when job is aborted but the same when used in if condition throws me I-descriptor was not compiled error.
Working:
$DSHOME/bin/uv "SELECT SUBSTRING(MSG.TEXT FROM 5 FOR (CHAR_LENGTH(MSG.TEXT)-13)) FROM RT_LOG21 WHERE TYPE=5;"
Not Working:
$DSHOME/bin/uv "SELECT EVAL \"IF MSG.ARGS='' THEN SUBSTRING(MSG.TEXT FROM 5 FOR (CHAR_LENGTH(MSG.TEXT)-13)) ELSE MSG.ARGS\" FROM RT_LOG19 WHERE TYPE=5;"
IF MSG.ARGS = THEN Unidentified type "SUBSTRING".
SUBSTRING syntax error
I-descriptor "IF MSG.ARGS='' THEN SUBSTRING(MSG.TEXT FROM 5 FOR (CHAR_LENGTH(MSG.TEXT)-13)) ELSE MSG.ARGS" was not compiled.