Convert string to numeric value
Posted: Wed Apr 01, 2009 8:37 am
Hi All,
Using execute command activity stage in datastage, i reading a text file which contain the record count. The out put this stage is being treated as string in DataStage while text file contains no only.
Is there any function in DataStage to convert string to numeric value.
For exp- my text contains count as 5000.
I am reading this 5000 using execute command activity (cat Unix command) as passing it as parameter in job to a numeric variable.
At that time job is throwing error as ->
"Loop final value not numeric" (cat: count.txt) I am passing out put of UNIX command Cat count.txt where the file count.txt contains the count no.
Thanks in advance
Santosh
Using execute command activity stage in datastage, i reading a text file which contain the record count. The out put this stage is being treated as string in DataStage while text file contains no only.
Is there any function in DataStage to convert string to numeric value.
For exp- my text contains count as 5000.
I am reading this 5000 using execute command activity (cat Unix command) as passing it as parameter in job to a numeric variable.
At that time job is throwing error as ->
"Loop final value not numeric" (cat: count.txt) I am passing out put of UNIX command Cat count.txt where the file count.txt contains the count no.
Thanks in advance
Santosh