08-28-2010
Unfortunately I have no data base magic in my head. I don't work with them and that is why I used "database_command" in place of some real db interface. I'm sure there is some 'send-sql' or similar command line interface depending on the database you are using, but I have no experience to even start to point you in the right direction.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am writing a ksh script which will use sqlplus to run a sql and pass 2 variables as the SQL request. In the ksh script, I have 2 variables which are $min_snap and $max_snap holding 2 different numbers.
Inside the same script, I am using SQLPLUS to run an Oracle SQL script,... (6 Replies)
Discussion started by: rwunwla
6 Replies
2. Shell Programming and Scripting
I need a way to grep for a string in a file and if it finds it, to print set a variable to "Yes", if it doesn't find the string in a file to set the variable to "No". I plan on using these variables to print a table that lists whether the string was found or not.
For example
print "File ... (2 Replies)
Discussion started by: stepnkev
2 Replies
3. Shell Programming and Scripting
Ok, So up front I'm going to say that I'm a very elementary scripter, and I tend to use tools I don't fully understand, but I shotgun at something until I can get it to work...that said, I can't for the life of me understand why I can't get this to go down the way I want it to.
The goal:
-to... (6 Replies)
Discussion started by: DeCoTwc
6 Replies
4. Shell Programming and Scripting
Hi,
I need to compare two variables using if condition and i am not sure if am right or wrong. My code is like :
if
then
echo "new file"
else
echo "old file and remove it"
fi
where both variables contain time : filetime contains the time when a file... (2 Replies)
Discussion started by: manmeet
2 Replies
5. Shell Programming and Scripting
Hi all,
I'm trying to run an sql inside a loop which looks like this
#!bin/ksh
while IFS=, read var1 var2
do
sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} << EOF
insert into ${TABLE}
(
appt_date
)
values
(
'${var1 }'
);
... (6 Replies)
Discussion started by: ryukishin_17
6 Replies
6. Shell Programming and Scripting
Hi Unix Gurus,
I am a newb. I am creating a script which will use an input file. This input file can have 1 or more than 1 DML staments like INSERT/DELETE/UPDATE.
I have to execute these statements using my script but before execution of these DML statements, I need to check the count for... (17 Replies)
Discussion started by: ustechie
17 Replies
7. Shell Programming and Scripting
Hi,
I am new to Shell Scripting, and I need to create nicknames for 600 tables in db2. I have the file names in a text file and i have to pass these table names to a shell script create nicknames in db2. Can some one please help me in this regard. (1 Reply)
Discussion started by: kamalanaatha
1 Replies
8. Shell Programming and Scripting
I'm trying to create a ksh script that will ask the user for the port number. $PORT1 is the variable I want to use that will contain whatever numbers the user inputs. The script would edit ports.txt file, search and delete "./serv 110.1.0.1.$PORT1 200;=3" .
So if the user types 50243 then the... (5 Replies)
Discussion started by: seekryts15
5 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I am working on kernel parameters, want to check values under /proc/sys/kernel
below I tried for kernel.sem
SEMMNS: 4096 cat /proc/sys/kernel/sem | awk '{print $2}'
awk '{ if ($2 < 33000) print }' /proc/sys/kernel/sem |awk '{print $2}'
32000
The above... (7 Replies)
Discussion started by: stew
7 Replies
10. Shell Programming and Scripting
I'm able to read & print an array in varaible called "filelist"
I need to pass this array variable to a function called verify() and then read and loop through the passed array inside the function.
Unfortunately it does not print the entire array from inside the funstion's loop.
#/bin/ksh... (5 Replies)
Discussion started by: mohtashims
5 Replies
LEARN ABOUT DEBIAN
dbix::class::schema::loader::dbi::interbase
DBIx::Class::Schema::Loader::DBI::InterBase(3pm) User Contributed Perl Documentation DBIx::Class::Schema::Loader::DBI::InterBase(3pm)
NAME
DBIx::Class::Schema::Loader::DBI::InterBase - DBIx::Class::Schema::Loader::DBI Firebird Implementation.
DESCRIPTION
See DBIx::Class::Schema::Loader and DBIx::Class::Schema::Loader::Base.
COLUMN NAME CASE ISSUES
By default column names from unquoted DDL will be generated in lowercase, for consistency with other backends.
Set the preserve_case option to true if you would like to have column names in the internal case, which is uppercase for DDL that uses
unquoted identifiers.
Do not use quoting (the quote_char option in connect_info when in the default "preserve_case => 0" mode.
Be careful to also not use any SQL reserved words in your DDL.
This will generate lowercase column names (as opposed to the actual uppercase names) in your Result classes that will only work with
quoting off.
Mixed-case table and column names will be ignored when this option is on and will not work with quoting turned off.
SEE ALSO
DBIx::Class::Schema::Loader, DBIx::Class::Schema::Loader::Base, DBIx::Class::Schema::Loader::DBI
AUTHOR
See "AUTHOR" in DBIx::Class::Schema::Loader and "CONTRIBUTORS" in DBIx::Class::Schema::Loader.
LICENSE
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-06-08 DBIx::Class::Schema::Loader::DBI::InterBase(3pm)