07-26-2007
Please do not open multiple threads for the same request
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Does anyone know how I can write a script file that reads 15 numbers and can find the average, maximum and minimum of the 15 numbers.
I'm new to UNIX 1 month into it, and (no) this is not for homework.
I'm reading UNIX unbounded and trying the practice questions and I've been working on... (19 Replies)
Discussion started by: lanboy_2005
19 Replies
2. UNIX for Advanced & Expert Users
I want to collect the database tables(Ex: Emp,Sal,Bonus...etc)
in a file & give this file at the command prompt, when prompted for the tables list at command prompt. How can i do that ?
Ex:- Import jason/jason1 tables=emp,sal,bonus log=j1.log
i want to change this into
Ex:- Import... (3 Replies)
Discussion started by: dreams5617
3 Replies
3. Shell Programming and Scripting
Hi,
At the moment i have a script where it asks the user if they want to create a file and what to put in the file. The problem is when the script is run the user inputs the information, though when they are finished typing what they want to be in the file there is no way for the program to know... (3 Replies)
Discussion started by: Jaken
3 Replies
4. Shell Programming and Scripting
Hi, Can some some give ideas/help
how to write to a file.
i need to create a calender from the inputs given on command line i.e frm date,todate & -i is interval is given to write to a file.
-i is 1 then a calender is daily , if -i =2 then calender is alternate day
e.g
$1 ... (0 Replies)
Discussion started by: innocent
0 Replies
5. Programming
The attached file, credits.php, is part of our new (experimental) banking / credits system for this site.
I added a field bankfee in credits_transactions but it is not writing to the database (no PHP error).
Can someone take a look at the attached PHP file and see if they can find out why... (4 Replies)
Discussion started by: Neo
4 Replies
6. Shell Programming and Scripting
Hi All,
Please help me in writing data to a file in one row.
In database there is a column which contains large data which does not fit in the file in one row. The column contains list of paths. I want to write these paths to a file in one row.
Please find the code below writes :
... (2 Replies)
Discussion started by: rajeshorpu
2 Replies
7. Shell Programming and Scripting
I am trying to prompt the user using tput command to read the information ( 5 last names, first names and grades) from the keyboard. Save the data in a file called student.txt. Sort the file by last name and display it on the screen
My pseudocode is as follow:
Pseudocode:
Initialize... (1 Reply)
Discussion started by: jestaton
1 Replies
8. Shell Programming and Scripting
Hi all,
I need help in writing a script to edit a file
Here is the sample of my file
abc xxx 123
456
789
045
def yyy 987
678
098
cdf zzz 435
543
jhg vvv 987
765 (2 Replies)
Discussion started by: leo.maveriick
2 Replies
9. Shell Programming and Scripting
I have several bash scripts that write to an SQLite3 database at the same time. At some occasion the database returns: SQL error: database is locked.
How would be the best way, to make a process to wait until the data base is 'free' again. I tried:
sqlite3 test.db ".timeout 1000; update....."... (2 Replies)
Discussion started by: creamcheese
2 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I have 1000 files names data1.txt through data1000.txt inside a folder. I want to write a script that will take each first line from the files and write them as output into a new file. How do I go about doing that? Thanks! (2 Replies)
Discussion started by: evelibertine
2 Replies
LEARN ABOUT DEBIAN
defncopy
defncopy(1) FreeTDS Utilities defncopy(1)
NAME
defncopy - extract procedures and views from a Microsoft server.
SYNOPSIS
defncopy [-U username] [-P password] [-S server] [-D database]
[-i input_file] [-o output_file] [-v]
[owner.]object_name [[owner.]object_name...]
DESCRIPTION
defncopy is a utility program distributed with FreeTDS. It replaces a similar program of the same name distributed by Sybase.
defncopy reads the text of a stored procedure or view, and writes a script suitable for recreating the procedure or view. For tables, it
reads the output of sp_help and constructs a CREATE TABLE statement, complete with CREATE INDEX, too.
OBJECTS
owner is optional if you or the database owner is the owner of the procedure/view being copied.
object_name
is the name of the system object you wish to extract.
OPTIONS
-U username
database server login name.
-P password
database server password.
-S server
database server to which to connect.
-D database
database to use. Optional if the procedure/view being extracted is in your default database.
-i input_file
a script to apply to the database. Not currently implemented.
-o output_file
a file to hold the script, defaults to standard output.
-v Show version information and copyright notice.
NOTES
defncopy is a filter; it reads from standard input, writes to standard output, and writes errors to standard error. The -i and -o options
override these, of course.
defncopy makes use of the db-lib API provided by FreeTDS. This API is of course also available to application developers.
EXIT STATUS
defncopy exits 0 on success, and >0 if the server cannot process the query.
defncopy will report any errors returned by the server, but will continue processing.
HISTORY
defncopy first appeared in FreeTDS 0.63.
AUTHORS
The defncopy utility was written by James K. Lowden <jklowden@schemamania.org>
BUGS
Works only with Microsoft servers and ancient Sybase servers.
Does not create primary keys.
Many options are defined by Sybase that this version does not implement. Feel free to correct this situation.
In theory, defncopy could apply/produce DDL for any system object, but at present only tables, procedures and views are supported, and only
for extraction.
doc 13 November 2011 defncopy(1)