Acceessing DB2 UDB in AIX COBOL on unix

10 More Discussions You Might Find Interesting

1. Programming

UNIX commad in COBOL

Hi guys, i used the call "sytem" using ... in a cobol program. At the moment i stoped at an empasse, how cam I retrive the execution's result of unix command? Explenation, I made an 'pwd' command, and I must to have the directory inside the program. How can have this result?

2. Shell Programming and Scripting

Unix Korn Shell script on Solaris to DB2 UDB LUW database

I am rather new to korn shell scripting and attempting to write a Unix script that would detach, attach a range partition table in DB2 UDB LUW database. This would be a job scheduled in control M that reads in an input file with 5 parameters passed to it from the application. I don't have much...

3. AIX

Urgent!! Debugging tool for cobol in AIX

hi folks, I am a new to Aix, i worked as sys admin so no idea about software probs, my software team requires Debugging tool for cobol in AIX machine. can someone tell me the tool and also the installation procedure for the same Please drag me out from this soon :confused:

4. AIX

Ibm db2 udb

Am trying to export the content of Stored Procedure to a file using GET ROUTINE command. After executing the command first few lines of the file contains ASCII characters though i have original text following that. Any help is appreciated.

5. Shell Programming and Scripting

Calling script from RM cobol and returning value to cobol

Is there a way you can return a value from a script that is called from a rm cobol program... 01 WS-COMD-LINE-PGM X(39) value sh ./getUserId.sh 12345" 01 WS-RETURN-SYS-CODE PIC 9(8). CALL "SYSTEM" USING WS-COMD-LINE-PGM GIVING WS-RETURN-SYS-CODE. ...

6. Programming

Seg Fault Running AIX COBOL program

Hi some help read............ I'm getting a segmentation fault when I run an AIX COBOL/Db2 program. I initiate the program from the command line, but it hangs, and then when I press enter it generates a segmantation fault and produces a core dump. The box is running AIX software level ...

7. AIX

UDB 9.5 upgrade from 8.2 on AIX 5.3

We are going from UDB DPF 8.2 to 9.5 and changing HW from P4+ to P6 and moving from 5.2 to 5.3. Anyone out there gone through this upgrade? Any words of wisdom, warnings, or other gotchas you could pass on. TIA. ART

8. AIX

IBM DB2 UDB to SQL Server 2005 Porting

Hi All, Am porting my application from AIX to Windows. As a part of this I need to port the Database in IBM DB2 UDB to SQL Server 2005. Is there any Guide/Doc/Article available on this? How to convert the stored procedures and physical data from DB2 to SQL Server 2005? Thanks in Advance

9. Programming

cobol crn programme run on express cobol as .gnt

can i run .crn programme in express cobol which support to .gnt programme .... Plz tell me solution

10. UNIX for Dummies Questions & Answers

Cobol On Unix

Hi , Could anyone please tell me about the whole procedure for compiling, linking the cobol program on unix platform. As i am mainframe guy and very new to unix, any help will be very appriciated, Regards, -Vinit

LEARN ABOUT PHP

pdo_ibm-dsn

PDO_IBM-DSN(3)								 1							    PDO_IBM-DSN(3)

PDO_IBM DSN - Connecting to IBM databases

	The PDO_IBM Data Source Name (DSN) is based on the IBM CLI DSN. The major components of the PDO_IBM DSN are:

	      o DSN prefix
		- The DSN prefix is ibm:.

	      o DSN
		- The DSN can be any of the following:

		     o a) Data source setup using
		       db2cli.ini or odbc.ini

		     o b) Catalogued database name i.e. database alias in the DB2 client catalog

		     o c) Complete connection string in the following format: DRIVER={IBM DB2 ODBC DRIVER};DATABASE=
		       database;HOSTNAME=  hostname;PORT= port;PROTOCOL=TCPIP;UID= username;PWD= password; where the parameters represent the fol-
		       lowing values:

			    o $database
			      - The name of the database.

			    o $hostname
			      - The hostname or IP address of the database server.

			    o $port
			      - The TCP/IP port on which the database is listening for requests.

			    o $username
			      - The username with which you are connecting to the database.

			    o $password
			      - The password with which you are connecting to the database.

       Example #1

	      PDO_IBM DSN example using db2cli.ini

	       The following example shows a PDO_IBM DSN for connecting to an DB2 database cataloged as DB2_9 in db2cli.ini:

	      $db = new PDO("ibm:DSN=DB2_9", "", "");

	      [DB2_9]
	      Database=testdb
	      Protocol=tcpip
	      Hostname=11.22.33.444
	      Servicename=56789

       Example #2

	      PDO_IBM DSN example using a connection string

	       The following example shows a PDO_IBM DSN for connecting to an DB2 database named testdb using the DB2 CLI connection  string  syn-
	      tax.

	      $db = new PDO("ibm:DRIVER={IBM DB2 ODBC DRIVER};DATABASE=testdb;" .
		"HOSTNAME=11.22.33.444;PORT=56789;PROTOCOL=TCPIP;", "testuser", "tespass");

PHP Documentation Group 													    PDO_IBM-DSN(3)

Programming