return DB2 SQLCODE

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Return: can only `return' from a function or sourced script

Not sure where the problem is. I can run the script without any issue using the following command. . /opt/app/scripts/cdc_migration.sh But it fails with the below error when I try it this way /opt/app/scripts/cdc_migration.sh /opt/app/scripts/cdc_migration.sh: line 65: return: can only...

2. Shell Programming and Scripting

DB2 in awk

Hi, I want to retrieve the base table name for a table and replace the table with the view name in the file. I was trying to retrieve the base with the below db2 command but i am getting "1" as return value. Could you anyone please assist ? Table_name=system("db2 -x...

3. Shell Programming and Scripting

Return db2 query value to shell script

Hi, Im new to DB2. I need to connect to DB2 from shell script and return the query output back to shell script variable. this is my code #!/bin/ksh db_name=db db_user=usr db_pwd=pwd db2 <<EOSQL connect to $db_name user $db_user using "$db_pwd" select count(1) from table quit EOSQL ...

4. Shell Programming and Scripting

Connect db2 using db2 connect

I want to connect to DB2 database which is mainframes using a unix script and run query and get the result set into the unix box. Is this acheivable using db2 connect? pls help me with a sample script which can perform the same.

5. AIX

DB2 basics

Dear friends I am going to study DB2 and i dont have any experience with any DB's.. Please provide me with some links or pdf's for DB2 starters. any advice will be very usefull

6. Shell Programming and Scripting

db2

i want to run a db2 query though shell script but i want my where condition element to chnage everytime like class_nm='abc' next time class_nm='def' next time i want it to do by passing parameters to unix script can someone give example how can i do it

7. UNIX for Advanced & Expert Users

how to get SQLCODE ?

Suppose I am executing a sql query thru shell script. DB : IBM DB2 If none of the rows are fetched, I will be getting the sql code as 100 If rows > 0 are fetched, I will be getting the sqlcode as 0 Can any one help me how to get this SQL code in unix shell script (in KSH) ...

8. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'...

9. UNIX for Dummies Questions & Answers

to pick up the Return Code ( RC) from the mailx command and return it to SAS uisng 's

Hi All, Can anyone please let me know the syntax / how to pick up the Return Code ( RC) from the mailx command and return it to SAS uisng 'system()' function and '${?}'. I am in a process to send the mail automatically with an attachment to bulk users. I have used 'Mailx' and 'Unencode'...

10. AIX

DB2 Monitoring

Hi everyone. I am currently looking for a monitor to monitor my DB2 UDB database, which runs on AIX 5.3. Does anyone here use any good ones or has anyone heard of any good ones? I especially need to monitor which applications run at any given time, so that I am able to ballance the workload...

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)

Shell Programming and Scripting