I need help in creating script for "User password reset in database" by logging into database from linux server and resetting the user password.
Could you please provide the script for this task?
Steps are given below.
1. Login into database from server
2. Execute the below command in database to reset password.
Regards,
Maddy
Last edited by rbatte1; 06-13-2017 at 12:51 PM..
Reason: Added CODE tags
I have a file contains
TASK gsnmpproxy {
CommandLine = $SMCHOME/bin/gsnmpProxy.exe
}
TASK gsnmpdbgui {
CommandLine = $SMCHOME/bin/gsnmpdbgui.exe
I would like to comment and than uncomment specific task eg TASK gsnmpproxy
Pls suggest how to do in shell script (9 Replies)
I have an task definition listing xml file that contains a list of tasks such as
<TASKLIST
<TASK definition="Completion date" id="Taskname1" Some other
<CODE name="Code12"
<Parameter pname="Dog" input="5.6" units="feet" etc /Parameter>
<Parameter... (3 Replies)
ksh $CODE/dis/scripts/IS_BTEQ_LZ_TABLE_AUDIT.sh
DIS_BTEQ LZ_DIS_LOAD_LOG_KEY > $CODE/dis/logs/lz_table_audit_`date '+%Y%m%d_%H%M%S'`.log 2>&1
Can some one tell me what the above script is doing?
As per my understanding we are executing the script and sending the output to a log file. The... (4 Replies)
Hello all..
i have few task to do on specific day ar per weekday or weekend...
for example i have 3 tasks:
task1
task2
task3
Now i need to create a shell script
If it is weekday it will change the status of these tasks as below
sendevent -E CHANGE_STATUS -s SUCCESS -J task1... (4 Replies)
input file's one set header is this,
-----------------------------------------------------
OUTPUT FROM ASCII FILE: CAST #1
-----------------------------------------------------
CC Cruise Latitude Longitude YYYY MM DD Time Cast #Levels
CA 8504 50.083 -144.883 1970 1 2... (6 Replies)
In following attached 748phy.xls file, fifth column is ST_Date, which contains time and dates in this format
22-11-2012 7:54:54 PM in single column
I want it to split in this format either 1st column 22/11/2012 and in second column 7:54:54 PM
Or like this in separate... (13 Replies)
I have an ETL process that triggers a shell script. This script picks the files created by the ETL process and does an SFTP. These are huge files. Due to infrastructure limitations, we need to trigger the actual SFTP part only during the 2nd, 16th, 31st and 46th minute of an hour. Please let me... (2 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:
Write a script checkFiles.sh that takes an arbitrary number of file paths from the command line and carries ... (5 Replies)
Hello
I have a problem with use bash script in windows task.
If I use script by cygwin it's working well.
If I use it by Windows task I'm get error
Error :
ERROR 2 (HY000) at line 2: File '.\xxx.csv' not found (Errcode: 2)
Code Line :
load data local infile './xxx.csv' REPLACE into... (16 Replies)
Discussion started by: karp
16 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)