i m arsalan mf cobol programmer and i want to connect my cobol application with oracle database how could i do

Answer 1

ARSALAN MS will this help

Your Pro*COBOL program must log on to Oracle before querying or manipulating data. To log on, you use the CONNECT statement, as in

EXEC SQL
CONNECT :USERNAME IDENTIFIED BY :PASSWD
END-EXEC.

where USERNAME and PASSWD are PIC X(n) or PIC X(n) VARYING host variables. Alternatively, you can use the statement

EXEC SQL
CONNECT :USR-PWD
END-EXEC.

where the host variable USR-PWD contains your username and password separated by a slash (/).

The syntax for the CONNECT statement has an optional ALTER AUTHORIZATION clause. The syntax for CONNECT is shown here:

EXEC SQL
CONNECT { :user IDENTIFIED BY :oldpswd | :usr_psw }
[[AT { dbname | :host_variable }] USING :connect_string ]
[ {ALTER AUTHORIZATION :newpswd | IN {SYSDBA | SYSOPER} MODE} ]
END-EXEC.