Switch stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
san_dwh
Participant
Posts: 17
Joined: Tue Dec 28, 2010 9:05 am
Location: hyd

Switch stage

Post by san_dwh »

how switch stage differs from sql (may be in functionality)?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Fixed your subject three times now. Please use meaningful and appropriate subjects in the future.
-craig

"You can never have too many knives" -- Logan Nine Fingers
daignault
Premium Member
Premium Member
Posts: 165
Joined: Tue Mar 30, 2004 2:44 pm
Contact:

Post by daignault »

You need to ask a question with more details.

The Switch Stage is a Datastage ETL stage used much like an SQL Where clause. SQL is a database language used to manipulate data.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

The Switch stage is closest to the switch construct in the C programming languages. It is quite unlike anything in SQL. The closest SQL construct is CASE, but even CASE allows for expressions - switch does not, being driven purely by values.

The Filter stage uses SQL-like WHERE clauses.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply