02-06-2006
Thanks Zazzy you're a star.
I'll give this a try.
Cheers
Helen :-)
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
I am trying to do sftp a file from one server to another solaris server. Both are sftp enabled. I have generated the rsa key in local server and did a ftped the public key to the remote server and added that in the authorization keys file.
Then i try to run the below command using a... (2 Replies)
Discussion started by: sivaemn
2 Replies
2. Shell Programming and Scripting
I have to code sftp batch script connect to vendor, how I am going to make it passwordless interaction since I only receive identitykey file from vendor. Or am i missinging anything else? Sftp works fine that I do iit manually (not thru batch). (1 Reply)
Discussion started by: jaruwan
1 Replies
3. Shell Programming and Scripting
I am trying to automate an sftp command so that it does not stop and ask for the password each time
the calling shell script
#!/bin/ksh
sftp -b tst_1_batchfile.txt GLAXGBUPMPSOUT@204.90.134.116
the batchfile contents :
password XXXXXX
cd /GLAXGBUPMPSOUT/GSKENT/GLAXGF2FOPFF
put... (4 Replies)
Discussion started by: Shrabanti
4 Replies
4. Shell Programming and Scripting
I am working on a sftp batch script on a Solaris machine and I need to connect using password. This is not an issue when i do it manually but when I want to make this into a script, i find there are no options for password.
Can anyone suggest how I can do it with password? I know using keys is... (3 Replies)
Discussion started by: Leion
3 Replies
5. Programming
done for this. (4 Replies)
Discussion started by: leganti
4 Replies
6. Shell Programming and Scripting
Hello Guys,
I am writting a script which is SFTPing from Solaris to Windows.
I need to run a Batch script in SFTP session (ongoing) which will map a network drive and then transfer my files.
I can run the Batch script via SSH but not via SFTP and this mapping is limited to that SSH... (4 Replies)
Discussion started by: Deei
4 Replies
7. Shell Programming and Scripting
Hello,
I have a UNIX script to sftp batch processing. Here is my sftp command.
ftp -b toopc userid@sftp.hostname.com
In the file toopc I have the following commands:
mget *.csv
bye
This brings in all files with an extension of .csv
However, I need to only bring in files that
... (6 Replies)
Discussion started by: schlinzj
6 Replies
8. UNIX for Advanced & Expert Users
I need to run a test SFTP command in a batch mode and what I need to prompt my password after the sftp userid@hostname. I do not have have an ssh key exchanged between my server and the external server. I only have access to it as an sftp server. I must enter my password in my script. How do i... (2 Replies)
Discussion started by: mrn6430
2 Replies
9. Shell Programming and Scripting
Dear All,
I have a requirement where I have to SFTP or SCP a file in a batch script. Unfortunately, the destination server setup is such that it doesn't allow for shell command line login. So, I am not able to set up SSH keys. My source server is having issues with Expect. So, unable to use... (5 Replies)
Discussion started by: ss112233
5 Replies
10. Windows & DOS: Issues & Discussions
I have a windows batch file to connect from Server A (Windows) to Server B (UNIX) via sftp to get a file. The script is as below:
sftpg3 -oStrictHostKeyChecking=no -oIdentityFile=EAPIINSTADM_hostnameA ftpeapsg@hostnameB
lcd D:\APPBASE\EAPSG\GEMSSG
get GENUOBGW1 /sftp/ftphrssg/HRSSG/EAPSG
exit... (5 Replies)
Discussion started by: userguy
5 Replies
LEARN ABOUT DEBIAN
dbix::dbstag::sqltemplate
DBIx::DBStag::SQLTemplate(3pm) User Contributed Perl Documentation DBIx::DBStag::SQLTemplate(3pm)
NAME
DBIx::DBStag::SQLTemplate - A Template for an SQL query
SYNOPSIS
# find template by name
$template = $dbh->find_template("mydb-personq");
# execute this template, filling in the 'name' attribute
$xml = $dbh->selectall_xml(-template=>$template,
-bind=>{name => "fred"});
DESCRIPTION
A template represents a canned query that can be parameterized.
Templates are collected in directories (in future it will be possible to store them in files or in the db itself).
To tell DBStag where your templates are, you should set:
setenv DBSTAG_TEMPLATE_DIRS "$HOME/mytemplates:/data/bioconf/templates"
Your templates should end with the suffix .stg, otherwise they will not be picked up
You can name templates any way you like, but the standard way is to use 2 or 3 fields
SCHEMA-OBJECT
or
SCHEMA-OBJECT-QUALIFIERS
(with underscores used within fields)
A template file should contain at minimum some SQL; for example:
Example template 1
SELECT
studio.*,
movie.*,
star.*
FROM
studio NATURAL JOIN
movie NATURAL JOIN
movie_to_star NATURAL JOIN
star
WHERE
[movie.genre = &genre&] [star.lastname = &lastname&]
USE NESTING (set(studio(movie(star))))
Thats all! However, there are ways to make your template more useful
Example template 2
:SELECT
studio.*,
movie.*,
star.*
:FROM
studio NATURAL JOIN
movie NATURAL JOIN
movie_to_star NATURAL JOIN
star
:WHERE
[movie.genre = &genre&] [star.lastname = &lastname&]
:USE NESTING (set(studio(movie(star))))
//
schema: movie
desc: query for fetching movies
By including : at the beginning it makes it easier for parsers to assemble SQL (this is not necessary for DBStag however)
After the // you can add tag: value data.
You should set schema: if you want the template to be available to users of a db that conforms to that schema
GETTING A TEMPLATE
The DBIx::DBStag object gives various methods for fetching templates by name, by database or by schema
VARIABLES
WHERE clause variables in the template look like this
&foo&
variables are bound at query time
my $set = $dbh->selectall_stag(-template=>$t,
-bind=>["bar"]);
or
my $set = $dbh->selectall_stag(-template=>$t,
-bind=>{foo=>"bar"});
If the former is chosen, variables are bound from the bind list as they are found
OPTIONAL BLOCKS
WHERE [ foo = &foo& ]
If foo is not bound then the part between the square brackets is left out
Multiple option blocks are ANDed together
An option block need not contain a variable - if it contains no &variable& name it is automatically ANDed
BINDING OPERATORS
The operator can be bound at query time too
WHERE [ foo => &foo& ]
Will become either
WHERE foo = ?
or
WHERE foo LIKE ?
or
WHERE foo IN (f0, f1, ..., fn)
Depending on whether foo contains the % character, or if foo is bound to an ARRAY
METHODS
name
Usage - $name = $template->name
Returns - str
Args -
every template has a name that (should) uniquely identify it
desc
Usage - $desc = $template->desc
Returns - str
Args -
templates have optional descriptions
get_varnames
Usage - $varnames = $template->get_varnames
Returns - listref of strs
Args -
Returns the names of all variable used in this template
WEBSITE
<http://stag.sourceforge.net>
AUTHOR
Chris Mungall <cjm@fruitfly.org>
COPYRIGHT
Copyright (c) 2003 Chris Mungall
This module is free software. You may distribute this module under the same terms as perl itself
perl v5.12.4 2010-02-01 DBIx::DBStag::SQLTemplate(3pm)