sql::reservedwords::postgresql(3pm) [debian man page]
SQL::ReservedWords::PostgreSQL(3pm) User Contributed Perl Documentation SQL::ReservedWords::PostgreSQL(3pm)NAME
SQL::ReservedWords::PostgreSQL - Reserved SQL words by PostgreSQL
SYNOPSIS
if ( SQL::ReservedWords::PostgreSQL->is_reserved( $word ) ) {
print "$word is a reserved PostgreSQL word!";
}
DESCRIPTION
Determine if words are reserved by PostgreSQL.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either PostgreSQL 7.3, 7.4, 8.0 or 8.1.
is_reserved_by_postgresql7( $word )
Returns a boolean indicating if $word is reserved by either PostgreSQL 7.3 or 7.4.
is_reserved_by_postgresql8( $word )
Returns a boolean indicating if $word is reserved by either PostgreSQL 8.0 or 8.1.
reserved_by( $word )
Returns a list with PostgreSQL versions that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_postgresql7
is_reserved_by_postgresql8
reserved_by
words
SEE ALSO
SQL::ReservedWords
<http://www.postgresql.org/docs/manuals/>
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords::PostgreSQL(3pm)
Check Out this Related Man Page
SQL::ReservedWords::DB2(3pm) User Contributed Perl Documentation SQL::ReservedWords::DB2(3pm)NAME
SQL::ReservedWords::DB2 - Reserved SQL words by DB2
SYNOPSIS
if ( SQL::ReservedWords::DB2->is_reserved( $word ) ) {
print "$word is a reserved DB2 word!";
}
DESCRIPTION
Determine if words are reserved by DB2.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either DB2 5, 6, 7 or 8.
is_reserved_by_db2v5( $word )
Returns a boolean indicating if $word is reserved by DB2 5.
is_reserved_by_db2v6( $word )
Returns a boolean indicating if $word is reserved by DB2 6.
is_reserved_by_db2v7( $word )
Returns a boolean indicating if $word is reserved by DB2 7.
is_reserved_by_db2v8( $word )
Returns a boolean indicating if $word is reserved by DB2 8.
reserved_by( $word )
Returns a list with DB2 versions that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_db2v5
is_reserved_by_db2v6
is_reserved_by_db2v7
is_reserved_by_db2v8
reserved_by
words
SEE ALSO
SQL::ReservedWords
<http://www-306.ibm.com/software/data/db2/udb/>
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords::DB2(3pm)
How do I substitute a word throughout a file? For example change all instances of the word John to Mark. This would be in vi for korn shell. (10 Replies)
Hi ,
If I match a word in a file, I want to pick the next line of that matched word.
My file is a below format-
The ntrag trace has auditError
Line5005 contains transaction Ntrag data
------------
Here I wanted if I match a word auditError, I need to get the next line
"Line5005... (10 Replies)
Hi all,
I am trying to search a SQL string and trying to find the table name in the query.
For e.g.
Select a,b,c,d,e,f from ITS.table where ITS.x=name
In the above string i need to identify the word ITS and replace with owner.
And also the name is not always ITS, it can be any... (11 Replies)
i want a shell script program for how many times a word occur in a file.
i need not the line number but i want the counts of the particular word
for eg:-
hai how r u..
i am from andhra pradesh..
i am from tenali.i need this answer.i need it urgently..
i hope u will answer this ...
... (9 Replies)
hello mighty all
there is a line of 50 words and i need to take a random number of words from the beginning (20 words for example) then put my word then add other 10 words from the continue then add another my special word then add 20 words till the end..
my own knowledge base can say it is... (12 Replies)
Hi,
I have a file:
file.txt
1 word
2 word
word
word
3 word
4 word
and I would like to create a set:
set number = `cut -d" " -f1 ${1}` #${1} is the text file
but it should only contain the lines which begin with numbers,
and another set which contains the lines which begin with... (10 Replies)
Hello,
I'm searching with the Awk command to split a file into two others files.
I explain :
in the file N°1 I search the word "NameVirtual" and since that word to the end of the file I want to store all lines in a new file N°2
Also from that word to the beginning of the file I want to... (11 Replies)
Hi,
I am trying to develop a script which should find a word if a particular word exists.
Below is the content of the file.
insert_job: test_job ----> job name
days_of_week: all
start_times: "16:00"
date_conditions: 1
insert_job: test_job2 ----> job name
days_of_week: all... (16 Replies)
Hi ,
i'm trying to count a particular word occurance in a whole directory..is this possible :wall:
say for example there is a directory with 100 files which and all the file may have the word 'aaa' in it ...how would i count the number of 'aaa' in those whole 100 files in a directory ?
... (10 Replies)
Hi,
I have gone through may posts and dint find exact solution for my requirement.
I have file which consists below data and same file have lot of other data.
<MAPPING DESCRIPTION ='' ISVALID ='YES' NAME='m_TASK_UPDATE' OBJECTVERSION ='1'>
<MAPPING DESCRIPTION ='' ISVALID ='NO'... (11 Replies)
Hello world,
Can anybody tell me how to count how many times does a word repeat in a file? There have been many threads on this but they all are heavy loads of Scripting for a starter like me. :D
So, I sat down today and after some hours of reading man pages, I found a simple one-line... (18 Replies)
Hi. I have to swap the first and the third word in all lines of a txt file using sed.
Separators between words are: any charachter, except intervall.
I hope, you'll understand what I want to do. my english is not so good, sorry for that:) (10 Replies)
Hello,
I have a Pro*C program which contains SQL sentences, such as:
....
Pro*C sentences
....
/*SQL 1*/
EXEC SQL SELECT t1.field1, t1.field2
INTO :w_field
FROM TABLE1 t1, TABLE1 t2
WHERE t1.field1 = t2.field1
AND t1.ID = :wl_id;
....
Pro*C sentences
....
/*SQL 1*/
EXEC... (11 Replies)
Hi,
I have a text file with one line having few words separated by space and I need to insert another word on "n"th column/field so that previous word should shift right (to n+1st column). how can I do that?
It seems we can do using awk but unable to figure out.
Please advise, thanks!
... (11 Replies)
Hello there
so i have a txt file containing word like "one two three four plus four five six".
I want to save every word in the file into a variable, and then use that variable to generate real numbers and apply the arithmetic value on them.
example: the txt files becomes 123 + 456 and... (10 Replies)