03-09-2012
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello all,
I have a script that has an infile with system package information. For the most part the script is looking well. The only thing i need help is in testing for null entries and removing null data.
#!/usr/bin/ksh
for i in `cat /mwncps/bin/eco_pack`
do
NAME=`pkginfo -l |... (2 Replies)
Discussion started by: liketheshell
2 Replies
2. Shell Programming and Scripting
Hi,
In the code below, the $DD1, $DD2, $MM1, $MM2 are not fetching the values. Can anybody tell me where have i made wrong.
Shift_date.sh is a script which gives the previous date if we give the current date in the format YYYYMMDD and +/- how many days past/future.. Like Shift_date.sh... (3 Replies)
Discussion started by: RRVARMA
3 Replies
3. Shell Programming and Scripting
Hi,
I want to remove spaces from data.
Data is:
1,aa ,21, 22
2,a a ,23 ,24
3, ,25 ,26
output should be:
1,aa,21,22
2,a a,23,24
3, ,25,26
i.e
i have to remove leading and trailing spaces.Not the space between data and also i dont want to remove the space if data is... (4 Replies)
Discussion started by: monika
4 Replies
4. Shell Programming and Scripting
Hi i have wriiten a script which fetches the data from text file, and saves in the output in a text file itself, but i want that the output should save in different columns.
I have the output like:
For Channel:response_time__24.txt
1547 data points
0.339
0.299
0.448
0.581
7.380
... (1 Reply)
Discussion started by: rohitkalia
1 Replies
5. UNIX for Advanced & Expert Users
hi-I want to write a UNIX Script which will fetch records from Oracle database.I want to store these records in a file under fields like email address,name and the transaction_id and then fetch these records from the file and send the email to individual users with their transaction ID details. (4 Replies)
Discussion started by: DeepSalwan
4 Replies
6. Shell Programming and Scripting
Hi all,
I have the following script, but are not too sure about the syntax to complete the script.
In essence, the script must connect to a SFTP server at a client site with username and password located in a file on my server.
Then change to the appropriate directory.
Pull the data to the... (1 Reply)
Discussion started by: codenjanod
1 Replies
7. Shell Programming and Scripting
I have the following:
HH:MM:SS
I want to use either % or # sign to remove :SS can somebody please provide me an example. I know how to do this in awk, but awk is too much
overhead for something this simple since I will be doing this in a loop a lot of times.
Thanks in advance to all... (2 Replies)
Discussion started by: BeefStu
2 Replies
8. Shell Programming and Scripting
Hi,
I have a file which consists of two columns but the first one can be varying in length like
123456789 0abcd
123456789 0abcd
4015 0 0abcd
5000 0abcd
I want to go through the file reading each line, count the number of characters in the first column and delete... (2 Replies)
Discussion started by: swasid
2 Replies
9. Shell Programming and Scripting
Hi Friends,
I have a file1 as below
file1.txt
100000.||1925-01-10|00:00|1862SHERMA NAVE#1SE.||EVTON|IL|60201||22509.|BDSS|62007|2639.|26670
100001.||1935-01-10|00:00|1862NEW . YRK NO.||EVTON|IL|60201||22509.|BDSS|62007|2639.|26670.
100002.||1965-01-10|00:00|1862 IND . INC,CL... (6 Replies)
Discussion started by: i150371485
6 Replies
10. Shell Programming and Scripting
We have the data looks like below in a log file.
I want to generat files based on the string between two hash(#) symbol like below
Source:
#ext1#test1.tale2 drop
#ext1#test11.tale21 drop
#ext1#test123.tale21 drop
#ext2#test1.tale21 drop
#ext2#test12.tale21 drop
#ext3#test11.tale21 drop... (5 Replies)
Discussion started by: Sanjeev G
5 Replies
LEARN ABOUT DEBIAN
stag-selectall_xml
SELECTALL_XML(1p) User Contributed Perl Documentation SELECTALL_XML(1p)
NAME
stag-selectall_xml - Query all elements from database with an XML output
SYNOPSIS
stag-selectall_xml [-d <dbi>] [-f file of sql] [-nesting|n <nesting>] SQL
DESCRIPTION
This script will query a database using either SQL provided by the script user, or using an SQL templates; the query results will be turned
into XML using the DBIx::DBStag module. The nesting of the XML can be controlled by the DBStag SQL extension "USE NESTING..."
EXAMPLES
stag-selectall_xml -d "dbi:Pg:dbname=mydb;host=localhost"
"SELECT * FROM a NATURAL JOIN b"
TEMPLATES
A parameterized SQL template (canned query) can be used instead of specifying the full SQL
For example:
stag-selectall_xml -d genedb /genedb-gene gene_symbol=Adh
Or:
stag-selectall_xml -d genedb /genedb-gene Adh
Or:
stag-selectall_xml -d genedb /genedb-gene gene_symbol@=Adh,dpp,bam,indy
A template is indicated by the syntactic shorthand of using a slash to precede the template name; in this case the template is called
genedb-gene. the -t option can also be used.
All the remaining arguments are passed in as SQL template parameters. They can be passed in as either name=value pairs, or as a simple list
of arguments which get passed into the template in order
To use templates, you should have the environment variable DBSTAG_TEMPLATE_DIRS set. See DBIx::DBStag for details.
LISTING AVAILABLE TEMPLATES FOR A DB
stag-selectall_xml -d mydb -h
LISTING VARIABLES FOR A TEMPLATE
stag-selectall_xml /genedb-gene -h
ENVIRONMENT VARIABLES
DBSTAG_DBIMAP_FILE
A file containing configuration details for local databases
DBSTAG_TEMPLATE_DIRS
list of directories (separated by :s) to be searched when templates are requested
COMMAND LINE ARGUMENTS
-h|help
shows this page if no other arguments are given
if a template is specified, gives template details
if a db is specified, lists templates for that db
use in conjunction with -v for full descriptions
-d|dbname DBNAME
this is either a full DBI locator string (eg dbi:Pg:dbname=mydb;host=localhost) or it can also be a shortened "nickname", which is then
looked up in the file pointed at by the environment variable DBSTAG_DBIMAP_FILE
-u|user USER
database user identity
-p|password PASS
database password
-f|file SQLFILE
this is a path to a file containing SQL that will be executed, as an alternative to writing the SQL on the command line
-n|nesting NESTING-EXPRESSIONS
a bracketed expression indicating how to the resulting objects/XML should be nested. See DBIx::DBStag for details.
-t|template TEMPLATE-NAME
the name of a template; see above
-wh|where WHERE-CLAUSE
used to override the WHERE clause of the query; useful for combining with templates
You can append to an existing where clause by using the prefix +
-s|select SELECT-COLS
used to override the SELECT clause of the query; useful for combining with templates
-rows
sometimes it is preferable to return the results as a table rather than xml or a similar nested structure. specifying -rows will fetch
a table, one line per row, and columns separated by tabs
-pre SQL
a piece of SQL is that is executed immediately before the main query; e.g.:
-pre "SET search_path=myschema,public"
-o|out FILE
a file to output the results to
-w|writer WRITER
writer class; can be any perl class, or one of these
xml [default]
sxpr
lisp S-Expressions
itext
indented text
-color
shows results in color (sxpr and itext only)
-show
will show the parse of the SQL statement
perl v5.12.4 2011-10-14 SELECTALL_XML(1p)