11-17-2009
How do you load the data? You have provided no information expect that you have a DB2, csv with UTF-8 and possibly an undefined problem.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi, I have a accentuated letter (ö) in a script for an Installer. It's a file name. This is not working and I'm told to try using the octal value for the extended ascii character. Does anyone no how to do this? If I had the word "filförval", can I just put in the value between the letters, like... (9 Replies)
Discussion started by: peli
9 Replies
2. Shell Programming and Scripting
hi..
i am having some 3 files : ka, kb, kc
i want to use these set of files in my script... how can i do that ?
like first it should process "ka" .. then "kb".. then "kc" ...
thanks,
Krips. (3 Replies)
Discussion started by: kripssmart
3 Replies
3. Shell Programming and Scripting
I will be reading a file (file_in) with name & address and a word that I may need to convert. Running unix on a pc, this would be easy. But on my Solaris I am not getting the desired results.
If my file_in contains:
Joe|Smith|123 Main Street|E|Vehicle
Nicky|Dufour|1 Ste. Catherines|F|Vehicle... (1 Reply)
Discussion started by: joeyg
1 Replies
4. Solaris
hi guys,
i have a unix WS ultra45, I installed sol10 after that I found the screen is extended to second screen , any one knows how to disable that ? (4 Replies)
Discussion started by: dagigg
4 Replies
5. Linux
I need some help.
when i use the following command, it deletes all lines containing WINNT& v2010 and WINNT& v2010.2
I just want it to delete lines containing WINNT & v2010 only.
perl -n -i.bak -e 'print unless /WINNT/&&/v2010/' *.*
Danish (2 Replies)
Discussion started by: sdanish110
2 Replies
6. UNIX for Dummies Questions & Answers
Hi,
My files are showing some control characters in vi editor
^M
^@ and somtimes
^H
I removed ^M with %s/^M//g command
but how to represent ^@ and ^H
e.g. for ^M it is hold ctrl then v and m..
Please help..
I am very new to unix.. (7 Replies)
Discussion started by: prabhat.diwaker
7 Replies
7. Shell Programming and Scripting
Hi,
Is there a way to identify the lines in a file having extended ascii characters and display the same?
For instance I have a file abc.txt having below data
aaa|bbb|111|This is first line
aaa|bbb|222|This is secõnd line
aaa|bbb|333|This is third line
aaa|bbb|444|This is foùrth line... (3 Replies)
Discussion started by: decci_7
3 Replies
8. Shell Programming and Scripting
We are getting extended Ascii characters in the input file and my requirement is to search and replace them with a space. I am using the following command
LANG=C sed -e 's// /g'
It is doing a good job, but in some cases it is replacing the extended characters with two spaces. So my input... (12 Replies)
Discussion started by: ysvsr1
12 Replies
9. Programming
Hi,
I want to read extended ASCII characters from keyboard using c language on unix/linux. How to read extended characters from keyboard or by copy-paste in terminal irrespective of locale set in the system. I want to read the input characters from keyboard, store it in an array or some local... (3 Replies)
Discussion started by: sanzee007
3 Replies
10. Shell Programming and Scripting
I am working with a log file that I am trying to clean up by removing non-English ASCII characters. I am using Bash via Cygwin on Windows.
Before I start I set:
export LC_ALL=C
I clean it up by removing all non-English ASCII characters with the following command;
grep -v $''... (4 Replies)
Discussion started by: lewk
4 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)