10-23-2014
All primary keys are going to be bigint.
I also noticed my sed command is messed up
I want to replace the line only if the whole word exists
i.e clm_id double, should become clm_id bigint
but
actv_clm_id double, should remain the same
Last edited by wahi80; 10-23-2014 at 03:18 PM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am having problems with the following "sed" command only when it is issued within a bash script.
#!/bin/bash
cat config.xml | sed -e 's/yes/no/g' > newconfig.xml
When I enter this command from the command line it works like a charm, but when run in a script as shown it "zero's out" my... (2 Replies)
Discussion started by: darthur
2 Replies
2. Shell Programming and Scripting
The following awk script creates a file b.dat.
awk '{print substr($0,1,27),substr($2,index($2,"_")+1)," ",substr($0,49)}' a.dat > b.dat
I need this script to be modified to also sum $3 values by distinct $1 and $2
fields.
Current file
W2_2009275 2 8
W2_2009275 2 7
W1_2009275 1... (3 Replies)
Discussion started by: mnnarendra
3 Replies
3. Shell Programming and Scripting
Hi,
I want to modifiy the hour in the crontab AIX 5.3 for this line:
Input:
00 22 * * * /outillage/script_exploit/bin/SavOffline.ksh > /dev/null 2>&1
Output:
30 20 * * * /outillage/script_exploit/bin/SavOffline.ksh > /dev/null 2>&1
With the awk or sed function through a ssh -q... (1 Reply)
Discussion started by: khalidou13
1 Replies
4. Shell Programming and Scripting
Greetings!
Some of my files list hardware errors (we test electronic components), some have none. If the file name has no errors, I still want to display a message like "No error", else I display the error from the file itself.
I came up with this (with help)
for myfile in `find . -name... (2 Replies)
Discussion started by: alan
2 Replies
5. Shell Programming and Scripting
I'm trying to take out strings from log files and add them to a csv.
For example, in the directory now, there are 2 log files. I get the following results:
sed -e '/custodian/b' -e '/packaged by/b' -e '/package name/b' -e '/Total Data (MB) Read/b' -e '/Begin Time/b' -e d *
packaged by =... (10 Replies)
Discussion started by: chipperuga
10 Replies
6. Shell Programming and Scripting
Hi All,
I need help from any of you.Would be so thankful for your help.
I/P
DDDD,1045,161,1557,429,1694,800,1911,1113,2460,1457,2917>
1609,3113,1869,3317,2732,3701,3727,4132,5857,5107>
9004,6496
DDDD,1125,157,1558,429,1694,800,1911,1117,2432,1444,2906>... (2 Replies)
Discussion started by: Indra2011
2 Replies
7. Shell Programming and Scripting
I need to
1.Open a csv
2.Process the csv i.e. Modify 2 column in the csv.
To modify the column the value needs to be passed to a pl/sql function and the return value should be updated
For eg:
If column 2 E,then E will be passed in database function
which will return Employee.
3. Write a... (5 Replies)
Discussion started by: Chinky23
5 Replies
8. Shell Programming and Scripting
Hi All,
I want to modify(changing the status from "on" to "off" status of Stage-element value from the below xml file using sed or awk:
File Name: global.xml
<?xml version="1.0" encoding="UTF-8"?>
<config>
<widget>
<name>HTTP-POOL</name>
<attributes>
... (5 Replies)
Discussion started by: wamqemail2
5 Replies
9. UNIX for Beginners Questions & Answers
Hi All ,
I would require your help to generate one output file after post processing of one CSV file as stated below
This file is just a small cut from a big file . Big file is having 20000 lines
PATTERN,pat0,pat1,pat2,pat3,pat4,pat5,pat6,pat7,pat8,pat9... (2 Replies)
Discussion started by: kshitij
2 Replies
10. UNIX for Beginners Questions & Answers
Hello everybody,
I would like modify some strings using sed or another command line with the content file.
For example:
- {fqdn: "server-01" , ip: "server-01"}
- {fqdn: "server-02" , ip: "server-02"}
- {fqdn: "server-03" , ip: "server-03"}
- {fqdn: "server-04" , ip: "server-04"}
My... (4 Replies)
Discussion started by: dco
4 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)