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_odbc-dsn

PDO_ODBC-DSN(3) 							 1							   PDO_ODBC-DSN(3)

PDO_ODBC DSN - Connecting to ODBC or DB2 databases

	The PDO_ODBC Data Source Name (DSN) is composed of the following elements:

	      o DSN prefix
		-  The	DSN  prefix is odbc:. If you are connecting to a database cataloged in the ODBC driver manager or the DB2 catalog, you can
		append the cataloged name of the database to the DSN.

	      o DSN
		- The name of the database as cataloged in the ODBC driver manager or the DB2 catalog. Alternately, you  can  provide  a  complete
		ODBC connection string to connect to a database as described at http://www.connectionstrings.com/.

	      o UID  -	The  name  of the user for the connection. If you specify the user name in the DSN, PDO ignores the value of the user name
		argument in the PDO constructor.

	      o PWD - The password of the user for the connection. If you specify the password in the DSN, PDO ignores the value of  the  password
		argument in the PDO constructor.

       Example #1

	      PDO_ODBC DSN example (ODBC driver manager)

	       The following example shows a PDO_ODBC DSN for connecting to an ODBC database cataloged as testdb in the ODBC driver manager:

	      odbc:testdb

       Example #2

	      PDO_ODBC DSN example (IBM DB2 uncataloged connection)

	       The following example shows a PDO_ODBC DSN for connecting to an IBM DB2 database named SAMPLE using the full ODBC DSN syntax:

	      odbc:DRIVER={IBM DB2 ODBC DRIVER};HOSTNAME=localhost;PORT=50000;DATABASE=SAMPLE;PROTOCOL=TCPIP;UID=db2inst1;PWD=ibmdb2;

       Example #3

	      PDO_ODBC DSN example (Microsoft Access uncataloged connection)

	       The  following  example	shows a PDO_ODBC DSN for connecting to a Microsoft Access database stored at C:db.mdb using the full ODBC
	      DSN syntax:

	      odbc:Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\db.mdb;Uid=Admin

PHP Documentation Group 													   PDO_ODBC-DSN(3)

Shell Programming and Scripting