i want to convert from an integer to a string..in unix...i am writing a C program with embedded SQL...
I remeber using itoa...but for some reason it doesnt work......i cant find it in the manual.....
Maybe that is the wrong command.....
but i have checked Dev Studio.....and it doest exist in the... (6 Replies)
how i can read a long integer from standar input and a string with as many characters as specified in the number?
i thing that i must use the read command ofcourse.... (6 Replies)
How to convert string into an integer or number
For example :
% set tim = `date`
% echo $tim
Tue Feb 22 16:25:08 IST 2011
here How to increment time by 10 hrs
like 16+10 , here 16 is a string in date cmd. .. how to convert 16 to an integer and added to a another nimber ?
Thanks... (3 Replies)
hello,
i am writing a script that takes the UID from the PASSWD and then i want
to increse the Number by one. for the Next user.
i cannot get this to work that a variable is as interger
example:
set i = 0
set $i = $+1
it's in tcsh if it's mather (10 Replies)
Hi , Can you have a look at my code it should display integer in file but it doesn't
#include <stdio.h>
/* This function reads two values from a file. */
int demonstrate_fscanf(void)
{
FILE *InFile;
int b, numValuesRead;
InFile = fopen("fadata.rtf", "r");
if... (3 Replies)
Hi fellows!!
i'm doing something which is not working out for me properly which i don't understand why
nowdate=`date +%s`
echo $nowdate
now the problem how to convert a date which is stored in a variable
mydate="22/Oct/2011"
mydate=`date -d '$mydate' +%s`
it gives error... (11 Replies)
Using below command
awk 'NR==FNR{A=$1;next}
{sum+=($2*A)}END{OFMT="%20f";print int(sum)}' Market.txt Product.txt
answer:351770174.00000
how to convert this to 351770174.
when i try with below command i am getting different result.
awk 'NR==FNR{A=$1;next}... (3 Replies)
Hi All,
sessionid_remote=$(echo "select odb_sessionid from sysopendb where odb_dbname='syscdr';" | sudo -u cucluster ssh ucbu-aricent-vm93 "source /opt/cisco/connection/lib/connection.profile; $INFORMIXDIR/bin/dbaccess sysmaster@ciscounity")
for sid in $sessionid_remote;do
if * ]];... (2 Replies)
Hi all,
I am trying to write a script to be able to
Run top command
Pick the PIDs that are taking more than 90% of CPU time
Get more details like what is the script name and location for that PID
Script should run until I manually kill it by ctrl + C
I have come up with following script... (3 Replies)
I have data as below
"ROWS merge process complete. thousand rows changed"
I need to get a variable assigned the value of 1000. I mean convert the string thousand to 1000.
Any help or pointer.
Please use CODE tags as required by forum rules! (6 Replies)
Discussion started by: dsravanam
6 Replies
LEARN ABOUT SUSE
drop_operator
DROP OPERATOR(7) SQL Commands DROP OPERATOR(7)NAME
DROP OPERATOR - remove an operator
SYNOPSIS
DROP OPERATOR [ IF EXISTS ] name ( { lefttype | NONE } , { righttype | NONE } ) [ CASCADE | RESTRICT ]
DESCRIPTION
DROP OPERATOR drops an existing operator from the database system. To execute this command you must be the owner of the operator.
PARAMETERS
IF EXISTS
Do not throw an error if the operator does not exist. A notice is issued in this case.
name The name (optionally schema-qualified) of an existing operator.
lefttype
The data type of the operator's left operand; write NONE if the operator has no left operand.
righttype
The data type of the operator's right operand; write NONE if the operator has no right operand.
CASCADE
Automatically drop objects that depend on the operator.
RESTRICT
Refuse to drop the operator if any objects depend on it. This is the default.
EXAMPLES
Remove the power operator a^b for type integer:
DROP OPERATOR ^ (integer, integer);
Remove the left unary bitwise complement operator ~b for type bit:
DROP OPERATOR ~ (none, bit);
Remove the right unary factorial operator x! for type bigint:
DROP OPERATOR ! (bigint, none);
COMPATIBILITY
There is no DROP OPERATOR statement in the SQL standard.
SEE ALSO
CREATE OPERATOR [create_operator(7)], ALTER OPERATOR [alter_operator(7)]
SQL - Language Statements 2010-05-14 DROP OPERATOR(7)