05-20-2009
Error Checking in Shell scripts.
What i need to do is when the database connection is not successful , the script should move to next list i.e skip the current.
But when i do this -
if [ "$NO" -eq "1" ]; then
break;
fi
The script break but it goes to the condition -
if [ $COUNT -ne 0 ]; then
for LIST in $LISTS
do
for TABLE in $TABLES
do
COUNT=`/usr/local/sybase1251/OCS-12_5/bin/isql -S $LIST-U user -P pass-w 100 <<EON | egrep -v -e '-----------' | egrep -v -e 'affected'
select count(*) from Table
go
EON`
NO=`echo $COUNT | grep "CT-LIBRARY error" | wc -l `
echo $NO
if [ "$NO" -eq "1" ]; then
break;
fi
if [ $COUNT -ne 0 ]; then
#TABLES="$CLIENT $TABLE $COUNT\n"$TABLES
fi
done
done
How can i get this working ?
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
I am using few ISQL statements to update and delete from a few tables in sybase, now i want to roll back the transaction when any of the statements fail.How i can i capture these errors in the shell scripts.Please advise.
Thanks,
Gopi (4 Replies)
Discussion started by: bhgopi
4 Replies
2. AIX
Hi,
Please give me the detailed Differences between writing Unix Shell script and AIX Shell Scripts. Thanks in advance..... (0 Replies)
Discussion started by: haroonec
0 Replies
3. UNIX for Advanced & Expert Users
Hi all
Does the notion of QA make sense when talking about shell script development?
I would like to put in place such a QA procedure to ensure the code we provide is full compliant with certain norms we think are right. I just thought it would be a good idea to ask the community about the... (7 Replies)
Discussion started by: Indalecio
7 Replies
4. Shell Programming and Scripting
Hi Unix experts....
I am in the process checking user and root password of more than 1000 servers manulay.
I am very pissed of checking these many servers manualy.
Could some one of you help me how can i check the passwords just by runing some scripts..!
Need Help Guys..! :confused: (5 Replies)
Discussion started by: bullz26
5 Replies
5. Shell Programming and Scripting
Hi all
I've got a question regarding error handling in shell scripts. My background is mainly object oriented programming languages, but for a year or so I've been doing more and more (bash) shell scripting (which I quite enjoy by the way).
To handle errors in my scripts I... (3 Replies)
Discussion started by: script_man
3 Replies
6. Shell Programming and Scripting
Hello gurus,
I have three korn shell script 3.1, 3.2, 3.3. I would like to call three shell script in one shell script.
i m looking for something like this
call 3.1;
If 3.1 = "complete" then
call 3.2;
if 3.2 = ''COMPlete" then
call 3.3;
else
exit
The... (1 Reply)
Discussion started by: shashi369
1 Replies
7. Shell Programming and Scripting
Hi,
I have a shell script confug-msys.sh which callls config-common.sh. When run from command prompt,these work fine but give the below error when i try to run from code-blocks
line 7: --without-contrib: command not found
...Also I am unable to understand what the second script does...... (4 Replies)
Discussion started by: binnyshah
4 Replies
8. HP-UX
Hi Members,
Can members please advise or suggest how to write UNIX script which
move all zip files in source directory and when done delete zip files from source directory? We want to delete only on successful transfer to the destination. secondly want to add some error checking if the FTP... (1 Reply)
Discussion started by: dxj0815
1 Replies
9. Shell Programming and Scripting
Dear all
I have shell script where files have been organized into directory, i pass the directory name and it shold pick all the files within the directory and move to differnet path.
When i run the scripts it doesn't move and come out with error and i am not able to understand it
the... (2 Replies)
Discussion started by: guddu_12
2 Replies
10. Shell Programming and Scripting
Hi, i am new in shell script. i have given a task to make a C-shell script. I have list of ip address and device name respectively. For example;
cal 1 : 100.21.25.10
cal 2 : 100.21.25.11
cal 3 : 100.21.25.12
cal 4 : 100.21.25.14
and so on...
Right now, i have this.
#! /bin/csh -f
... (0 Replies)
Discussion started by: lattey
0 Replies
LEARN ABOUT PHP
mysqli_rollback
MYSQLI_ROLLBACK(3) 1 MYSQLI_ROLLBACK(3)
mysqli::rollback - Rolls back current transaction
Object oriented style
SYNOPSIS
bool mysqli::rollback ([int $flags], [string $name])
DESCRIPTION
Procedural style
bool mysqli_rollback (mysqli $link, [int $flags], [string $name])
Rollbacks the current transaction for the database.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)
o $flags
- A bitmask of MYSQLI_TRANS_COR_* constants.
o $name
- If provided then ROLLBACK/*name*/ is executed.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
CHANGELOG
+--------+-------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+-------------------------------------+
| 5.5.0 | |
| | |
| | Added $flags and $name parameters. |
| | |
+--------+-------------------------------------+
EXAMPLES
Example #1
mysqli::rollback example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
/* disable autocommit */
$mysqli->autocommit(FALSE);
$mysqli->query("CREATE TABLE myCity LIKE City");
$mysqli->query("ALTER TABLE myCity Type=InnoDB");
$mysqli->query("INSERT INTO myCity SELECT * FROM City LIMIT 50");
/* commit insert */
$mysqli->commit();
/* delete all rows */
$mysqli->query("DELETE FROM myCity");
if ($result = $mysqli->query("SELECT COUNT(*) FROM myCity")) {
$row = $result->fetch_row();
printf("%d rows in table myCity.
", $row[0]);
/* Free result */
$result->close();
}
/* Rollback */
$mysqli->rollback();
if ($result = $mysqli->query("SELECT COUNT(*) FROM myCity")) {
$row = $result->fetch_row();
printf("%d rows in table myCity (after rollback).
", $row[0]);
/* Free result */
$result->close();
}
/* Drop table myCity */
$mysqli->query("DROP TABLE myCity");
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
/* disable autocommit */
mysqli_autocommit($link, FALSE);
mysqli_query($link, "CREATE TABLE myCity LIKE City");
mysqli_query($link, "ALTER TABLE myCity Type=InnoDB");
mysqli_query($link, "INSERT INTO myCity SELECT * FROM City LIMIT 50");
/* commit insert */
mysqli_commit($link);
/* delete all rows */
mysqli_query($link, "DELETE FROM myCity");
if ($result = mysqli_query($link, "SELECT COUNT(*) FROM myCity")) {
$row = mysqli_fetch_row($result);
printf("%d rows in table myCity.
", $row[0]);
/* Free result */
mysqli_free_result($result);
}
/* Rollback */
mysqli_rollback($link);
if ($result = mysqli_query($link, "SELECT COUNT(*) FROM myCity")) {
$row = mysqli_fetch_row($result);
printf("%d rows in table myCity (after rollback).
", $row[0]);
/* Free result */
mysqli_free_result($result);
}
/* Drop table myCity */
mysqli_query($link, "DROP TABLE myCity");
mysqli_close($link);
?>
The above examples will output:
0 rows in table myCity.
50 rows in table myCity (after rollback).
SEE ALSO
mysqli_begin_transaction(3), mysqli_commit(3), mysqli_autocommit(3), mysqli_release_savepoint(3).
PHP Documentation Group MYSQLI_ROLLBACK(3)