SQL Issue please respond !!! Post: 302303811

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SQL scripts not running, possible timeout issue?

I am a novice Unix scripter and need a little advice/help on a script I've written that's causing some problems. We are using Solaris 9 on a Sun box and the script is invoked with the korn shell. I have a two-part question: I wrote a shell script that calls and executes 3 separate sql scripts,...

2. Shell Programming and Scripting

KSH script SQL timeout issue

Hi all, I have a KSH script which is kicking off an sql scripts as follows: /usr/local/installs/instantclient_10_2/sqlplus -s username/password @$sql_path/sql_query.sql > $tmp_path/sql_query_results The problem I have is that sometimes the 10g Oracle Database spits out an error saying...

3. Programming

SQL IF-THEN-ELSE issue

Hi All, I have a table with the following columns: sysName, date, time, cpuNum, cpuPercentageBsy There are multiple system names and multiple CPU numbers. I need to produce a report that shows the cpuPercentageBsy for cpuNum's 0 and 1 and then an average of cpuPercentageBsy for all the...

4. Programming

SQL Developer JOINS / GROUP BY issue.

Am having a nightmare with a certain piece of code.. have tried almost everything and just cannot see what the issue is.. CREATE OR REPLACE VIEW TOP_EARNER_PER_LOCATION AS SELECT E.FIRST_NAME || ' ' || E.LAST_NAME AS EMPLOYEE_NAME, L.REGIONAL_GROUP AS REGIONAL_GROUP, ...

5. Shell Programming and Scripting

Issue in SQL Loader scripts

6. Shell Programming and Scripting

Sql issue in shell scripting

HI friends , i am also facing an issue in mysql i ma trying to insert detail in a variable but not got success #!/bin/sh mysql -u<username> -p<password> <dbname> << EOF DEV=`mysql --skip-column-names <dbname> -e "SELECT timestamp from process_record where id = 1"` EOF echo $DEV ERROR...

7. Shell Programming and Scripting

Issue with SQL UNIX shell script -

Hi all I am writing a shell script which will run a select query from a table . If the ouput is not 500 - then send a email to the team saying there is a error . But i am not sure how to redirect this output of the select query to the log file - #!/bin/ksh sqlplus /nolog conect...

8. Shell Programming and Scripting

Issue with quotes when running SQL command from within su -c

RHEL 6.2/Bash shell root user will be executing the below script. It switches to oracle user logs in using sqlplus and tries to run the below UPDATE statement. All the commands after su -c are enclosed in a single quote delimited by semicolon. The execution has failed because the quotes...

9. Shell Programming and Scripting

awk concatenation issue - SQL generation

Greetings Experts, I have an excel file and I am unable to read it directly into awk (contains , " etc); So, I cleansed and copied the data into notepad. I need to generate a script that generates the SQL. Requirement: 1. Filter and select only the data that has the "mapping" as "direct"...

LEARN ABOUT PHP

libipmiconsole

libipmiconsole(3)						  System Commands						 libipmiconsole(3)

NAME

       libipmiconsole - IPMI SOL library

SYNOPSIS

       #include <ipmiconsole.h>

       int ipmiconsole_engine_init(unsigned int thread_count, unsigned int debug_flags);

       int ipmiconsole_engine_submit(ipmiconsole_ctx_t c, Ipmiconsole_callback callback, void *callback_arg);

       int ipmiconsole_engine_submit_block(ipmiconsole_ctx_t c);

       void ipmiconsole_engine_teardown(int cleanup_sol_sessions);

       ipmiconsole_ctx_t  ipmiconsole_ctx_create(char  *hostname,  struct ipmiconsole_ipmi_config *ipmi_config, struct ipmiconsole_protocol_config
       *protocol_config);

       int ipmiconsole_ctx_errnum(ipmiconsole_ctx_t c);

       char *ipmiconsole_ctx_strerror(int errnum);

       ipmiconsole_ctx_status_t ipmiconsole_ctx_status(ipmiconsole_ctx_t c);

       int ipmiconsole_ctx_fd(ipmiconsole_ctx_t c);

       int ipmiconsole_ctx_generate_break(ipmiconsole_ctx_t c);

       int ipmiconsole_ctx_destroy(ipmiconsole_ctx_t c);

DESCRIPTION

       Libipmiconsole implements a high level serial-over-lan (SOL) API for remote console access. It can be used to establish and manage multiple
       IPMI  2.0 SOL sessions. The goal of this library is to abstract away all of the underlying IPMI/SOL details away from the user into a rela-
       tively simple file descriptor interface.

FILES

       /usr/include/ipmiconsole.h

REPORTING BUGS

       Report bugs to <freeipmi-users@gnu.org> or <freeipmi-devel@gnu.org>.

COPYRIGHT

       Copyright (C) 2007-2012 Lawrence Livermore National Security, LLC.
       Copyright (C) 2006-2007 The Regents of the University of California.

       This library is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as  published	by
       the Free Software Foundation; either version 3 of the License, or (at your option) any later version.

SEE ALSO

       ipmiconsole(8)

       http://www.gnu.org/software/freeipmi/

libipmiconsole 1.1.5						    2012-06-15							 libipmiconsole(3)