You can't use shell variables ($app_id) in your SQL file. It's an SQL file, not a shell script.
I would suggest that you either include the SQL directly inside the SQLPlus in your shell script, or you substitute the value in your SQL file before passing it (@) into SQLPlus.
i.e.
Code:
sed "s/\$app_id/$app_id/" test.sql > test2.sql
sqlplus .... @test2
...
I know htis isnt exactly unix.... but hopefully someone can help me or direct me someplace to get help.
I can run sql queries in scripts against my informix db using:
dbaccess mydb myquery.sql >> sql.output
I need to write my script to select based on todays date. Its very... (5 Replies)
Hi All,
I need to select one column from a table based upon the passed in parameter.
I tried this:
sqlplus -silent $MISP_USER << EOF
set feedback off;
set verify off;
set sqlprompt ""
SELECT mail_flag
FROM dailyjobs
WHERE job_name = '$1';
exit 0
EOF
exit... (1 Reply)
hi all,
i am experiencing an error which i think an incorrect syntax for the where clause passing a variable was given. under is my code.
sqlplus -s ${USERNAME}/${PASSWORD}@${SID} << END1 >> $LOGFILE
whenever sqlerror exit
set serveroutput on size 1000000
declare
l_rc ... (0 Replies)
Hi,
I have a unix varaible called as account which hold values which i want to use in a PL/SQL block in a shell script.
This variable value is being used in multiple places in the PL/SQL block and i get an erroe whenenevr is use this varaible with $prompt.
Help Urgently (1 Reply)
Hi All
I have a requirement where in I am stuck. There is a shell script that is being developed by me. It consist of the sql stmt also. I need to export a variable called HOMEPAGE with a value say www.abc.com. and then use this $HOMEPAGE variable in the sql stmt. My ultimate aim is to fetch all... (1 Reply)
Can i do this
Say one command
sed 's/:*/ /g' $summf
is returning
C1234
C2345
C3434
some no of rows, now this ouput i have to insert it into a DB table
how do i do this?? (2 Replies)
Hello,
I have a script to get the information from database, however, it's look like the loop is not work, can someone help? :confused:
echo Input file list to check:
read filelist
for file in 'cat $filelist.txt'
do
echo "select FILENAME from FILE_TABLE where filename like '${file}'%;" >>... (9 Replies)
Hi,
I have the following basic script. However, the statement (line 5) is not work. The output data is not able to set my request format a30. Any advise? :mad:
echo " Column filename format a30"|sqlplus4
echo Input file list to check:
read filelist
for file in `cat $filelist.txt`
do... (1 Reply)
I have a sql statement , i need to assign to a variable in Unix
sel count(*) AS num_files from TABLE_A;
i need to use "num_files" in unix statements. let me know how to assign unix variable to above num_files (1 Reply)
Greetings Experts,
I am on AIX using ksh. Created a unix script which generates the CREATE OR REPLACE VIEW ... and GRANT .. statements, which are placed in a single .txt file. Now I need to execute the contents in the file (there are around 300 view creation and grant statements) in Oracle and... (4 Replies)
Discussion started by: chill3chee
4 Replies
LEARN ABOUT DEBIAN
sql::translator::producer::ttschema
SQL::Translator::Producer::TTSchema(3pm) User Contributed Perl Documentation SQL::Translator::Producer::TTSchema(3pm)NAME
SQL::Translator::Producer::TTSchema -
Produces output using the Template Toolkit from a SQL schema
SYNOPSIS
use SQL::Translator;
my $translator = SQL::Translator->new(
from => 'MySQL',
filename => 'foo_schema.sql',
to => 'TTSchema',
producer_args => {
ttfile => 'foo_template.tt', # Template file to use
# Extra template variables
ttargs => {
author => "Mr Foo",
},
# Template config options
ttargs => {
INCLUDE_PATH => '/foo/templates',
},
},
);
print $translator->translate;
DESCRIPTION
Produces schema output using a given Template Tookit template.
It needs one additional producer_arg of "ttfile" which is the file name of the template to use. This template will be passed a variable
called "schema", which is the "SQL::Translator::Producer::Schema" object created by the parser. You can then use it to walk the schema via
the methods documented in that module.
Here's a brief example of what the template could look like:
database: [% schema.database %]
tables:
[% FOREACH table = schema.get_tables %]
[% table.name %]
================
[% FOREACH field = table.get_fields %]
[% field.name %] [% field.data_type %]([% field.size %])
[% END -%]
[% END %]
See t/data/template/basic.tt for a more complete example.
The template will also get the set of extra variables given as a hashref via the "tt_vars" producer arg.
You can set any of the options used to initiallize the Template object by adding a tt_conf producer_arg. See Template Toolkit docs for
details of the options. (Note that the old style of passing this config directly in the producer args has been deprecated).
$translator = SQL::Translator->new(
to => 'TT',
producer_args => {
ttfile => 'foo_template.tt',
ttargs => {},
tt_conf = {
INCLUDE_PATH => '/foo/templates/tt',
INTERPOLATE => 1,
}
},
);
You can use this producer to create any type of text output you like, even using it to create your own versions of what the other producers
make. For example, you could create a template that translates the schema into MySQL's syntax, your own HTML documentation, your own
Class::DBI classes (or some other code) -- the opportunities are limitless!
Producer Args
ttfile
The template file to generate the output with.
tt_vars
A hash ref of extra variables you want to add to the template.
tt_conf
A hash ref of configuration options to pass to the Template object's constructor.
AUTHOR
Mark Addison <grommit@users.sourceforge.net>.
TODO
More template vars? e.g. [% tables %] as a shortcut for [% schema.get_tables %].
SEE ALSO
SQL::Translator.
perl v5.14.2 2012-01-18 SQL::Translator::Producer::TTSchema(3pm)