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
-
samba
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 62
- Joined: Wed Dec 07, 2005 11:44 am
Post
by samba »
i have routine that routine is generating two columns
i need to get where columnname = starting with "link...."
how to get particular rows
can any one please help me
samba
-
DSguru2B
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 6854
- Joined: Wed Feb 09, 2005 3:44 pm
- Location: Houston, TX
Post
by DSguru2B »
you can use the following in the sql
Code: Select all
where LEFT(columnname,4) = 'link'
or
where columnname like 'link%'
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
samba
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 62
- Joined: Wed Dec 07, 2005 11:44 am
Post
by samba »
i have the data in flat file not in DB
samba
-
samba
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 62
- Joined: Wed Dec 07, 2005 11:44 am
Post
by samba »
i have the data in flat file not in DB
samba
-
DSguru2B
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 6854
- Joined: Wed Feb 09, 2005 3:44 pm
- Location: Houston, TX
Post
by DSguru2B »
if px has matches, search the forum for Matches, that will get you your solution.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
kris007
- Charter Member
![Charter Member Charter Member](./images/ranks/charter_member%s.gif)
- Posts: 1102
- Joined: Tue Jan 24, 2006 5:38 pm
- Location: Riverside, RI
Post
by kris007 »
I think even LEFT function works out good, even if your data is in flatfile.
Just a thought.
-
samba
- Premium Member
![Premium Member Premium Member](./images/ranks/premium.gif)
- Posts: 62
- Joined: Wed Dec 07, 2005 11:44 am
Post
by samba »
Yes its working
Thanks
samba