I recently started as an intern and my manager wanted to see how well I would handle Korn Bourne shell scripting without any prior experience, I have prior programming experience but I keep running into syntax errors with AWK. Please take a look at my simple code and tell me what stupid mistake... (6 Replies)
All,
I have a shell script which parses the /var/adm/messages file for errors every 15 minutes as a cron job. The script runs at 01, 16, 31, and 46 minutes every hour. The problem is if the error is encountered any time during the beginning of hour I can get paged three times. I would like to... (2 Replies)
hey watsup guys
i am new in the shell script world. so i need help fom you guys, i have written these two codes and they both give the same errors( expr : syntax error).
Code 1 :
#! /bin/sh
# count1 appends an increment to a file 200 times
# note that a file called numbers must be... (5 Replies)
All,
Does it matter what perl verios your running when you get syntax errors?
on version 5.6.1 the code works fine, but on 5.8.0 the code gets errors?
#!/usr/bin/perl
#use strict;
#use warnings;
my $mess = 'messages';
my $mess1 = 'messages.1';
my $mess2 = 'messages.2';
my... (13 Replies)
Hi,
I am a newbie to PERL and working on a script. When running it I get a lot of compilation errors.
The actual command in the program (which is within a case structure) is given below
# This gives the actual count of inquires from a log file (It works fine when I type this on the... (2 Replies)
So I have a script that does a greater than or less than with a variable. My problem is that when I checked the script from the command line I was getting this error..
I am not really familiar with shell scripting. I am trying to get this script to work with conky so that it will do the... (8 Replies)
I have a shell script which select total count from a table and use its value in a if condition like below
connect_string="username/password@tnsname"
tot=`sqlplus -s $connect_string << EOF
set echo off
set feedback off
set head off
select count(*) from test_table;
EOF
`
if
then
echo... (2 Replies)
Original script written on CentOS 6.3 with GNU bash 4.1.2
Destination system is Solaris 9 with GNU bash 2.05 (not changeable by me)
I have a script written on the linux side but now we need to provide a version to another site that "doesn't like linux". I've been going through changing the ] or... (13 Replies)
Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted!
1. The problem statement, all variables and given/known data:
This script will analyse the channels.txt e registrations.txt and it will allow to mage the channels and the... (9 Replies)
Discussion started by: Demas
9 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)