10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Well, guys I saw a question about GOTO for Python.
So this gave me the inspiration to attempt a GOTO function for 'dash', (bash and ksh too).
Machine: MBP OSX 10.14.3, default bash terminal, calling '#!/usr/local/bin/dash'...
This is purely a fun project to see if it is possible in PURE... (3 Replies)
Discussion started by: wisecracker
3 Replies
2. Shell Programming and Scripting
Hey :) I am trying to understand the command goto.
I have some questions regarding the goto manual.
1.What does the underlined part mean?
I'm not allowed to type goto in the shell? But if goto is written into a file everything is okay?
2.So if a part of my file looks like this
...
goto... (8 Replies)
Discussion started by: orbit
8 Replies
3. Shell Programming and Scripting
#!/bin/sh
label:
echo sql poll
v=`sqlplus -s <<!
HR/HR
set pages 0 echo off feed off
select distinct status from
emp
where
id=5;
!
`
echo $v;
echo it comes here after false
if
then
echo if condition true
sqlplus -l scott/tiger <<EOF
select * from department;
EXIT (2 Replies)
Discussion started by: kumaar1986
2 Replies
4. Shell Programming and Scripting
Hi,
I have an array with characters and I am looking for specific character in that array and if those specific character not found than I use goto statment which is define somehwhere in the script. My code is:
set a = (A B C D E F)
@ i = 0
while ($i <= ${#a})
if ($a != "F" || $a != "D")... (3 Replies)
Discussion started by: dixits
3 Replies
5. Shell Programming and Scripting
Im trying to do something like this but I cant find any documentation.
read X
if
then goto ThisLine
fi
OTHER CODE
OTHER CODE
Label: ThisLine echo "You entered 1" (5 Replies)
Discussion started by: Grizzly
5 Replies
6. Solaris
Dear All,
Can any one pls let me the command for how to goback to previous visited directory from the current working directory in SunOS ?
In case of HP-UX; the same can be resolved through "cd -" command.
Thanks in advance!
Prasanth Babu. (6 Replies)
Discussion started by: prasanth_babu
6 Replies
7. UNIX for Dummies Questions & Answers
uname -a returns: SMP Tue May 17 17:52:23 EDT 2005 i686 athlon i386 GNU/Linux
I have many aliases beginning with "goto" so...
if I type goto and then hit return (oops)
A goto prompt pops up and I cant exit from it(I tried MANY key seqs)
The only way to exit is to kill the term window... (2 Replies)
Discussion started by: rairey
2 Replies
8. Shell Programming and Scripting
I have a test script for using goto statement but its not working. please help
i tried both in linux and hp-ux it's not working please help
#! /bin/ksh
t=`ps -ef|grep ti.sh|grep -v grep`
if ; then
goto start
else
goto stop
fi
start:
echo "start"
stop:
echo "stop" (5 Replies)
Discussion started by: Krrishv
5 Replies
9. Shell Programming and Scripting
Is there a Unix (Solaris v8 ksh) version of the old basic command gosub or goto? I've researched the return command, but can't identify the command to return from. I am not trying to return from a function. Can someone give me a basic understanding of this please? Thanks so much in advance for... (3 Replies)
Discussion started by: gozer13
3 Replies
10. Shell Programming and Scripting
Hi,
I'm trying to use the goto in ksh but it does not appear to be a valid command. Is that only valid in csh? Anything similar in ksh that I can use?
Appreciate any help you can provide.
Thanks.
geraldine (4 Replies)
Discussion started by: Geraldine
4 Replies
DB2_NUM_ROWS(3) 1 DB2_NUM_ROWS(3)
db2_num_rows - Returns the number of rows affected by an SQL statement
SYNOPSIS
int db2_num_rows (resource $stmt)
DESCRIPTION
Returns the number of rows deleted, inserted, or updated by an SQL statement.
To determine the number of rows that will be returned by a SELECT statement, issue SELECT COUNT(*) with the same predicates as your
intended SELECT statement and retrieve the value.
If your application logic checks the number of rows returned by a SELECT statement and branches if the number of rows is 0, consider modi-
fying your application to attempt to return the first row with one of db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_array(3), or
db2_fetch_row(3), and branch if the fetch function returns FALSE.
Note
If you issue a SELECT statement using a scrollable cursor, db2_num_rows(3) returns the number of rows returned by the SELECT state-
ment. However, the overhead associated with scrollable cursors significantly degrades the performance of your application, so if
this is the only reason you are considering using scrollable cursors, you should use a forward-only cursor and either call SELECT
COUNT(*) or rely on the boolean return value of the fetch functions to achieve the equivalent functionality with much better perfor-
mance.
PARAMETERS
o $stmt
- A valid stmt resource containing a result set.
RETURN VALUES
Returns the number of rows affected by the last SQL statement issued by the specified statement handle.
PHP Documentation Group DB2_NUM_ROWS(3)