Joined: 12 May 2006 Posts: 41 Topics: 16 Location: Mumbai
Posted: Thu Nov 09, 2006 8:25 am Post subject: Reg IKJEFT1B (TMP)
Hi,
I want to delete a record from the DB using the said uttlity pgm (Terminal Monitor Pgm). I want to know some info especially the things related to the SYSTSIN DD card.
//SYSTSIN DD *
DSN SYSTEM(XPD1)
RUN PROGRAM(DSNTEP2) -
LIB('SYSDB2.RUNLIB.LOAD')
END
//SYSIN DD *
DELETE FROM PSDAT.BU WHERE BU_ID IN (436764, 564254);
COMMIT;
//*
Getting the following err msg.
READY
DSN SYSTEM(XTD1) RUN PROGRAM(DSNTIAUL) LIB('SYSDB2.RUNLIB.LOAD')
IKJ56712I INVALID KEYWORD, RUN
IKJ56712I INVALID KEYWORD, PROGRAM(DSNTIAUL)
IKJ56712I INVALID KEYWORD, LIB('SYSDB2.RUNLIB.LOAD')
READY
END
READY
END _________________ Thanks,
-Srini
Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
Posted: Thu Nov 09, 2006 8:33 am Post subject:
srini_igsi,
Your SYSTSIN shows that you are running DSNTEP2 , but in the error messages it shows that you are trying to run DSNTIAUL. one of them is definetely wrong. Also you are missing the PLAN keyword.
If you are running the DSNTEP2 then your SYSTSIN control cards should be as follows
Code:
//SYSTSIN DD *
DSN SYSTEM(XPD1)
RUN PROGRAM(DSNTEP2) -
PLAN(DSNTEP2) -
LIB('SYSDB2.RUNLIB.LOAD')
END
//*
If you are running DSNTIAUL , then your control cards should be as follows
Code:
//SYSTSIN DD *
DSN SYSTEM(XPD1)
RUN PROGRAM(DSNTIAUL) -
PLAN(DSNTIAUL) -
PARMS('SQL') -
LIB('SYSDB2.RUNLIB.LOAD')
END
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
