10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have a unix script which generates the csv file. the data in csv file is dynamic. how can i convert/move the data from csv file to xml. please suggest (1 Reply)
Discussion started by: archana25
1 Replies
2. Shell Programming and Scripting
Hi guys,
I am pulling my hair out here. I have a file that comes in, once it finishes i want to move it to a new location. This sounds all very easy but my solution is failing and moves the file before it has finished generating.
isrun=`ps -ef | grep -i filename | grep -v grep | wc -l`
... (8 Replies)
Discussion started by: twinion
8 Replies
3. UNIX for Dummies Questions & Answers
Hi Guys,
I have a simple request. I have a file in w3c format. Each file has 2 header lines. Rest of the lines are 16 columns each. They are separated by Tab. I need to discard the first 2 lines and then write each column of the txt file into a seperate column of CSV. I tried the command below... (1 Reply)
Discussion started by: tinkugadu
1 Replies
4. Shell Programming and Scripting
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Discussion started by: arghadeep adity
6 Replies
5. UNIX for Dummies Questions & Answers
HI,
I want to append some configuration statements to the existing file in unix to it's 3 line , 7th line and 28 line.
There is a file generated by our system job, to this I need to add some lines as mentioned below.
DIR=/usr/CDR - line 3
Source=/usr/src - line 7
Target=/usr/tgt - line... (2 Replies)
Discussion started by: mora
2 Replies
6. Emergency UNIX and Linux Support
Hi Gurus,
I have a requirement as below
I have text file a.txt which contains
hi hello
process update
status
Output for file Ok to Proceed no issues good
data arrangement
My requirement here is i need to read the file and check for the words
"OK to Proceed" and if it is available... (14 Replies)
Discussion started by: pssandeep
14 Replies
7. Shell Programming and Scripting
Hello Gurus,
We are facing some performance issue in UNIX. If someone had faced such kind of issue in past please provide your suggestions on this .
Problem Definition:
/Few of load processes of our Finance Application are facing issue in UNIX when they uses a shell script having below... (19 Replies)
Discussion started by: KRAMA
19 Replies
8. UNIX for Dummies Questions & Answers
Hi,
Our requirement is we have to create file from one file where all the rows from source file is converted into columns of the target file.
For example
Source file is :
Status Report ABC
Generated: 2009-05-05 08:49:47
Job start time=2009-05-05 08:43:43
Job end time=2009-05-05... (1 Reply)
Discussion started by: Amey Joshi
1 Replies
9. Shell Programming and Scripting
I am trying to find for the pattern in first 5 bytes of every line in a text file and then generate a new file with the pattern found.
Example: expected pattern is '-' to be serached in first 5 bytes of file only.
Input File
ab-cd jan-09
ddddd jan09
cc-ww jan09
dsgdq jan-09
... (2 Replies)
Discussion started by: net
2 Replies
10. Shell Programming and Scripting
Forgive the daft requests - I'm still a learner :D
I need a script so that I can test another script (I'm confused already) The script I am looking for should generate a new file in the same directory (called newfile1 or what ever) and also generate text within the new file (Hello world? What... (1 Reply)
Discussion started by: JayC89
1 Replies
MYSQLI_FIELD_COUNT(3) 1 MYSQLI_FIELD_COUNT(3)
mysqli::$field_count - Returns the number of columns for the most recent query
Object oriented style
SYNOPSIS
int$mysqli->field_count ()
DESCRIPTION
Procedural style
int mysqli_field_count (mysqli $link)
Returns the number of columns for the most recent query on the connection represented by the $link parameter. This function can be useful
when using the mysqli_store_result(3) function to determine if the query should have produced a non-empty result set or not without knowing
the nature of the query.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)
RETURN VALUES
An integer representing the number of fields in a result set.
EXAMPLES
Example #1
$mysqli->field_count example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "test");
$mysqli->query( "DROP TABLE IF EXISTS friends");
$mysqli->query( "CREATE TABLE friends (id int, name varchar(20))");
$mysqli->query( "INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");
$mysqli->real_query("SELECT * FROM friends");
if ($mysqli->field_count) {
/* this was a select/show or describe query */
$result = $mysqli->store_result();
/* process resultset */
$row = $result->fetch_row();
/* free resultset */
$result->close();
}
/* close connection */
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "test");
mysqli_query($link, "DROP TABLE IF EXISTS friends");
mysqli_query($link, "CREATE TABLE friends (id int, name varchar(20))");
mysqli_query($link, "INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");
mysqli_real_query($link, "SELECT * FROM friends");
if (mysqli_field_count($link)) {
/* this was a select/show or describe query */
$result = mysqli_store_result($link);
/* process resultset */
$row = mysqli_fetch_row($result);
/* free resultset */
mysqli_free_result($result);
}
/* close connection */
mysqli_close($link);
?>
PHP Documentation Group MYSQLI_FIELD_COUNT(3)