Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
sylvan_rydes
Participant
Posts: 47 Joined: Wed Apr 12, 2006 12:13 pm
Post
by sylvan_rydes » Thu Feb 08, 2007 4:33 pm
Hi All,
I have a routine set up such that if a substring from a code is CHAR then it will proceed with the routine and If it is decimal then it will follow some other routine. So I want to know how can I verify that the string has all the values valid for only CHAR within the routine itself and make the decision.
Thanks in advance.
Sylvan
sylvan rydes
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Thu Feb 08, 2007 4:43 pm
Depends on your definition of CHAR. Have you checked the Alpha function?
-craig
"You can never have too many knives" -- Logan Nine Fingers
narasimha
Charter Member
Posts: 1236 Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY
Post
by narasimha » Thu Feb 08, 2007 4:45 pm
You can make use of the Num() function to filter out numeric data and take the rest.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
sylvan_rydes
Participant
Posts: 47 Joined: Wed Apr 12, 2006 12:13 pm
Post
by sylvan_rydes » Thu Feb 08, 2007 5:00 pm
Hi Craig and Narsimha,
Thanks for your reply. Now I can make my way out. Thanks again.
Sylvan
sylvan rydes
I_Server_Whale
Premium Member
Posts: 1255 Joined: Wed Feb 02, 2005 11:54 am
Location: United States of America
Post
by I_Server_Whale » Thu Feb 08, 2007 5:33 pm
You can mark the topic as "resolved".
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Feb 08, 2007 11:35 pm
For something a little more esoteric search the forum for a server routine called IsValid() which allows you to check for particular data types.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.