04-10-2009
Thanks very much, I didn't think to try that.
Anyone know how to keep the cursor on the line in the here statement?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi all,
if i do an:
"echo $string |" what should be after the pipe to display ONLY the last char of the output?
tia,
DN2 (9 Replies)
Discussion started by: DukeNuke2
9 Replies
2. UNIX for Dummies Questions & Answers
im having trouble doing this:
i have a variable with 2 characters repeating e.g. aababbbaaaababaabbaabbba
is there a way i can search the variable for a's and b's and then change a's to b's and b's to a's?
im guessing its like getting the 1's compliment of the string
im doing this in... (2 Replies)
Discussion started by: vipervenom25
2 Replies
3. UNIX for Advanced & Expert Users
no problem (6 Replies)
Discussion started by: angelina
6 Replies
4. Shell Programming and Scripting
Hi everybody,
I'm using Hp unix tru64.
I have generate one file from shell script.
bus that file content pre "8 space char" convert one tab character.
why?
result file hex format:
hex 20 20 20 20 20 to 09 (6 Replies)
Discussion started by: Tlg13team
6 Replies
5. Shell Programming and Scripting
Hi,
I am having trouble using the result of the following awk command in a script, as displaying the contents of the placeholder automatically replaces the new created TAB by a space character again:
From the prompt:
cscyabl@comet:(develop)> echo "01 12" | awk '{gsub(" ","\t");print}'
01 ... (2 Replies)
Discussion started by: Indalecio
2 Replies
6. Shell Programming and Scripting
I would like to remove characters from column 7 so that from an input file looking like this:
>HWI-EAS422_12:4:1:69:89 GGTTTAAATATTGCACAAAAGGTATAGAGCGT U0 1 0 0 ref_chr8.fa 6527777 F DD
I get something like that in an output file:
... (13 Replies)
Discussion started by: matlavmac
13 Replies
7. UNIX for Dummies Questions & Answers
I would like to display the last 8 characters of the filenames for filenames of different lengths.
I can delete the last 8 characters with sed but dont know how to only show the last 8 characters.
The filenames are something like;
afxH340800340000
afxH30800340021
afxR3080034002122
I... (3 Replies)
Discussion started by: Beanz
3 Replies
8. UNIX for Dummies Questions & Answers
I am trying to remove the tab character from a file, which occurs on two places in every line. So far I have tried the following and most are from threads in this forum:
sed -i '' -e 's/ / /' file.dat
sed -i '' -e 's/*/ /' file.dat
sed -i '' -e 's/\t*/ /g' file.dat
sed -i '' -e 's/*//g'... (4 Replies)
Discussion started by: figaro
4 Replies
9. Shell Programming and Scripting
Hello.
I am using :
sed -i -e '/§name_script§/a#'"${MY_TAB11}"'# \
#'"${MY_TAB1}"'The Standard way'"${MY_TAB7}"'# \
#'"${MY_TAB1}"'==============='"${MY_TAB7}"'# \ ' "$CUR_FILE"
Is there a better way to define "MY_TAB7","MY_TAB11" in other way than :
MY_TAB1=$'\t'
MY_TAB2=${MY_TAB1}$'\t'... (2 Replies)
Discussion started by: jcdole
2 Replies
10. Shell Programming and Scripting
I have a Zsh script which invokes another program. One of the paramters to be passed, should be a literal tab, i.e what in common programming languages is often written as "\t".
If it were bash, I think I could use the special form
$"\t"
but this doesn't seem to work (the called program... (5 Replies)
Discussion started by: rovf
5 Replies
LEARN ABOUT PHP
db2_num_rows
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)