It seems there is a syntax error in your document. There is no trailing } after the document.get(). This assumes, of course, that you pasted the xml into the message.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I need to use document parameters in my sqlScript. I tried several formats, but nothing works.
Any suggestions?
Thx,
Frank
<stage-inst>
<stage-name>CheckLastImport</stage-name>
<stage-desc>Checks database for last update</stage-desc>
<stage-type>SqlEnrich</stage-type>
<option>
<option-name>sqlScript</option-name>
<option-value/>
<sub-option>
<option-name>CHKLSTIMPORT</option-name>
<option-value>select '1' as CHKLSTIMPORT from GEP_PARAMETER where GPA_LAST_UPDATE > ${document.get("TIMESTAMP")</option-value>
</sub-option>
</option>>
<option>
<option-name>resourceName</option-name>
<option-value>gemdb</option-value>
</option>
</stage-inst>
$document.get("TIMESTAMP") should do it.
Are you sure that TIMESTAMP is set before you get to this stage? Look in the log.
Sherman
It seems there is a syntax error in your document. There is no trailing } after the document.get(). This assumes, of course, that you pasted the xml into the message.