Hi All,
My files(.csv) are created in download path.
All the files files are having footer with count of rows or may be blank.
When i am trying to put this below code in shell script and run it, the row_num is not getting assigned,
but works correctly on command prompt.
I am trying to put this count into a control file.
Please help me out as to what is worng.
Thanks for the help in advance.
I'm currently trying yo make a script that takes info from a text file but I have a problem with this line:
@ count = 0 # variable initialization
@ count = grep faildata 3A | grep -c 178
where:
"faildata" is the pattern
"3A" is the filename
What I want is to assign the numeric result of... (1 Reply)
I'm writting a krn shell script and i'm having an issue with a variable using sed.
If someone enters a variable with a " /" the sed command doesn't read it right.
example.
a='12000/10-DC'
b='12000/10-AC'
cat file | sed "s/$a/$b/"
How can i correct this issue? Will the fix to this... (2 Replies)
Hi All,
i am new to unix..
i have an issue with my unix script...let me explain the task that i want to make script....
i prepared script which will connect data base from my linux box using sqlplus cmd...
however in that i want to use the variable like below..
select * from... (0 Replies)
The code im having problems with is highlighted in red, upon selecting option 2 on the main menu (highlighted green) my echo "NETWORK CONNECTIVITY" command seems to get overlooked and the resulting output is "Thank you for using the Operator Administrative Tool." being displayed. Can anyone tell me... (2 Replies)
Hi,
I'm sure that it's a very simple issue.
this is a part of my code :
while read ligne
do
result=`ls -R ../FILES/|grep "."$ligne"$"`
echo $result
done<TYPE_EXT_FILES.txt
the echo return nothing (as my variable is empty).
I'm sure that the problem... (10 Replies)
Hello,
I logged in to the unix solaris with my user name and then I again logged in with the sudo bash -l command
now when I do echo $PATH
It shows me => /usr/bin:/usr/local/bin:/usr/bin/usr/sbin:/usr/ucb:/usr/local/bin
How do i find out where is this file located for setting the... (3 Replies)
Hi,
I am doing an AWK in ksh as below with the string to search to be read from variable but for some reason there is no output. It works when I hard code it.
awk 'substr($0,22,6)=="${VAR}"' XXX.txt' >YYY.txt
On reading other posts I tried below option,
'substr($0,22,6)=="/"${VAR}/""'
... (3 Replies)
Hi All,
I am using the below script which has awk command, but it is not returing the expected result. can some pls help me to correct the command.
The below script sample.ksh should give the result if the value of last 4 digits in the variable NM matches with the variable value DAT. The... (7 Replies)
Hi,
I need a help in setting scope of the variable. I want to use the below logic right before the "break" statement
if ; then
echo $header
echo $trailer
fi
But due the scope of the variable it is causing issues. I tried using "export" statement. But it changes the output completely
... (0 Replies)
I have this file (1.txt):
>sample
TCGGCCCGJOHNTTTTGCGGGCCGCATTGTCGCCAGGCGCDOEGGGGTTTGCGATCGCCACGGGGCTGATGGTGGCGACCCGCTGCACCCGG
I am using the following script to "trim" the sequence
awk '{gsub(/^.*JOHN|DOE.*$/,"",$0)} 1'
This is the output:
>sample
TTTTGCGGGCCGCATTGTCGCCAGGCGC
... (6 Replies)
Discussion started by: Xterra
6 Replies
LEARN ABOUT PHP
cubrid_prepare
CUBRID_PREPARE(3) 1 CUBRID_PREPARE(3)cubrid_prepare - Prepare a SQL statement for executionSYNOPSIS
resource cubrid_prepare (resource $conn_identifier, string $prepare_stmt, [int $option])
DESCRIPTION
The cubrid_prepare(3) function is a sort of API which represents SQL statements compiled previously to a given connection handle. This
pre-compiled SQL statement will be included in the cubrid_prepare(3).
Accordingly, you can use this statement effectively to execute several times repeatedly or to process long data. Only a single statement
can be used and a parameter may put a question mark (?) to appropriate area in the SQL statement. Add a parameter when you bind a value in
the VALUES clause of INSERT statement or in the WHERE clause. Note that it is allowed to bind a value to a MARK(?) by using the
cubrid_bind(3) function only.
PARAMETERS
o $conn_identifier
-Connection identifier.
o $prepare_stmt
-Prepare query.
o $option
-OID return option CUBRID_INCLUDE_OID.
RETURN VALUES
Request identifier, if process is successful;
FALSE, if process is unsuccessful.
EXAMPLES
Example #1
cubrid_prepare(3) example
<?php
$conn = cubrid_connect("localhost", 33000, "demodb");
$sql = <<<EOD
SELECT g.event_code, e.name
FROM game g
JOIN event e ON g.event_code=e.code
WHERE host_year = ? AND event_code NOT IN (SELECT event_code FROM game WHERE host_year=?) GROUP BY event_code;
EOD;
$req = cubrid_prepare($conn, $sql);
cubrid_bind($req, 1, 2004);
cubrid_bind($req, 2, 2000);
cubrid_execute($req);
$row_num = cubrid_num_rows($req);
printf("There are %d event that exits in 2004 olympic but not in 2000. For example:
", $row_num);
printf("%-15s %s
", "Event_code", "Event_name");
printf("----------------------------
");
$row = cubrid_fetch_assoc($req);
printf("%-15d %s
", $row["event_code"], $row["name"]);
$row = cubrid_fetch_assoc($req);
printf("%-15d %s
", $row["event_code"], $row["name"]);
cubrid_disconnect($conn);
?>
The above example will output:
There are 27 event that exits in 2004 olympic but not in 2000. For example:
Event_code Event_name
----------------------------
20063 +91kg
20070 64kg
SEE ALSO cubrid_execute(3), cubrid_bind(3).
PHP Documentation Group CUBRID_PREPARE(3)