oracle sequence resued for processing error

efxuser · Post by **efxuser** » Thu Mar 05, 2009 11:04 am

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))

Trim(Field(Execute_Command_6.$CommandOutput,@FM,1))

Any clues please?

girija · Post by **girija** » Thu Mar 05, 2009 11:30 am

When you stored seq number in the sequential file use data type as BigInt instead of decimal.

efxuser · Post by **efxuser** » Thu Mar 05, 2009 12:15 pm

I am using numeric

girija · Post by **girija** » Thu Mar 05, 2009 12:22 pm

Try with bigint and let us know.

girija · Post by **girija** » Thu Mar 05, 2009 12:23 pm

''''''

girija · Post by **girija** » Thu Mar 05, 2009 12:29 pm

According to your output from command it is like "000000100.". Set SeqFile--->Format : Quote as none.

efxuser · Post by **efxuser** » Thu Mar 05, 2009 1:24 pm

Thanks girija very much for your response.
I did both changing datatype to bigint and put quote = none.
now the job works.

appreiate your help.