09-28-2010
The point is we dont know how the file is created, all we know is you use an SQL script we have no idea what it does without seeing it...
Last edited by vbe; 09-28-2010 at 01:12 PM..
Reason: typos
This User Gave Thanks to vbe For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
All,
I have a shell script which executes the below command
find $1 -name $2 -print > ${Backup}/FileFind.txt
I have $2 sometimes coming with the below values.
.*
When I go to the log after the execution of the script, .* gets expanded to .developer.adm instead of searching for all... (5 Replies)
Discussion started by: njoshi
5 Replies
2. Shell Programming and Scripting
Hi,
I have a script that at one point prints to a file as follows:
printf -- $2 > ~/.mydir/$1
The idea is to print to a hidden directory .mydir in my home directory. I've already sanitized the inputs and $1 is in the format path1/path2/filename and $2 is some user input.
When I run this... (2 Replies)
Discussion started by: Rledley
2 Replies
3. UNIX for Dummies Questions & Answers
Hi there,
Can anyone explain me the following behavior?
hfserver:~# ls -l /home/cronlogs/mysqldump*
-rw-r--r-- 1 root root 10658464 2009-01-18 03:00 /home/cronlogs/mysqldump_20090118030002
-rw-r--r-- 1 root root 10651035 2009-01-19 03:00 /home/cronlogs/mysqldump_20090119030001
-rw-r--r-- 1... (4 Replies)
Discussion started by: chebarbudo
4 Replies
4. Shell Programming and Scripting
I have a script that takes an option for server pools to run the script against. The option is given as a comma separated list (ie, -p 201,204,301).
I'm using eval and brace expansion to get those pool numbers into an array. It works fine unless only 1 pool number is given. Here's the code:
... (5 Replies)
Discussion started by: mglenney
5 Replies
5. UNIX for Dummies Questions & Answers
Hi All,
I am facing issues converting white spaces and tabs together in a file I am reading. Here is the command I am trying:
tr -s ' '@ | sort -t@ +1n filename
I guess the problem is that it is not converting the tabs to another delimiter. Also, I am supposed to accomplish this only using... (5 Replies)
Discussion started by: sh_kk
5 Replies
6. Shell Programming and Scripting
Hi ,
could anyone help me out with this problem.
sample.txt has this content :
u001- this is used for project1 ||
u002- this is used for p2|| not to be printed
u003- this is used
for project3 ||
u004- this is
used for p4 ||
u005- this is used for project5 ||
u006- this is used for p6... (9 Replies)
Discussion started by: Balaji PK
9 Replies
7. UNIX for Dummies Questions & Answers
Hi
I have an input file which have random file in between.I have to manipulate each line and replace the character from position 5-10 with XXXXXX.
But when I am writing this to on output file the tabs in between gets converted to normal space.
Input file :
14207531131040896334R108 ... (4 Replies)
Discussion started by: akashtcs
4 Replies
8. UNIX for Dummies Questions & Answers
I have a bunch of files which I need to transfer to another location... and some of these I need to skip.
For e.g. let us say the files are:
cust_abc.dat
cust_xyz.dat
cust_def.dat
and I only want to move the first two.
I want to do something like:
cp cust_.dat <target>
... (1 Reply)
Discussion started by: jawsnnn
1 Replies
9. Shell Programming and Scripting
(Using Bash 4.4)
When I write something like dir="~/dox"
ls $dir then I get the message that the directory '~/docs' does not exist. I understand that the tilde is not expanded at the time of the above assignment because of the quotes. But why is it not expanded at the time when the ls command is... (2 Replies)
Discussion started by: Ralph
2 Replies
10. Shell Programming and Scripting
Hello All,
Could you please do help me here as I would like to perform parameter expansion in shell over a parameter expansion.
Let's say I have following variable.
path="/var/talend/nat/cdc"
Now to get only nat I could do following.
path1="${path%/*}"
path1="${path1##*/}"
Here... (8 Replies)
Discussion started by: RavinderSingh13
8 Replies
LEARN ABOUT DEBIAN
grass-sqlite
grass-sqlite(1grass) Grass User's Manual grass-sqlite(1grass)
NAME
grass-sqlite - SQLite driver
SQLite driver SQLite driver in GRASS
Creating a SQLite database
GRASS is automatically creating the SQLite database if it is not yet existing when the first table is created in the SQLite database. It is
sufficient to define the connection (see next step).
Connecting GRASS to SQLite
The database name 'sqlite.db' is at user's choice. Also the file storage location can be freely chosen. If the database does not exist, it
will be automatically created when database content is created:
# example for storing DB in mapset directory (keep single quotes):
db.connect driver=sqlite database='$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db'
db.connect -p
Supported SQL commands
All SQL commands supported by SQLite (for limitations, see SQLite help page: SQL As Understood By SQLite and Unsupported SQL).
Operators available in conditions
All SQL operators supported by SQLite.
Browsing table data in DB
A convenient SQLite front-end is sqlitebrowser. To open a DB file stored within the current mapset, the following way is suggested (corre-
sponds to above database connection):
eval `g.gisenv`
# use double quotes:
sqlitebrowser "$GISDBASE/$LOCATION_NAME/$MAPSET"/sqlite.db
SEE ALSO
db.connect, db.execute, db.select
SQL support in GRASS GIS
SQLite web site, SQLite manual, sqlite - Management Tools
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
Help Index
GRASS 6.4.2 grass-sqlite(1grass)