can i pass DB2 command from an application program

mubashir.surury · New User Joined: 29 Sep 2005 Posts: 23 Location: Pune

hello folks,

can i pass DB2 commands (not SQL queries) from my COBOL application. such as to know status of a tablespace. i.e. whether it is locked or not;and what is the system response in that case.

senthilssg · New User Joined: 09 Dec 2005 Posts: 64 Location: USA

Hi friend,

As per my knowledge , you cant execute the db2 commands in the cobol program .

Where DB2 commands are entered

You can enter commands from the following sources:

An MVS console or MVS application program
An IMS terminal or program
A CICS terminal
A TSO terminal
An APF-authorized program
An IFI application program

Regards,
Senthil

correct me if i'am wrong

ofer71 · Posted: Thu Jan 19, 2006 2:23 pm

Sure you can, and IBM supplies a special interface for that: IFI.

O.

ofer71 · Posted: Thu Jan 19, 2006 2:28 pm

Another method is to invoke TSO from within COBOL (see example), and using the DSN subcommand.

O.