|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
ODBC Hive error
Post 302873261 by rakesh_411 on Tuesday 12th of November 2013 11:21:45 AM
11-12-2013
|
|
6 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Here is part of my program code:
#Collect the output of test database and count the no
#of rows too
while(my @array = $tstDbStatementHandle->fetchrow_array)
{
push @tstDbOutputArray,;
$tstDbOutputRows++;
}
... (3 Replies)
Discussion started by: sameerstephen
3 Replies
2. UNIX and Linux Applications
Hi all,
Please help me solving the error that i get when i trigger the job from autosys. The job is failing after going to restart start and it is throwing an "exit code:128". Please help me understand whats this exit code and how to overcome this. And when i check the logs its giving me an... (4 Replies)
Discussion started by: Bharath V
4 Replies
3. Shell Programming and Scripting
Hi,
When run the script directly...it executes as expected. But when put it in crontab the job fails with this error:
Connection not open
08003: Connection not open
Unable to connect to the database...
how come it is not able to connect when cron job fires?... Do I need to... (7 Replies)
Discussion started by: nuthakki
7 Replies
4. Shell Programming and Scripting
my question (8 Replies)
Discussion started by: sauravrout
8 Replies
5. Shell Programming and Scripting
Hi,
I need to extract only the create table structure with columns alone.
for eg
hive_table
show create table hive_table:
create table hive_table(id number,age number)
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
LOCATION 'hdfs:/path/'
I need only below
... (5 Replies)
Discussion started by: rohit_shinez
5 Replies
6. Programming
Hi Guys,
Is there a way to check hive external tables which are created 90 days before and drop those tables along with underlying hdfs data. Can this be achieved in unix script? (10 Replies)
Discussion started by: Master_Mind
10 Replies
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)