Search Results

I have this script that does what I want. This reports on uses one
SQL query. What I need to know is how to how to have 3 queries
in the script were queries 1 and 2 create tables that are used ...

SQL QUERY 1: Ceates - SYBASE_EXPIRED_LOGINS Table
use master
go
set nocount on
declare @xerox_emp varchar
select @xerox_emp = "N"
declare @swexpire int
declare @LoginExpInt int
...

I have a test file that I want to read and insert only certain lines into the
the table based on a filter.

1. Rread the log file 12 Hours back Getdate() -12 Hours
2. Extract the following...

How to run multiple Queries in a ksh Script
I have a KSH script that has one SQL Query and generates and emails output of the query in HTML format. I want to change the script so that it has three...

I have a ksh script that does the following



1. Script executes and creates an output file from a sql query
2. That output file is an input file to the script
3. generates an html file to...

This file is not formatted with one record(field) on each line
in some instances the more than one field is on the same line
Example: dbt_verstimestamp= May 15 2012 3:37PM dbt_dbname=TestDB
...

How would I go about retrieving all the fields that begin with
dbt_xxxxxxxx= in the file and generating a file with every field
listed.

I have a log file that I want to extract the field name and the field value
and write them to a text file for importation it a database table for reporting purposes.

How can I extract the...

#!/usr/bin/ksh
awk -f backup_check.awk ACSTEST_BS.log > Backup_Check.rpt
exit 0

Overview:
I have an AWK program that parses thru a database backup
server log file and outputs ths following parameters
SRNO DATE : TIME SIZE IN(KB) DATABASE NAME DUMP TYPE
1 May 16 2012:...