10-22-2006
ya, as ghostdog74 said,
it would be very easier to have the statements printed and to make it sure, execute the statement in your test with samples prior to statements being prepared,
would be helpful many a times to avoid any crash..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Is it possible to track the progress of a job (informatica) by analysing the progress of it's log file ? I have a long running job, and no way of tracking how far allong it is. Thanks. (4 Replies)
Discussion started by: cosmos328is
4 Replies
2. HP-UX
Hi,
Is there any way to find the mode of the binary file (debug or release) by analyzing the core file generated by that binary on the HPUX11i Platform? (5 Replies)
Discussion started by: Prajakta
5 Replies
3. Shell Programming and Scripting
Hi all,
while trying to debug and figure out why a lofiadm command was not working on my script, i came across a cmd called "truss"
all i know about it is that it executes the specified command and produces a trace of the system calls it performs, the signals it receives, and the machine faults... (5 Replies)
Discussion started by: wrapster
5 Replies
4. UNIX for Dummies Questions & Answers
I'm not sure if this query is relevant to this forum but here goes anyways...
I want analyse log files that do not appear to be of standard format. I have tried using Analog but cannot config it to read the files.
Does anyone have any advice on working with log files taken from a Unix... (6 Replies)
Discussion started by: Sepia
6 Replies
5. Shell Programming and Scripting
i have to gather some info about a process and redirect it to a1.txt file. For this i m using truss command
truss -po a1.txt $PID_Detail
where $PID_Detail= 1482944 3362976
--------------------------------------------------------------------------
Below the script:
#!/bin/ksh
for i... (6 Replies)
Discussion started by: ali560045
6 Replies
6. Solaris
Friends
I was trying to analyse a core dump using pstack command in Sol5.9(Sparc)
The output is as below.
root: pstack core_mumux211_istauth_220_108_1229517198_21922
core 'core_mumux211_istauth_220_108_1229517198_21922' of 21922: istauth
fe1afbb8 ttcdrv (c10e0, c1db4, 30ad8, bc950, 0, 0)... (1 Reply)
Discussion started by: efunds
1 Replies
7. Shell Programming and Scripting
Hello,
I have a list of e-mails. I need to know, which email-s from that list not use. I want to do this things:
- take email address from email list
- find this address in mail logs
- if, there is no record about this e-mail adress in list, show this e-mail address on screen
I did... (0 Replies)
Discussion started by: naezdnik
0 Replies
8. Shell Programming and Scripting
Hi,
I have below type of data in a text file in unix.
Emp_Name Emp_Dept
Raj 101
Amruta 100
Shilpa 100
Rohit 123
Amol 198
Rosh 101
Gaurav 198
Number of employees can be even more.
Need a command or a... (2 Replies)
Discussion started by: rajneesh_kapoor
2 Replies
9. AIX
Dear Experts,
Am using nmon analyser version 3.3g, and when i tried analyzing my current nmon file it was done successfully. But the problem is all my old nmon files are compressed. So i uncompressed and analyzed using the same analyzer. but got this error
no valid input data! nmon run may... (8 Replies)
Discussion started by: jayadeava
8 Replies
10. Shell Programming and Scripting
Attached is the log file that I have generated through the following script:
last | head -2 |sed '2q;d' |awk '{ print $1"\t"$2"\t"$3"\t\t"$4"\t"$5"\t"$6"\t"$7"\t"$8"\t" $9"\t"$10"\t"$11}'>>/var/log/logadmin/logtest.txt
But now I'm unable to run the following operations on it:
1. Count... (1 Reply)
Discussion started by: Lionking93
1 Replies
LEARN ABOUT REDHAT
execute
EXECUTE(7) SQL Commands EXECUTE(7)
NAME
EXECUTE - execute a prepared query
SYNOPSIS
EXECUTE plan_name [ (parameter [, ...] ) ]
INPUTS
plan_name
The name of the prepared query to execute.
parameter
The actual value of a parameter to the prepared query. This must be an expression yielding a value of a type compatible with the
data-type specified for this parameter position in the PREPARE statement that created the prepared query.
DESCRIPTION
EXECUTE is used to execute a previously prepared query. Since prepared queries only exist for the duration of a session, the prepared query
must have been created by a PREPARE statement executed earlier in the current session.
If the PREPARE statement that created the query specified some parameters, a compatible set of parameters must be passed to the EXECUTE
statement, or else an error is raised. Note that (unlike functions) prepared queries are not overloaded based on the type or number of
their parameters: the name of a prepared query must be unique within a database session.
For more information on the creation and usage of prepared queries, see PREPARE [prepare(7)].
COMPATIBILITY
SQL92
SQL92 includes an EXECUTE statement, but it is only for use in embedded SQL clients. The EXECUTE statement implemented by PostgreSQL also
uses a somewhat different syntax.
SQL - Language Statements 2002-11-22 EXECUTE(7)