03-18-2017
getting error message could not SQLexecute
getting error message could not SQLexecute.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Dear all
I want to execute some isql command from unix shell script. Kindly suggest me. isql command mention below.
isql -U -P
use gdb_1
go
select count (*) from table_x
go (3 Replies)
Discussion started by: jaydeep_sadaria
3 Replies
2. Shell Programming and Scripting
Hello,
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
1 Replies
3. Solaris
After dumping data from an Oracle database running on Solaris into a flat file, we need to run bcp and isql for MS SQL Server on the same Solaris box. Does Microsoft provide some tools that run on Unix?
Thanks for your assistance. (2 Replies)
Discussion started by: tomstone_98
2 Replies
4. Shell Programming and Scripting
hi all,
how to execute shell script in another server that contain sql script. i tried using "ssh -l" option.. but i am unable to load the environment variable of the remote host.
please suggest how execute the shell script contain sql part inside it. (2 Replies)
Discussion started by: sandeep909
2 Replies
5. Shell Programming and Scripting
I have an Employee with EID, ENAME and ESTATUS as columns in SQL.
I want to extract the status of an employee and update the details if the status is 'A'.
Can anyone help in writing the shell script. (1 Reply)
Discussion started by: vkca
1 Replies
6. Shell Programming and Scripting
Hi all,
I need to connect to SQL server from shell script. Then need to execute queries from shell script. Kindly let me know on how to do this
Thanks,
Ananthi.U (1 Reply)
Discussion started by: ananthi_ku
1 Replies
7. Shell Programming and Scripting
Hello all,
I am very new to unix.
I am working on a DB upgrade. The requirement is to get count of all the tables in the database before and after upgrade and compare them.
I found the below query to find the counts of all the tables:
nawk -v v="'" '{ print("select " v ":" $1":" v... (2 Replies)
Discussion started by: vkrisaak
2 Replies
8. Shell Programming and Scripting
i have a Oracle table like
col1 col2
---- -----
a 1
b 2
c 3
when i write a script for it , it gives me all the data in one column.
Please give me the solution which gives the exact result like we see in sql editors.
for a in `echo "
set feedback off;
set pagesize 40;... (1 Reply)
Discussion started by: ss135r
1 Replies
9. Shell Programming and Scripting
I need to extract the data from oracle table and written the below code.
But it is not working.There is some problem with the query and output is shown is No rows selected" . If I run the same query from sql developer there is my required output.
And if I run the shell script with simple sql... (7 Replies)
Discussion started by: giridhar276
7 Replies
10. Homework & Coursework Questions
Hi,
I'm new to Linux. I'm working on a database, and need to load data in a database table (which I already created) using shell script.
The table has two columns - Acct_number (not nullable) and date (timestamp).
I'm not able to write a shell script for that. Can any one help me?
... (3 Replies)
Discussion started by: saisudeep
3 Replies
LEARN ABOUT HPUX
xterrorhandler
XtErrorHandler() XtErrorHandler()
Name
XtErrorHandler - interface definition for low-level error and warning handler procedures.
Synopsis
typedef void (*XtErrorHandler)(String);
String message;
Inputs
message Specifies the error message.
Description
An XtErrorHandler is registered as an error or warning handler with XtAppSetErrorHandler() or XtAppSetWarningHandler(). It is invoked by
XtAppError() or XtAppError(). The error handler should display the specified string in some appropriate fashion. Some applications may
wish to log errors to a file as well. Error handlers should exit; warning handlers should return.
See XtErrorMsgHandler(2) for a description of the high-level error and warning handler procedure.
Example
The Intrinsics default error and warning handlers are shown below. The XTERROR_PREFIX and XTWARNING_PREFIX symbols are by default the
empty string in the MIT implementation, but may be configured when the Intrinsics are compiled.
void _XtDefaultError(message)
String message;
{
extern void exit();
(void)fprintf(stderr, "%sError: %s0, XTERROR_PREFIX, message);
exit(1);
}
void _XtDefaultWarning(message)
String message;
{
if (message && *message)
(void)fprintf(stderr, "%sWarning: %s0, XTWARNING_PREFIX, message);
return;
}
See Also
XtAppError(1), XtAppSetErrorHandler(1), XtAppSetWarningHandler(1), XtAppWarning(1),
XtErrorMsgHandler(1).
Xt - Error Handling XtErrorHandler()