Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
cieron,
Your need for a special character (wildcard) is not clear.
If you are looking for words that start with WA, you would use 1,2,CH,EQ,C'WA'. If you are looking for words that start with WAR, you would use 1,3,CH,EQ,C'WAR'. What would 1,10,CH,EQ,C'WA???????' do that 1,2,CH,EQ,C'WA' wouldn't do? 1,10,CH,EQ,C'WA????????' would get you WA* so it would include WAR* just like 1,2,CH,EQ,C'WA' would.
If you really can't use 1,2,CH,EQ,C'WA', then you need to explain more clearly in what situations it wouldn't work and how the wildcard would help.
I've got input dataset and I have specified symnames describing fields in this file.
Other process generates dataset with INCLUDE COND clause. This dataset comes to my sort from outside mainframe environment. People whose implementing this process are not familiar with mainframes. They do not want keep file record format description in their system, but they must prepare conditions. I'm helping them.
I want they prepare only "logical" conditions because record format is specified in symnames.
For example:
INCLUDE COND(BALANCE,GT,+1000,AND,CITY,SS,EQ,C'WA')
But they must have possibility to prepare condition: field is starting from pattern string (for example 'WA')
INCLUDE COND(CITY,EQ,C'WA********')
Maybe it is other way, thay can give me information about filter conditions?
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
DFSORT does NOT have a wildcard capability like C'WA********'.
Are you saying that CITY will have a specific length (like 10) that you can't change, so you need to adapt the constant to that length? That doesn't seem like a good strategy. If they want to use 'WA' as the start of the constant, why can't they generate another symbol with a length of 2 that they can use in the INCLUDE statement:
Code:
CITY,1,10,CH
CITYCD,=,2,=
so they can use:
Code:
INCLUDE COND=(CITYCD,EQ,C'WA')
At any rate, since I don't know the details of what these "people" are doing/expecting and what you are doing/expecting, I can't offer much help.
Quote:
Maybe it is other way, thay can give me information about filter conditions?
If you're asking a question here, I don't understand what you're asking.