View previous topic :: View next topic
|
Author |
Message |
sree reddy
New User
Joined: 20 Jul 2007 Posts: 27 Location: bangalore
|
|
|
|
REORG TABLESPACE Database.tablespace
Code: |
CopyDDN(copylp)
SHRlevel change
statistics table(all)
index(all
keycard freqval numcols 1 count 30
freqval numcols 2 count 30
freqval numcols 3 count 30
freqval numcols 4 count 30
freqval numcols 5 count 30
)
REPORT(NO) UPDATE(ALL)
MAPPINGTABLE database.table
MAXRO 30
DELAY 1200
LONGLOG CONTINUE
DRAIN_WAIT 30
TIMEOUT TERM
DEADLINE CURRENT TIMESTAMP + 45 minutes
DISCARD
from table database.table
when
(
X_VAL = 12345
and abc_VAL not in
(
'AbcdEFG'
,'SEDOL'
,'CUSIP'
,'primaryexchange'
,'tickerK'
)
) |
Code'd
I ran this utility and this did not work as expected, it deleted all the records satisfying X_val = 12345 and it ignored abc_VAL not in
Could any one suggest me the solution as early as possible
Thanks |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Why do you refuse to use the "Code" tag? It takes very little time to learn and there is the Preview so you can see your post as the forum will see it. When you have the "look" you want, Submit.
Future posts without the Code tag for code, jcl, data, screen info, etc will be deleted if i see them. . .
d |
|
Back to top |
|
|
wanderer
Active User
Joined: 05 Feb 2007 Posts: 199 Location: Sri Lanka
|
|
|
|
Did you check the case of those characters you are passing and whats really in table? And when you run that JCL that they pass as caps off? |
|
Back to top |
|
|
|