I am trying to have a sequence.I am write the maximum sequence number from oracle in a sequenctial file.
I am using a execute command to cat this file.this is the message in th elog.
Seq_preapp..JobControl (@Execute_Command_6): Executed: cat /home/cvid/max_seq.txt
Reply=0
Output from command ====>
" 000000000000100."
Now when I try to pass it as a job parameter to a paraell job I am getting the Seq_preapp..JobControl (@Job_Activity_0): Controller problem: Error calling DSSetParam(SEQ_MAX), code=-4
[ParamValue/Limitvalue is not appropriate].
I searched th eforums and I tried various combinations of convert and field but no avail. Trim(Convert(char(254),"",Execute_Command_6.$CommandOutput))