01-31-2006
Thanks! That explains a lot..
I had a series of SQL's to be submitted within a ksh script(with -e option). If one SQL failed, the script stopped execution.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi.
What does this command do in the shell script?
#!/bin/ksh
I have some scripts which do not run if this line is removed. First I thought it is comment but I think it sets up korn as shell.
Sanjay (2 Replies)
Discussion started by: sanjay_g
2 Replies
2. Shell Programming and Scripting
Hi,
I wrote scripting to perform some jobs. (eg, run_job)
Everything works ok when i tested it on my side.
I execute the run_job manually and it works perfectly ok.
When my administrator try to run it using a scheduler job.
He encountered problem of running it.
He said it might be due to... (1 Reply)
Discussion started by: maldini
1 Replies
3. Tips and Tutorials
Introduction
Originally, we only had one shell on unix. When ran a command, the shell would attempt to invoke one of the exec() system calls on it. It the command was an executable, the exec would succeed and the command would run. If the exec() failed, the shell would not give up, instead it... (3 Replies)
Discussion started by: Perderabo
3 Replies
4. Shell Programming and Scripting
Hi All,
I have a shell (#!/bin/sh) with below piece of code:
if !
then
echo Staging table ABC_INT_TAB is not present in the schema >> $OUTPUT
fi
Shell is throwning below error and continue to work even after this error... (3 Replies)
Discussion started by: bhush782003
3 Replies
5. Shell Programming and Scripting
we have a shell script that we are using in KSH
if ]; then
_IFS=$IFS
IFS=:
and it's failing on /bin/sh . Is there a simple way to modify it to work on both . ( not with awk)
Thanks in adv (3 Replies)
Discussion started by: talashil
3 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have a problem I don't understand with fuser.
I launch a simple shell script mysleep.sh:
I launch the command fuser -fu mysleep.sh but fuser doesn't return anything excepted:
mysleep:
Then I modify my script switching from #!/bin/sh to #!/bin/ksh
I launch the command fuser -fu... (4 Replies)
Discussion started by: Peuj
4 Replies
7. Shell Programming and Scripting
I have started to write Korn scripts on the client's AIX 4.2 servers and there is this small problem that puzzles me.
I code all my scripts the same way:
- first line contains :
#!/bin/ksh
- I do this console command on every scripts:
chmod +x scriptname
But still, on some occasions,... (4 Replies)
Discussion started by: Browser_ice
4 Replies
8. Shell Programming and Scripting
:b:HI Friends,
Can you help me understand -p option with /usr/bin/ksh shell interpreter ?
Thanks,
Panditt (1 Reply)
Discussion started by: deshaipet
1 Replies
9. UNIX for Dummies Questions & Answers
Hi,
In the beginning of Shell script, we give a statement like
#!/bin/ksh
I have 2 questions related to this,
1) It could denote about the shell we want to use, what is the real usage of this? My shell script works even without this statement, is it a mandatory one.
2) I'm using... (7 Replies)
Discussion started by: Dev_Dev
7 Replies
10. Shell Programming and Scripting
I saw one script using the first line as below
/usr/bin/ksh -E
I have used -x for debug but couldn't find what is this -E option for ?
Pls let me know what is this -E used for
Thanks
RL (1 Reply)
Discussion started by: reldb
1 Replies
LEARN ABOUT PHP
ingres_prepare
INGRES_PREPARE(3) 1 INGRES_PREPARE(3)
ingres_prepare - Prepare a query for later execution
SYNOPSIS
mixed ingres_prepare (resource $link, string $query)
DESCRIPTION
Prepares a query for execution by ingres_execute(3).
The query becomes part of the currently open transaction. If there is no open transaction, ingres_query(3) opens a new transaction. To
close the transaction, you can call either ingres_commit(3) to commit the changes made to the database or ingres_rollback(3) to cancel
these changes. When the script ends, any open transaction is rolled back (by calling ingres_rollback(3)). You can also use ingres_autocom-
mit(3) before opening a new transaction to have every SQL query immediately committed.
Note
Related Configurations
See also the ingres.describe, ingres.scrollable and ingres.utf8 directives in Runtime Configuration.
PARAMETERS
o $link
- The connection link identifier
o $query
- A valid SQL query (see the Ingres SQL reference guide) in the Ingres documentation. See the query parameter in ingres_query(3)
for a list of SQL statements which cannot be executed using ingres_prepare(3)
RETURN VALUES
ingres_prepare(3) returns a query result identifier that is used with ingres_execute(3) to execute the query. To see if an error occurred,
use ingres_errno(3), ingres_error(3), or ingres_errsqlstate(3).
SEE ALSO
ingres_unbuffered_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_object(3), ingres_fetch_row(3), ingres_commit(3),
ingres_rollback(3), ingres_autocommit(3), ingres_set_environment(3), ingres_errno(3), ingres_error(3).
PHP Documentation Group INGRES_PREPARE(3)