10-15-2010
DB2 has both ESQL C++ and C++ libraries, or you can pipe in or out of a command line tool with popen() or system(). JDBC works great, too, no cost for libraries, if your affinity to C++ is shakable. You might need your designated IBM/DB2 guy and the DB2 licence code to use a login to get free libraries for your client online. You might get your own IBM login -- might need the e-nod of a registered user for your account. Might not:
http://www-01.ibm.com/support/docvie...id=swg21254867
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I have written a script that transfers(FTP) files from Unix system to MVS system.
Below is the code for it.
ftp -inv $HOST<<ftp_test
quote site LRECL=200
quote site BLKSIZE=28000
mput SOURCE DEST
ftp_test
Here I need the help, if the above code can get... (3 Replies)
Discussion started by: rinku11
3 Replies
2. AIX
Hello,
can any one help me to debug the following command.
db2 -stec +pc ;
Regards,
SM (2 Replies)
Discussion started by: smolgara
2 Replies
3. UNIX for Dummies Questions & Answers
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'... (0 Replies)
Discussion started by: Sujatha Gowda
0 Replies
4. Programming
Hi ,
We are migrating our database from DB2 z/os to DB2 UDB on UNIX.
and cobol on mainframes to AIX cobol on UNIX.
We have some cobol Db2 programs that are accessing different Databases
how do we code such type of programs in AIX cobol.
Do we need to Establish connection for accessing... (0 Replies)
Discussion started by: nal.satish
0 Replies
5. AIX
Dear friends. can anybody suggest me what to be considered in order to achieve maximum performance of AIX on which DB2 will be installed
Thanks is advance :) (1 Reply)
Discussion started by: Vit0_Corleone
1 Replies
6. Solaris
Hi everyone,
I am hoping anyone of you could help me in this weird problem we have in 1 of our Solaris 10 servers. Lately, we have been having some ftp problems in this server. Though it can ping any server within the network, it seems that it can only ftp to a select few. For most servers, the... (4 Replies)
Discussion started by: labdakos
4 Replies
7. Emergency UNIX and Linux Support
Dear all,
I was given the ID_DSA.pub by an MVS user, which I placed in the appropriate user's authorized_keys file. When the user tris to SFTP from their side to the AIX box, the following error is got:
error: debug1: SSH2_MSG_KEX_DH_GEX_INIT sent
debug1: expecting SSH2_MSG_KEX_DH_GEX_REPLY ... (6 Replies)
Discussion started by: ggayathri
6 Replies
8. UNIX for Dummies Questions & Answers
AIX & DB2 paging issues
Hello I needs some help on AIX & DB2 paging issues. Recently a db2 query caused paging issues which then lead to memory problems and a server restart. Is there anyway of finding out what db2 queries were causing the problem..
Thanks in advance (2 Replies)
Discussion started by: nedkao
2 Replies
9. AIX
Hello Team,
I would need your help to enable communication over TLS1.2 on AIX 7.1 or 7.2 with IBM JDK 1.8 latest update.
By default, the request is trying to establish a connection over TLSv1 even though TLS 1.2 is explicitly enabled on server as well as on Java 8. The openssl command throws... (4 Replies)
Discussion started by: Naina2019
4 Replies
10. AIX
Hi all,
In my system, I have HMC 7 with Power Machine 6 & 7. On the managed system, we have many lpars.
In some lpars, I can see they are using virtual fiber channel to connect to DS8K storage. In search with google, I understand that it is configured with VIOS server to share the physical FC... (7 Replies)
Discussion started by: Phat
7 Replies
LEARN ABOUT PHP
pdostatement.errorinfo
PDOSTATEMENT.ERRORINFO(3) 1 PDOSTATEMENT.ERRORINFO(3)
PDOStatement::errorInfo - Fetch extended error information associated with the last operation on the statement handle
SYNOPSIS
public array PDOStatement::errorInfo (void )
DESCRIPTION
RETURN VALUES
PDOStatement.errorInfo(3) returns an array of error information about the last operation performed by this statement handle. The array con-
sists of the following fields:
+--------+---------------------------------------------------+
|Element | |
| | |
| | Information |
| | |
+--------+---------------------------------------------------+
| 0 | |
| | |
| | SQLSTATE error code (a five characters alphanu- |
| | meric identifier defined in the ANSI SQL stan- |
| | dard). |
| | |
| 1 | |
| | |
| | Driver specific error code. |
| | |
| 2 | |
| | |
| | Driver specific error message. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
Displaying errorInfo() fields for a PDO_ODBC connection to a DB2 database
<?php
/* Provoke an error -- the BONES table does not exist */
$sth = $dbh->prepare('SELECT skull FROM bones');
$sth->execute();
echo "
PDOStatement::errorInfo():
";
$arr = $sth->errorInfo();
print_r($arr);
?>
The above example will output:
PDOStatement::errorInfo():
Array
(
[0] => 42S02
[1] => -204
[2] => [IBM][CLI Driver][DB2/LINUX] SQL0204N "DANIELS.BONES" is an undefined name. SQLSTATE=42704
)
SEE ALSO
PDO.errorCode(3), PDO.errorInfo(3), PDOStatement.errorCode(3).
PHP Documentation Group PDOSTATEMENT.ERRORINFO(3)