comparing two alpha numeric strings?

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

Post Reply
mallikharjuna
Participant
Posts: 81
Joined: Thu Nov 30, 2006 7:46 am
Location: india

comparing two alpha numeric strings?

Post by mallikharjuna »

Hi All,

How to compare two alpha numeric strings,it may include '/' and other special characters also,any function exist for this?

Thanks
Malli
MALLI
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

Sure, try "String1=String2" :)

String comparisons are commonly used in DS, so unless you narrow down your question you won't get more than a generic answer.
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

Use = or <> or # or NE, but if the values are numbers but need to be compared as strings (00012345 = 12345 numerically but not by string) then use COMPARE(x,y,'L'). Check your DS BASIC manual for more details on COMPARE.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Post Reply