how to declare VarChar datatype in IsValid function.

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
pavankatra
Participant
Posts: 86
Joined: Wed Mar 03, 2010 3:09 am

how to declare VarChar datatype in IsValid function.

Post by pavankatra »

Hi,
i am using this function in stagvariable.
IsValid("varchar", StgVar10thChar)

it is throwing error like "invalid type:varchar"

StgVar10thChar may be contains number or charecter.

so could anyone please help me how to declare VarChar datatype in IsValid function.

Thanks in Advance.

Thanks
Pavan Kumar
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Use string

Code: Select all

IsValid("string", StgVar10thChar) 
You are the creator of your destiny - Swami Vivekananda
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

So... what would you consider an 'invalid' varchar?
-craig

"You can never have too many knives" -- Logan Nine Fingers
pavankatra
Participant
Posts: 86
Joined: Wed Mar 03, 2010 3:09 am

Post by pavankatra »

anbu wrote:Use string

Code: Select all

IsValid("string", StgVar10thChar) 
Thanks for your rapid reply.It is working.
Thanks alot

Thanks
Pavan kuamr
Kryt0n
Participant
Posts: 584
Joined: Wed Jun 22, 2005 7:28 pm

Post by Kryt0n »

chulett wrote:So... what would you consider an 'invalid' varchar?
That would have been my question... they seem to have done a good job in ignoring your pointers in a number of posts
Post Reply