03-20-2012
@happyv: We won't be able to help unless you provide more inputs.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I am trying to create sql statements from a file, but I have a problem with ':
This is what I do:
cat filex.txt | awk -F: '{print $1,"A","and personnavn like",$5}' | sed -e "s/^/select bruker.brukernavn, person.personnavn from bruker, person where brukernavn like '/" -e "s/$/' and... (2 Replies)
Discussion started by: hannem
2 Replies
2. Shell Programming and Scripting
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)
Discussion started by: ganga.dharan
1 Replies
3. Shell Programming and Scripting
Hi there
I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this
SN=123456
n=server1
m=x4140
sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';"
echo $sql |/usr/sfw/bin/mysql -h... (4 Replies)
Discussion started by: hcclnoodles
4 Replies
4. 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
5. Shell Programming and Scripting
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)
Discussion started by: depakjan
2 Replies
6. Shell Programming and Scripting
Hi Guys..
need some urgent help... I am stuck in something badly
I need to write a script which would read a sql statement (which might be a join/inner join/select/sub select etc. )
I need to read that sql statement ... and in the output I want all the table names and columns (doesn't... (4 Replies)
Discussion started by: freakygs
4 Replies
7. UNIX for Dummies Questions & Answers
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)
Discussion started by: happyv
1 Replies
8. Shell Programming and Scripting
The following is my script :
#!/bin/bash
echo "please give app_instance_id"
read app_instance_id
echo "id is $app_instance_id"
export app_id=app_instance_id
sqlplus -s nnviewer/lookup@//nasolora008.enterprisenet.org:1521/LOAD3 @test.sql<<EOF
SPOOL /home/tibco/MCH/Data/qa/raak/name.xls... (4 Replies)
Discussion started by: raakeshr
4 Replies
9. Shell Programming and Scripting
Table TAB1 contains following example data (its a tree sitting in table data format & its driven based CHILD & PARENT column pick the RULE condition to generate the below SQL:
CHILD PARENT SS MID MNM VNM RULE FLG
1 ? S1 ? ? V1 rule004 I
2 1 S1 ? ? V1 0 Z
3 1 S1 ? ? V1 1 Z ... (6 Replies)
Discussion started by: gksenthilkumar
6 Replies
10. Shell Programming and Scripting
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
buildtorrent
BUILDTORRENT(1) User Commands BUILDTORRENT(1)
NAME
buildtorrent - a torrent file creation program.
SYNOPSIS
buildtorrent [OPTIONS] -a announceurl input output
buildtorrent [OPTIONS] -a announceurl -f filelist -n name output
DESCRIPTION
buildtorrent is a torrent file creation program. Given an announce url and an input file or directory, buildtorrent generates an output
.torrent file that can be used by torrent clients.
OPTIONS
-a announce, --announce=url
Announce URL (required).
-f filelist, --filelist=filelist
A text file (or - for standard input) containing a list of files to add to the output torrent file, together with the path to use
inside the torrent. One file is given per line, use / as path separator for the torrent path, use | to separate the filesystem path
from the torrent path. Backslash can be used to escape newlines and | characters inside names. For example:
/data/files/linux.iso|bin/linux.iso
/data/files/linux.txt|doc/linux.txt
Using this option requires that the --name option be used.
-n name, --name=name
Specify the name for the torrent. Usage of this option is required when the --filelist option is used, in which case it specifies
the name of the torrent directory. Usage without a file list overrides the name of the directory or file given on the command line.
-A announces, --announcelist=announces
Additional announce URL list. Use , to separate outer level lists, and | to separate inner level items; for example:
a,b1|b2,c
-w webseeds, --webseeds=webseeds
Additional WebSeed URL list. Use , to separate items; for example:
a,b,c
-l length, --piecelength=length
Piece length in bytes (default 262144).
-L length, --piecesize=size
Use 2^size as piece length (default 18) (overrides -l ).
-c comment, --comment=comment
User comment (omitted by default).
-p private, --private=private
Private flag (either 0 or 1).
-D, --nodate
Omit the creation date field.
-C, --nocreator
Omit the created by field.
-m, --md5sum
Add an md5sum field for each file.
-s, --show
Show generated torrent structure.
-S, --showall
Show generated torrent structure, including piece data.
-q, --quiet
Quiet operation with reduced output.
-V, --version
Show the version string.
-h, --help
Show a help screen with brief usage information.
AUTHORS
Claude Heiland-Allen (claudiusmaximus@goto10.org)
SEE ALSO
createtorrent(1), mktorrent(1)
http://wiki.theory.org/BitTorrentSpecification
http://bittorrent.org/beps/bep_0012.html
http://www.getright.com/seedtorrent.html
0.8 January 2010 BUILDTORRENT(1)