Home > IT Answers > AS/400 > test value of list in AS/400
Qwerty54
5 pts.
0
Q:
test value of list in AS/400
AS/400 Query, AS/400 Records
What is the definition of the test value list?
ASKED: Jun 29 2009  7:35 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Philpl1jb
24105 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Please clarify your question.
tks
Phil

-------------------
The LIST 'Test' can be used in selecting record in Query/400

Field Test Value (Field, Numb
MYFIELD LIST 'A' 'B' 'C'

In this example if MYFIELD contained an A or B or C the record would be selected.

This is like the IN clause in SQL.

NLIST is like the NOT IN CLAUSE.

Phil
Last Answered: Jun 29 2009  9:31 PM GMT by Philpl1jb   24105 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0