I'm facing an emergency situation, wherein I have to provide limited support to a Sybase DB temporarily as the DBA was fired. There is an urgent need of adding to users to the database. After some time on google, I was able to gather the below information on the database setup
I need to add a two users one similar to ascent_app and another similar to webascent. I have NO knowledge of sybase. Any help would be highly appreciated.
I am writing a shell script that verifies if a device is created on wrong mounts
1> sp_helpdevice
2> go | awk '{print $2}' | grep database | grep -v `df -k | grep /dev/dsk | awk '{print $6}'`
So if things are ok, the output should return nothing
If the result gives 1 or more entry, then... (1 Reply)
Hi,
Can any one please suggest me which version of Sybase 15.x I need to dowload for installing on my laptop(Dell Inspiron 1525) having Ubuntu8.1?
Thanks & Regards,
Siba Sankar Nayak (0 Replies)
hi,
I'd like to connect to a Sybase ASE 12 through a a graphic user interface (GUI) that run on windows and solaris10, because i need to do some querys.
The database is running on solaris 10.
I'm not an expert using databases, but i know how to use some SQL commands through command line... (3 Replies)
Hi,
How do i check if Sybase is installed on aix..The sybase guy is doing remote installation and i need to check if he has installed sybase or not.
ive tried the following approaches.
#lslpp -L "*Sybase*" # tried other strings like "*ybase*" , "*base*"
#lslpp -ha |grep syb # tried... (4 Replies)
I am trying to bcp in using sybase::bcp perl module. I can find we can give user, pwd and server name in the parameters.
How can I give database and table name? (1 Reply)
This is more a database problem than a shell one, but we have a problem affecting our scripts, so I'm stretching the limits a bit! ;)
We're in the process of migrating our application and a large number of associated scripts from Sybase 12.5.4 to Sybase 15. Scripts using 'isql' and 'bcp' include... (1 Reply)
I have requirement to connect to different sybase server's and store the data into flat file and load into oracle using sqlloader
for each day drop the table and re create it and load the data based on business date as parameter which was taking from parameter file.Any help on this should be... (0 Replies)
Discussion started by: mohan705
0 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)