how to limit a column in transfer?

Toly_xiang · Post by **Toly_xiang** » Tue Jun 03, 2003 8:11 pm

The datastage server version is 5.2.2 ang on AIX
I have a column like idno , I want to limit idno between 4764501 and
4764589, and also include 4773401.
and how to?
use hashed file stage or constraints? and how to?[:)]

kduke · Post by **kduke** » Tue Jun 03, 2003 8:38 pm

Toly

That is what constraints are for. They are designed to limit what gets sent to the target.

Thanks Kim.

Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com

vmcburney · Post by **vmcburney** » Tue Jun 03, 2003 9:07 pm

Two places to apply a filter. As Kim mentions the transformer constraint will let you add a filter to stop rows going through. The other option is putting a filter on a database source stage (if your source is a database table and not a flat file).

When you define your database table name and column list you should see an option in there for a where clause. Use this where clause to add "idno between 4764501 and 4764589 or idno = 4773401" or "(idno >= 4764501 and idno

ray.wurlod · Post by **ray.wurlod** » Wed Jun 04, 2003 5:14 pm

To clarify what Vincent said, because I realise that English is not your first language, there are two possibilities.

If the data are being extracted from a database table, then you can use the Selection tab (which builds a WHERE clause in the SQL), for example:
IDNO BETWEEN (4764501 and 4764589) OR IDNO = 4773401

If the data are being read from a text file or other streaming source (such as FTP), then you put a constraint expression on the output link of a Transformer stage. For example:
(link.IDNO >= 4764501 And link.IDNO