Hi!
We have an Oracle db export that was compressed and written to DLT tape directly!- This is from box1
The next step is to restore the contents of the tape into the database on box2. The problem is that there is no DLT tape drive attached to box2. There is a box3 that has the tape drive... (1 Reply)
Hi All
I am new to unix.
I need a shell script to load a datafile in to oracle.
I already have a control file, and data file. all I need is if i execute the shell it must load the data using the ctl file to table.
Control file : PAY0001.ctl
Datafile : mon_grs_det.dat
log file :... (3 Replies)
Hi,
How to fetch data from oracle database in unix shell scripting.
list=`sqlplus -s ds_user/dsuser@EMI <<EOF
set feedback off
set serveroutput on
set heading off
set pagesize 0
set tab off
select IP_ID from table
/
exit
EOF`
The output is not what i expected.I need output in... (4 Replies)
Hi,
I want to write a shell script which will export data from oracle table .
I don't want to save that data . I want the queries .
Right now i am right clicking on the table and clicking on export as to my desktop .
Please let me know if any one have any idea . (2 Replies)
Hello everyone,
I am new to shell scripting/ loading data into a database.
I want to load data into Oracle database using SQL loader. Can some one please explain why do we need unix shell script to load the data into the database? Also can someone please explain what has to be in that script?... (5 Replies)
Hi ,
I have a scenario, i have a directory where i receive around 14-15 files at a interval of 20-40 min not fixed, i want to write a unix scripts which invoke sqlldr command to load files into oracle automatically as soon as the file hit the directory.
Any help will be appreciated.
... (4 Replies)
Hello All,
I'm using my Ubuntu 10.04 client connected via SSH to a SuSE Linux server (SuSE Linux Enterprise Server 11 (x86_64) version 11 patchlevel=1).
I'm trying to run an install of WebSphere Portal but can't seem to be able to run the GUI installer.
Running xclock as root returns this... (7 Replies)
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies
LEARN ABOUT PHP
db2_conn_errormsg
DB2_CONN_ERRORMSG(3) 1 DB2_CONN_ERRORMSG(3)db2_conn_errormsg - Returns the last connection error message and SQLCODE valueSYNOPSIS
string db2_conn_errormsg ([resource $connection])
DESCRIPTION db2_conn_errormsg(3) returns an error message and SQLCODE value representing the reason the last database connection attempt failed. As
db2_connect(3) returns FALSE in the event of a failed connection attempt, do not pass any parameters to db2_conn_errormsg(3) to retrieve
the associated error message and SQLCODE value.
If, however, the connection was successful but becomes invalid over time, you can pass the $connection parameter to retrieve the associ-
ated error message and SQLCODE value for a specific connection.
PARAMETERS
o $connection
- A connection resource associated with a connection that initially succeeded, but which over time became invalid.
RETURN VALUES
Returns a string containing the error message and SQLCODE value resulting from a failed connection attempt. If there is no error associ-
ated with the last connection attempt, db2_conn_errormsg(3) returns an empty string.
EXAMPLES
Example #1
Retrieving the error message returned by a failed connection attempt
The following example demonstrates how to return an error message and SQLCODE value after deliberately passing invalid parameters
to db2_connect(3).
<?php
$conn = db2_connect('badname', 'baduser', 'badpassword');
if (!$conn) {
print db2_conn_errormsg();
}
?>
The above example will output:
[IBM][CLI Driver] SQL1013N The database alias name
or database name "BADNAME" could not be found. SQLSTATE=42705
SQLCODE=-1013
SEE ALSO db2_conn_error(3), db2_connect(3), db2_stmt_error(3), db2_stmt_errormsg(3).
PHP Documentation Group DB2_CONN_ERRORMSG(3)