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!!!
Read only integer value records from a table.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 126
- Joined: Thu Jul 01, 2010 11:39 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use Matches operator in a constraint expression.
If you might need signed integers, extend the pattern.
Code: Select all
InLink.TheValue Matches "1N0N"
Code: Select all
InLink.TheValue Matches "1N0N" : @VM : "'-'1N0N" : @VM : "'+'1N0N"
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.