my purpose is to
when a user enters both code no and group no the control should pass to another screen
let me clear u about my query their may be subgroups in a code no so i have to validate whether the correct subgroup has been entered to code no,
i need help regarding this query, i had written a query but it seems it doesn't work properly
Joined: 06 Dec 2004 Posts: 211 Location: Keane Inc., Minneapolis USA.
Just clisk on Quick Register and fill the profile details to become a member. No conformation is required. The membership is free to all.
Coming to your query really to say its not clear. But as I understood you have a code lets take person MBNISS split into 3 parts. You want to validate each part before executing the query. If my thoughts are matching with your query please validate the parts of code seperately using COBOL code then only execute in query. Because DB2 resources are costly and if your code contains junk data then your program will get abend.
IF WS-MBNIS1 IS NUMERIC AND WS-MBNIS2 IS NUMERIC AND WS-MBNIS3 IS NUMERIC
-- query --
DISPLAY "ERROR IN MBNISS"
If your que is not same as above please send us your code so that we will understand it properly.