Page 1 of 1

Read only integer value records from a table.

Posted: Tue Apr 05, 2011 1:35 am
by mac4rfree85
Hi Guys,

I am reading data from SAP table. I need to read only those records which are having numeric value in a paritcular column.

So, i used int(Col name) in the derivation. please guide me if i am correct. Because i am getting an abnormal termination error and the jobs gets failed. So, unable to test the job.

Can somebody point me in a right direction.

Cheers!!!

Posted: Tue Apr 05, 2011 2:28 am
by ray.wurlod
Use Matches operator in a constraint expression.

Code: Select all

InLink.TheValue Matches "1N0N"
If you might need signed integers, extend the pattern.

Code: Select all

InLink.TheValue Matches "1N0N" : @VM : "'-'1N0N" : @VM : "'+'1N0N"

Posted: Tue Apr 05, 2011 6:47 am
by chulett
Reset the aborted job and let us know the contents of any 'From previous run...' log message that shows up.