11-08-2009
what is the output of your SQL code.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Here is my problem.. i have 2 files (file1, file2).. i have wrote the last two lines and first 4 lines of "file2" into two different variables .. say..
my $firstrec = `head -4 $file2`;
my $lastrec = `tail -2 $file2`;
and i write the rest of the file2 to a tmpfile and cat it with head... (2 Replies)
Discussion started by: meghana
2 Replies
2. Shell Programming and Scripting
Hi All,
I need to maintain a AUDIT file in system for every incoming and outgoing file. For this i am trying to append a record by using the AWK every time the file arriving.
I have used the code as below.
AWK '{print "FILENAME IS", $1,"DATE IS", $2}' >> AUDITFILE.txt
$1 and $2 are global... (1 Reply)
Discussion started by: Raamc
1 Replies
3. Shell Programming and Scripting
Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Discussion started by: aemunathan
8 Replies
4. Shell Programming and Scripting
I need to write value of variable $version at a particular line in a text file.
Line number is determined by another variable &line......I don't know how to do it in shell script ... (2 Replies)
Discussion started by: punitpa
2 Replies
5. Programming
I am trying to write binary data to a file. My program below:
#include <stdlib.h>
#include <stdio.h>
struct tinner {
int j;
int k;
};
struct touter {
int i;
struct tinner *inner;
};
int main() {
struct touter data;
data.i = 10;
struct tinner... (4 Replies)
Discussion started by: radiatejava
4 Replies
6. Shell Programming and Scripting
Hi All,
Please help me in writing data to a file in one row.
In database there is a column which contains large data which does not fit in the file in one row. The column contains list of paths. I want to write these paths to a file in one row.
Please find the code below writes :
... (2 Replies)
Discussion started by: rajeshorpu
2 Replies
7. Shell Programming and Scripting
I have a file that contains records in the below format:
23857250998423948239482348239580923682396829682398094823049823948
23492780582305829852095820958293582093585823095892386293583203248
23482038509825098230958235234230502958205983958235820358205892095... (10 Replies)
Discussion started by: shellhelp
10 Replies
8. Shell Programming and Scripting
I am having an input file for eg. file.txt which contains pipe delimited rows
file.txt:
xx|yyy|zz|12|3|aaaaa|.....
yy|zz|1|3|4|xxxxx|.......
.
.
.
i want the above file name to be transformed into another file with giving input from the user and replacing the corresponding fields based... (5 Replies)
Discussion started by: rohit_shinez
5 Replies
9. Emergency UNIX and Linux Support
Sorry if I repost my question in this section, but I'm really in a hurry since I have to finish my work... :(
Dear community,
I have a table with two rows like:
Row1 Row2
======= =======
7,3 text 1
1,3 text 2
1,2,3 blabla
What i need to do is add/copy... (2 Replies)
Discussion started by: Lord Spectre
2 Replies
LEARN ABOUT DEBIAN
sql::reservedwords::sqlserver
SQL::ReservedWords::SQLServer(3pm) User Contributed Perl Documentation SQL::ReservedWords::SQLServer(3pm)
NAME
SQL::ReservedWords::SQLServer - Reserved SQL words by SQL Server
SYNOPSIS
if ( SQL::ReservedWords::SQLServer->is_reserved( $word ) ) {
print "$word is a reserved SQL Server word!";
}
DESCRIPTION
Determine if words are reserved by SQL Server.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by SQL Server 7, 2000 or 2005.
is_reserved_by_sqlserver7( $word )
Returns a boolean indicating if $word is reserved by SQL Server 7.
is_reserved_by_sqlserver2000( $word )
Returns a boolean indicating if $word is reserved by SQL Server 2000.
is_reserved_by_sqlserver2005( $word )
Returns a boolean indicating if $word is reserved by SQL Server 2005.
reserved_by( $word )
Returns a list with SQL Server 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_sqlserver7
is_reserved_by_sqlserver2000
is_reserved_by_sqlserver2005
reserved_by
words
SEE ALSO
http://msdn2.microsoft.com/en-us/library/ms130214.aspx
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::SQLServer(3pm)