[Solved] Extract information according to values defined
Gents,
Here again,, I have a problem to get a extract of some values.
Every 2 rows I got a new number ( columns 12-25 ), I mean the values are repeated every 2 rows can be 3 times or 4 sometimes,, to identify that there is duplicate values a index value are write in colunm 26 ( increase 1,2, 3 ..... ).
I will call.
ID ( columns 12-25)
INDEX ( columna 26)
STATUS ( cloumnas 91-92)
File input ( attached file ).
What I looking for, is to verify that the last repeated ID dont contens STATUS equal to 14 or 98, and if this is the case I need to get the following report.
This is very complicate for me,, So, so I am writing to see if there is the possibility to help me.
This is my problem, my file (file A) contains the following information:
Now, I would like to create a file (file B) containing only the lines with 10 or more characters but less than 20 with their corresponding ID:
Then, I need to compare the entries and determine their frequency. Thus, I... (7 Replies)
Hi,
I'm trying to download a compatible Oracle Client software for a HP-UX machine. I'd like to know if ...
1) HP-UX is 32 bit or 64 bit?
2) Processor type - Itanium or regular?
when I execute uname -a I get
HP-UX B.11.11 U 9000/800 728684161 unlimited-user license
Based on the... (7 Replies)
Hi folks,
is there any recommendation, especially from a point of performance, about where to place a user-defined function in awk, like in BEGIN{} or if it is only need once at the end in END{}? Or doesn't it matter at all since, awk is so clever and only interprets it once, wherever it is... (3 Replies)
I do have a file of the following format
file 1
>SAM
ATGCTCCTTAGCTACGTAGCAAGTAGAAAAAA
AGCGCGAGCATTGAAGCGGAGGAGAGGAGGA
TGAGATGATGACCCAGTATAAAGAGTGATGAT
like this above file. file 1 has 1000's of lines. I would like to edit this file1 using the information from file2 (see below), by... (16 Replies)
I am having a file called variable_info.ksh in that file I am having following global variable information like…
EMAIL_PATH=/var/mail
TMP_PATH=/home/tmp
And we are having another temporary parameter file abcd.txt, in that file we are having the following information like…
EMAIL|EMAI_PATH
I... (4 Replies)
I have the variable defined in .bashrc
BIN_DIR="/usr/local/dw"
and in my shell script i am using below.
#!/bin/bash
echo "Bin Dir: ${BIN_DIR}"
. "${BIN_DIR}"/dwh_Loadfuncs.sh
Output:
Bin Dir:
/usr/local/dw/dwh_LoadXMLFileIntoStage.sh: line 7: /dwh_Loadfuncs.sh: No such file or... (3 Replies)
I need to grab information from the output of the ps command.
For each line of ps output that contains _progres -b I need to get the word that follows -p. The "-p" can be anywhere after "_progres -b".
Using grep to select the correct lines is no problem (e.g. ps -ef|grep "_progres \-b|grep -v... (3 Replies)
Dear Experts,
I need your help here. I have lot of teradata DDL's as follows, i want to extract field names , field attributes and NOT NULL information from DDL.Could you please help here.
Sample DDL:
CREATE MULTISET TABLE APS_CALL_IN_PICKUP_CANCELED ,NO FALLBACK ,
NO BEFORE... (2 Replies)
Hello
I am analyzing disk performance OSR5.0.7 running inside VirtualBox.
GUEST: osr5.0.7; 1GB ram; raw disk
HOST: SLES11SP3, 4GB ram; 1 disc SATA2-7200rpm
But I'm not sure how to do it right (the values returned by sar not match the values of the physical machine)
The attributes... (0 Replies)
I have a file (let say file B) like this:
File B:
A1 3 5
A1 7 9
A2 2 5
A3 1 3
The first column defines a filename and the other two define a range in that specific file. In the same directory, I have also three more files (File A1, A2 and A3). Here is 10 sample lines... (3 Replies)
Discussion started by: Bastami
3 Replies
LEARN ABOUT REDHAT
drop_index
DROP INDEX(7) SQL Commands DROP INDEX(7)NAME
DROP INDEX - remove an index
SYNOPSIS
DROP INDEX index_name [, ...] [ CASCADE | RESTRICT ]
INPUTS
index_name
The name (optionally schema-qualified) of an index to remove.
CASCADE
Automatically drop objects that depend on the index.
RESTRICT
Refuse to drop the index if there are any dependent objects. This is the default.
OUTPUTS
DROP INDEX
The message returned if the command completes successfully.
ERROR: index "index_name" does not exist
This message occurs if index_name is not an index in the database.
DESCRIPTION
DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index.
NOTES
DROP INDEX is a PostgreSQL language extension.
Refer to CREATE INDEX [create_index(7)] for information on how to create indexes.
USAGE
This command will remove the title_idx index:
DROP INDEX title_idx;
COMPATIBILITY
SQL92
SQL92 defines commands by which to access a generic relational database. Indexes are an implementation-dependent feature and hence there
are no index-specific commands or definitions in the SQL92 language.
SQL - Language Statements 2002-11-22 DROP INDEX(7)