View previous topic :: View next topic
|
Author |
Message |
Abhushan_s
New User
Joined: 28 Jul 2008 Posts: 34 Location: Ahmedabad
|
|
|
|
Below are 2 sort conditions
INCLUDE COND=(100,5,CH,EQ,C'XXXXX'),
and
INCLUDE COND=(100,5,SS,EQ,C'XXXXX').
Actually CH would mean a character to be checked, so if we give a look to the first statement it looks to be incorrect as we need a string to be checked instead of a character,but we are giving CH in the condition statement, but could anyone tell me what do we mean by 'SS' in place of CH?
Is it the one to check for Strings?? |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
SS is a substring search where you can specify a search parameter which is shorter than the field length to be searched. |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Quote: |
if we give a look to the first statement it looks to be incorrect as we need a string to be checked instead of a characte
|
five characters togather makes string which is to be compared with. So statement is correct.
Quote: |
INCLUDE COND=(100,5,SS,EQ,C'XXXXX').
|
In this case it will behave same as giving CH as you are specifying 100,5 which is length 5 and c'xxxxx' also has lenght 5.
SS is used for substring e.g.
INCLUDE COND=(1,200,SS,EQ,C'XXXXX').
all the records in which XXXXX is appeared anywhere in col 1 to 200 will be included. |
|
Back to top |
|
|
Abhushan_s
New User
Joined: 28 Jul 2008 Posts: 34 Location: Ahmedabad
|
|
|
|
Hey Thanks for the help |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
Back to top |
|
|
|