DB2 basics Post: 302399601

8 More Discussions You Might Find Interesting

1. IP Networking

SAN basics

Hi I like to learn and practice SAN, iSCSI. Could you sugges the appropriate tutorial and small tasks to practice SAN. Thankyou

2. UNIX for Dummies Questions & Answers

basics - if condition (contains)

Can any body help me on how to check whether a file contains a required extension or not. pseudo is: if (filename contains .jpg || filename contains .gif) --- do some thing end if Example file names: test1.grm.gtrx.drx.jpg test.de.mi.jpg test2.ds.gif test3.gif thanks in advance

3. 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'...

4. Shell Programming and Scripting

Scripts and basics

Hi, I have a script which I need to modify the date "01/10/2008" and "31/10/2008" every month before running the report. Can I have some script to take the date automatically from the cal option. Hope it makes sense. Thanks in advance.

5. UNIX for Dummies Questions & Answers

awk basics

Hi, Please tell me where can I get started with awk..like the basics and the whole awk stuff. Regards, Deepti

6. AIX

AIX Basics

Hello , Everyone , I want to know the Aix Basics and how it works ,hardware related problems and solution etc.

7. Shell Programming and Scripting

ls command basics???

how do i use the ls command with a single argument to list all files whose names end with the letter 'r'?

8. UNIX for Dummies Questions & Answers

help me with basics

hello everyone i have to start with unix as it is a part of my training programme and i have to do a self study, i dont know where to start from. i need some basic questions to be answerd like why we use unix ? what is a terminal? what is an editor? why we write commands inside terminal? these...

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)