Sybase Most Used Commands

I am in the process of putting my notes into web pages, please keep checking in later for more contents
home  Sybase IQ  SAP Hana 
rocket99 sybase
rocket99 sybase tsql
rocket99 sybase iq
rocket99

top   prev   next  

comment and continuation characters

comment /* .comment. */
Line continuation character '\'

exec( ' print "This is a pretty long string, but fortunately, \
we can use two lines for it !" ' )

top   prev   next  

isql

cd $SYBASE/$SYBASE_ASE/scripts
isql -Usa -PSecr3t -SSYBASE -iinstallpubs2 -e -oerrors.out
isql -S SYBASERAYS_SERVER_1 -U my_user -P my_pass -i /opt/sybase/ASE-15_0/scripts/installdbccdb

isql -Usa -PSecr3t -SSYBASE
isql -Usybtest -PSomePass -SSYBASE
isql -Usa -P -SSERVER
select @@version
go

select @@servername, db_name()
go

use pubs2
go
exec sp_changedbowner sybtest
go
sp_changedbowner loginame [, true ]
sp_changedbowner my_user_1


exec sp_password NULL, "Secr3t"
go


top   prev   next  

start and shutdown db instance

$SYBASE/$SYBASE_ASE/install/showserver (Unix only) - Displays running servers on the current host; 

startserver:
which SYBASE.sh
. SYBASE.sh
echo $SYBABE
cd $SYBASE/SYBASE_ASE/install 
startserver -f RUN_servername
startserver -f RUN_SYB_BACKUP

shutdown :
isql -Usa -PSecr3t -SSYBASE
1> shutdown
2> go

top   prev   next  

sp_help

sp_version

sp_help
go

sp_help table name
ddlgen utility

sp_helpdb
go
sp_helpdb db1
go

sp_spaceused
select name, type, crdate from sysobjects;
sp_helpserver [server name]; 
select * sysservers;

top   prev   next  

Sybase session or connection

variable: SESSION_USER

sp_who
kill

syb_quit () Causes ASE to terminate the current session.
select syb_quit().

tempdb_id ( [ spid ] )
Returns the database ID of the specified session's temporary database; 
without spid,for the current session.

top   prev   next  

sp_configure

sp_configure 'disable disk mirroring', 0
go
sp_configure for all parameters
sp_configure 'nondefault' for non-default parameters

sp_configure 'enable xml', { 0 | 1 } (dynamic)

sp_configure 'quoted identifier enhancements', { 0 | 1 }

sp_configure 'default character set id', charset_id (static)

select id, csid, name, description from master..syscharsets where type >= 2000;

sp_configure 'disable character set conversion', { 0 | 1 } (static

top   prev   next  

Interface File

# Interface File
$SYBASE/interfaces     unix
%SYBASE%\INI\SQL.INI   windows

top   prev   next  

bcp: logical export

bcp

top   prev   next  

backup and restore, recover

dump database @dbname to @fname2
dump tran @dbname to @fname1

backup db:
dump database pubs2 to "/mnt/backup/pubs2.bkp"
go
dump database db1 to "/dev/SYBASERAYS_SERVER_1/dumpfiles/dump1"
go

backup transaction log:
dump transaction database to "/mnt/backup/dbtrandump2003_08_27_T23_32.bkp"
go

-- or simply truncate it
1> dump transaction pubs2 with truncate_only
2> go

-- restore a user db
load database 
load transaction
online database

load database db1 from "/dev/SYBASERAYS_SERVER_1/dumpfiles/dump1"
go
online database db1
go

top   prev   next  

sybase ase permission

create login
sp_addlogin
sp_adduser
sp_addalias

sp_displaylogin [ 'login_name' ]

sp_password 
alter login.with passwd

sp_addlogin loginame, passwd [, defdb] [, deflanguage [, fullname]]]
sp_addlogin user1, password, @defdb = db1
go
sp_addlogin vyasab, Sunday01, NULL, NULL, "Abhisek Vyas"
go
sp_addlogin user2, password, db1, NULL, "user2"
go
exec sp_addlogin "sybtest", "SomePass"
go
sp_addlogin 'silveruser','silver','silvermaster'
go

sp_displaylogin [ 'login_name' ]
sp_modifylogin login_name, attribute, 'value'

drop login list_of_login_names [ with override ]
sp_droplogin login_name 

use silvermaster
go
sp_role 'grant','sa_role','silveruser'
go
sp_changedbowner silveruser
go
/* create a developer profile */
sp_addlogin 'jsmith','yankees','silvermaster'
go
use silvermaster
go
sp_addalias 'jsmith','dbo'
go
/* change jsmith password, note how SA/SSO pwd is required here */
sp_password 'sa_pwd','dodgers','jsmith'
go

# -------------------------
Every user is a member of the group "public" 
and can also be a member of one other group
Users remain in "public" even when they belong to another group

sp_addgroup grpname
sp_addgroup group1
go
# ------------------------
grant role role_granted [{, role_granted}...]to grantee [{, grantee}...]

grant role my_role_1 to my_user_1
go
grant role sso_role to my_role_role
go

revoke role role_name [{, role_name}...]from grantee [{, grantee}...]

# ------------------------

grant all on invoice to jsmith
go
grant select on invoice to wriker
go
grant update on invoice to wriker
go
revoke select on invoice from wriker
go
grant execute on proc_upd_invoice to jsmith
go

-- list privileges for each user

select u.name,v.name
from sysprotects p, master.dbo.spt_values v, sysusers u
where p.uid=u.uid
and p.action=v.number
and p.protecttype=1
and v.type = 'T'
and u.name!= 'dbo'
go


-- generate revoke commands for non-typical access

select 'revoke', name from sysobjects where id in
(
select p.id
from sysprotects p, master.dbo.spt_values v, sysusers u
where p.uid=u.uid
and p.action=v.number
and p.protecttype=1
and v.type = 'T'
and u.name!= 'dbo'
and v.name not in ('Delete','Execute','Insert','References','Select','Update')
)
go 

top   prev   next  

Sybase ASE DDL -- table

create table invoice (
invoice_id numeric(8,0) identity,
sales_rep_id numeric(8,0) not null,
date smalldatetime not null,
comment varchar(255) null )
on data_seg2
go

create table err_cd (
err_id integer not null,
err_desc varchar(60) not null,
constraint pk_err_cd primary key clustered (err_id)
)
go

create table employee (
emp_id integer not null,
salary money default 0,
hire_dt datetime default getdate()
)
go

/* Future inserts will reside on data_seg2 */
sp_placeobject 'data_seg2','invoice'
go

/* leave table where it is, but future allocations go to the new segment */
sp_placeobject new_seg , 'employee'
go

/* leave table where it is, but future allocations for the
text column (employee_notes) go to the new segment */

sp_placeobject new_seg , 'employee.temployee'
go

/* leave table where it is, but future allocations for the
text column (resume) go to the new segment */

sp_placeobject new_seg , 'student.tstudent'
go

ALTER TABLE employee REPLACE salary DEFAULT 49000
go

create default def_highsal as 55000
go
sp_bindefault def_highsal,'employee.salary'
go 

alter table employee add constraint emp_constr primary key(emp_id)
go

alter table invoice add constraint inv_constr unique nonclustered(cust_id,inv_date)
go

alter table invoice add constraint inv_fk_emp foreign key (sales_rep_id) references employee(emp_id)
go

alter table invoice_detail modify inv_type varchar(50) not null
go

alter table invoice_detail modify inv_type varchar(50) not null,inv_priority varchar(50) null
go

alter table employee add cell_no numeric(10) null
go

alter table employee drop constraint 'emp_dept_constr'
go

alter table charge_item replace price_overridable_ind default 0
go

/* change column name -- quotes are required */
sp_rename 'employee.dept',dept_name
go

alter table invoice partition 4
go

-- reorg and rebuild a table
reorg rebuild account_sales
go

top   prev   next  

Sybase ASE DDL -- index

create unique clustered index emp_idx on employee (emp_id)
go
create index emp_name_idx on employee (lname)
go

create unique clustered index pk_invoice_data on invoice_data with sorted_data on segment1
go

drop index 'employee.idx_employee'
go

create clustered index on employee (emp_id) on new_seg
go

# force to use a specific index in q query
select t1.emp_id, t1.emp_name, t2.status 
from employee t1 (index idx_emp), 
audit_flags t2
where t2.emp_id = t2.emp_id
go

index:
# pre v15
select rowcnt( doampg ) from sysindexes where indid < 2 and id = object_id( 'my_table' );

# after v15
select row_count( doampg ) from sysindexes where indid < 2 and id = object_id( 'my_table' );

top   prev   next  

extract ddl

-- find source code for stored procedure, function,views, triggers
sp_showtext
sp_helptext
defncopy utility
ddlgen utility

sp_help table name
ddlgen utility

top   prev   next  

Data Type

-- ---------------
data type storage range/length comments
----------------- -------- ------------------- ----------------------------
integer 4 +/- 2.1 billion
smallint 2 +/- 32768
tinyint 1 0 .. 255
float 4 storage req is machine dependant
real 4
double precision 8
smallmoney 4 +/- 214,748 4 decimal places
money 8 +/- 922 trillion 4 decimal places
decimal/numeric varies
decimal(9,0) 4
decimal(12,0) 5

char(n) n length <= 255
varchar(n) varies length <= 255 ( over 4000 allowed in ASE 12.5 )

text varies length up to 2 GB 16 bytes stored in record (default)
image varies length up to 2 GB 16 bytes stored in record (default)

datetime 8 1/1/1753 .. 12/31/9999 precision to 1/300 second
smalldatetime 4 1/1/1900 .. 6/6/2079 precision to minutes
timestamp 8 same as varbinary(8)

bit 1 0/1 up to 8 bit fields stored within 1 byte

binary(n) length n
varbinary(n) length n

Only numeric data types with a precision of zero can be used for an identity column.
-- ---------------------------------

top   prev   next  

distributed system

create proxy_table invoice_items at 'SERVERXXX01.dbxxx001.dbo.invoice_items'
go

top   prev   next  

init device and create database

disk init name = 'device19',physname = '/dev/md/rdsk/d19',vdevno = 6,size = 1024000

sp_helpdevice
select * from master..sysdevices;

select vdevno from master..sysdevices where status & 2=2;

disk init name = "test_disk",
physname = "/opt/sybase/data/test_disk.dat", size = "1M"
go

disk init 
name = "db1_dbccdb_data",physname = "/opt/sybase/data/db1_dbccdb_data.dat",size = "18M" 
go

disk init
name = "db1_dbccdb_log",physname = "/opt/sybase/data/db1_dbccdb_log.dat", size = "2M"
go

disk resize name = .device_name., size = additional_space
go

disk mirror name = "device_name" ,mirror = "physicalname
go

disk mirror
name = "log1", mirror = "/opt/sybase/data/log1_mirror.dat"
go

create database db1
on test_disk = "10M"
go

alter database db1 log on log1
go

-- turn transaction log off
alter database.log off

create database db1
on test_disk = "10M"
log on log1
go

create database dbccdb
on db1_dbccdb_data
log on db1_dbccdb_log
go

drop database db1
go

Moving the transaction log to another device
use master
go
sp_dboption "db1", "single user", true
go
sp_logdevice database_name, devname
sp_dboption "db1", "single user", false
go

Syntax: sp_changedbowner loginame [, true ]
sp_changedbowner my_db_user
go

Run sp_plan_dbccdb in the master database 
to obtain recommendations for database size, 
devices, workspace sizes, cache size, and 
the number of worker processes for the target database

use master
go
sp_plan_dbccdb db1
go

select * from master..sysdevices;

top   prev   next  

T-SQL

set option isql_print_result_set=ALL
go
set option isql_show_multiple_result_sets=On
go

set flushmessage on
go
set nocount on
go

# quit a script
select syb_quit()

# find temp db name
select db_name(tempdb_id())
go

set quoted_identifier on

sp_configure 'quoted identifier enhancements', { 0 | 1 }

create table "This is my table!" ("My Column!" int, YourColumn int)
select [name] from [sysobjects] where [type] = 'U'

# Causes Adaptive Server to stop processing a query after a specified number of rows are affected 
Activated by: set rowcount N
Turned off by: set rowcount 0

set rowcount 10
go
select emp_name, salary from employee order by salary desc
go
set rowcount 0
go


top   prev   next  

dbcc

dbcc checkstorage

top   prev   next  

Performance Monitoring

# monitoring
sp_monitorconfig
MDA tables
sp_sysmon

top   prev   next  

Excution Plan

# sql execution plan
set showplan
set statistics plancost
sp_showplan
show_plan()

top   prev   next  

Gather Information For Tech Support

# gather information for tech support
sybdiag utility

top   prev   next  

most popular site

sybase manual 
sybase.com 
sybaseteam 


top   prev   next  

sybase iq

sybase iq
sybase datawarehouse
sybase iq online docs
sypron whatis
IQ15 white Paper
sybase license
sysam status
sysam status -a

sysadm reread

set SYBASE_LICENSE_FILE=29722@bos;29733@nyc;@sfo
lmutil lmborrow -status
/bin/lmutil lmdiag .c ./licenses/SybaseIQ.lic

Migration tool . iqunload

local store: iqlsunload

sp_iqcheckdb ('verify database') 

top   prev   next  

sybase ase

http://www.sypron.nl/whatis_ase.html

top   prev   next  

notes



sybase iq:
http://wenku.baidu.com/search?word=Sybase&lm=0&od=0&fr=top_home


http://wenku.baidu.com/view/6583c3ea856a561252d36fa2.html?re=view

http://wenku.baidu.com/view/8931ae68a98271fe910ef939.html

http://wenku.baidu.com/view/58dd9e795acfa1c7aa00cc9f.html

master
model
tempdb
sybsystemprocs

sp_help
sp_configure
sp_helpdevice

-- ----------------------


isql -Usa -Pxxx
sp_helpdb
go
sp_helpdb my_dbname
go


$SYBASE/interfaces
$SYBASE/SYBASE.cfg

-- ----------------------

-- check server status
showserver

-- ----------------------

startserver -f RUN_SYBASE

startserver -f RUN_SYB_BACKUP

-- ---------------------

isql -Usa -P
shutdown SYB_BACKUP
go
shutdown
go

-- --------------------

$SYBASE/install/.log

-- --------------------

dump database master to "/usr/sybase/master.dup"
go

isql
sp_configure "allow updates", 1
go
begin tran
go
use master
go

sp_configure "allow updates", 0
go

sp_helpdb
go

sp_helpdb MBFEWKDB
go

sp_helpdevice
go

sp_helpdevice device_name
go

sp_dropdevice device_name


sp_addlogin login_name, passed [,defaultdb[,deflanguage[,fullname]]]
eg: sp_addlogin 'test', '123456'

sp_droplogin login_name
eg: sp_droplogin 'test'

sp_password old_passwd,new_passwd[,login_name]

sp_adduser login_name[,name_in_db[,grpname]]
# use sp_adduser to add a user to a specific database. 
# The user must already have an Adaptive Server login.
syntax: sp_adduser loginame [, name_in_db [, grpname]]

use db1
go
sp_adduser myuser1
go
sp_adduser user2, user2_db, group1
go

select * from sysusers;


use MBFEWKDB
go
sp_helpuser
go

sp_configure "number of user connections", 50
go


top   prev   next  

misc

http://www.sybaseteam.com/sybase-dba-interview-questions-answers-guide-topic-wise-t-882.html 

http://www.geekinterview.com/Interview-Questions/Database/Sybase 

SQL Anywhere
http://cnsk.gov.ab.ca/SQLHelp/dbeng50.htm   setting up SQL Remote using Sybase Central
http://cnsk.gov.ab.ca/SQLHelp/00000193.htm 

http://sauron.wlu.ca/physcomp/ikotsireas/SybaseASAtutorial.pdf 

http://sybaseblog.com/ 

http://sfdoccentral.symantec.com/sf/4.0/solaris/pdf/sf_syb_dbag.pdf 

http://andrewmeph.wordpress.com/ 

http://andrewmeph.wordpress.com/ 

Rob Verschoor books http://www.sypron.nl/main.html 

http://www.sypron.nl/main.html 

edbarlow.com sybase software tools>  

peppler 


top   prev   next  

Sybase Tools

isql
sybase central
toad 

top   prev   next  

rocket99

http://www.rocket99.com/cgi-bin/tech/search.pl  http://www.rocket99.com/cgi-bin/tech/search.pl?search=sybase 
Sybase Administration A backup routine
Sybase : Administration : A backup routine

Sybase Administration Adding a segment to a database
Sybase : Administration : Adding a segment to a database

Sybase Administration Apply a transaction dump
Sybase : Administration : Apply a transaction dump

Sybase Administration Apply multiple transaction dumps
Sybase : Administration : Apply multiple transaction dumps

Sybase Administration Configuring the cache
Sybase : Administration : Configuring the cache

Sybase Administration Create proxy tables and external logins
Sybase : Administration : Create proxy tables and external logins

Sybase Administration DBCC Notes
Sybase : Administration : DBCC Notes

Sybase Administration Database Creation
Sybase : Administration : Database Creation

Sybase Administration Database Engines: Status and Settings
Sybase : Administration : Database Engines: Status and Settings

Sybase Administration Database maintenance procedure
Sybase : Administration : Database maintenance procedure

Sybase Administration Database maintenance script
Sybase : Administration : Database maintenance script

Sybase Administration Dealing with a Corrupted Database
Sybase : Administration : Dealing with a Corrupted Database

Sybase Administration Dealing with a Server Failure
Sybase : Administration : Dealing with a Server Failure

Sybase Administration Device initialization
Sybase : Administration : Device initialization

Sybase Administration Display Available Device Space - Free Disk Space
Sybase : Administration : Display Available Device Space - Free Disk Space

Sybase Administration Display Locks on Tables
Sybase : Administration : Display Locks on Tables

Sybase Administration Display grants, effective rights to objects
Sybase : Administration : Display grants, effective rights to objects

Sybase Administration Displaying access information from sysprotects
Sybase : Administration : Displaying access information from sysprotects

Sybase Administration Drop an alias, with objects linked to login
Sybase : Administration : Drop an alias, with objects linked to login

Sybase Administration Loading data into Sybase IQ from a Remote Server
Sybase : Administration : Loading data into Sybase IQ from a Remote Server

Sybase Administration Moving the transaction log to another device
Sybase : Administration : Moving the transaction log to another device

Sybase Administration Post-installation check
Sybase : Administration : Post-installation check

Sybase Administration Removing the Replication Marker or Transaction Log Marker
Sybase : Administration : Removing the Replication Marker or Transaction Log Marker

Sybase Administration Renaming a database
Sybase : Administration : Renaming a database

Sybase Administration Reorg: rebuilding a table
Sybase : Administration : Reorg: rebuilding a table

Sybase Administration Replication Server 15 Configuration
Sybase : Administration : Replication Server 15 Configuration

Sybase Administration Security Tasks
Sybase : Administration : Security Tasks

Sybase Administration Server Configuration: example for 64 bit ASE
Sybase : Administration : Server Configuration: example for 64 bit ASE

Sybase Administration Server configuration
Sybase : Administration : Server configuration

Sybase Administration Setting Process Priorities
Sybase : Administration : Setting Process Priorities

Sybase Administration Setting the thresholds
Sybase : Administration : Setting the thresholds

Sybase Administration Show Users / Logins with Access to the Database
Sybase : Administration : Show Users / Logins with Access to the Database

Sybase Administration Striping Dump Devices
Sybase : Administration : Striping Dump Devices

Sybase Administration Sybase ASE 15 Enhancements
Sybase : Administration : Sybase ASE 15 Enhancements

Sybase Administration Sybase ASE Architecture Overview
Sybase : Administration : Sybase ASE Architecture Overview

Sybase Administration Sybase ASE: Database Schema Compare
Sybase : Administration : Sybase ASE: Database Schema Compare

Sybase Administration Sybase ASE: Database page size
Sybase : Administration : Sybase ASE: Database page size

Sybase Administration Sybase ASE: Installing a new server via srvbuildres utility
Sybase : Administration : Sybase ASE: Installing a new server via srvbuildres utility

Sybase Administration Sybase ASE: Managing Identity Columns
Sybase : Administration : Sybase ASE: Managing Identity Columns

Sybase Administration Sybase ASE: Managing users and roles
Sybase : Administration : Sybase ASE: Managing users and roles

Sybase Administration Sybase ASE: Setting resource limits for users
Sybase : Administration : Sybase ASE: Setting resource limits for users

Sybase Administration Sybase ASE: Setting up the transaction log cache using logiosize
Sybase : Administration : Sybase ASE: Setting up the transaction log cache using logiosize

Sybase Administration Sybase ASE: Setting up user assigned custom tempdbs
Sybase : Administration : Sybase ASE: Setting up user assigned custom tempdbs

Sybase Administration Sybase IQ - Remote Access From ASE
Sybase : Administration : Sybase IQ - Remote Access From ASE

Sybase Administration Sybase IQ : Comparing grants / permissions between servers
Sybase : Administration : Sybase IQ : Comparing grants / permissions between servers

Sybase Administration Sybase IQ : Moving / Re-allocating / Re-org
Sybase : Administration : Sybase IQ : Moving / Re-allocating / Re-org

Sybase Administration Sybase IQ : Procedure Profiling / Monitoring
Sybase : Administration : Sybase IQ : Procedure Profiling / Monitoring

Sybase Administration Sybase IQ : Repairing Problems / Troubleshooting Corruption
Sybase : Administration : Sybase IQ : Repairing Problems / Troubleshooting Corruption

Sybase Administration Sybase IQ Functions
Sybase : Administration : Sybase IQ Functions

Sybase Administration Sybase IQ Overview
Sybase : Administration : Sybase IQ Overview

Sybase Administration Sybase IQ: Copying users/logins between databases
Sybase : Administration : Sybase IQ: Copying users/logins between databases

Sybase Administration Sybase IQ: Database Creation (Raw Devices)
Sybase : Administration : Sybase IQ: Database Creation (Raw Devices)

Sybase Administration Sybase IQ: HUGEPAGE Support
Sybase : Administration : Sybase IQ: HUGEPAGE Support

Sybase Administration Sybase IQ: Index Types
Sybase : Administration : Sybase IQ: Index Types

Sybase Administration Sybase IQ: Listing tables, ordered by size allocated
Sybase : Administration : Sybase IQ: Listing tables, ordered by size allocated

Sybase Administration Sybase IQ: Managing User Accounts
Sybase : Administration : Sybase IQ: Managing User Accounts

Sybase Administration Sybase IQ: Minimize Storage option
Sybase : Administration : Sybase IQ: Minimize Storage option

Sybase Administration Sybase IQ: Monitoring Connections / Processes
Sybase : Administration : Sybase IQ: Monitoring Connections / Processes

Sybase Administration Sybase IQ: Monitoring and Troubleshooting via System Procedures
Sybase : Administration : Sybase IQ: Monitoring and Troubleshooting via System Procedures

Sybase Administration Sybase IQ: Restoring a Database from Dump Files
Sybase : Administration : Sybase IQ: Restoring a Database from Dump Files

Sybase Administration Sybase IQ: Server Startup Switches
Sybase : Administration : Sybase IQ: Server Startup Switches

Sybase Administration Sybase IQ: Sysmon / System Performance Analysis
Sybase : Administration : Sybase IQ: Sysmon / System Performance Analysis

Sybase Administration Sybase IQ: Working with options and server settings
Sybase : Administration : Sybase IQ: Working with options and server settings

Sybase Administration Transaction Log Checking: Wait Until It Clears
Sybase : Administration : Transaction Log Checking: Wait Until It Clears

Sybase Administration Transaction Log Filled Up - Log Suspended : What To Do
Sybase : Administration : Transaction Log Filled Up - Log Suspended : What To Do

Sybase DDL Alter a column
Sybase : DDL : Alter a column

Sybase DDL Altering a table
Sybase : DDL : Altering a table

Sybase DDL Binding Rules to Colunms
Sybase : DDL : Binding Rules to Colunms

Sybase DDL Clustered vs non-clustered indexes
Sybase : DDL : Clustered vs non-clustered indexes

Sybase DDL Creating a constraint
Sybase : DDL : Creating a constraint

Sybase DDL Creating a proxy table
Sybase : DDL : Creating a proxy table

Sybase DDL Creating a table
Sybase : DDL : Creating a table

Sybase DDL Creating an index
Sybase : DDL : Creating an index

Sybase DDL Modifying a Colunm
Sybase : DDL : Modifying a Colunm

Sybase DDL Moving an object to another segment
Sybase : DDL : Moving an object to another segment

Sybase DDL Object Permissions
Sybase : DDL : Object Permissions

Sybase DDL Sybase data types
Sybase : DDL : Sybase data types

Sybase DDL Table Partitioning
Sybase : DDL : Table Partitioning

Sybase DDL Tables which span multiple segments
Sybase : DDL : Tables which span multiple segments

Sybase Monitoring Listing object names and attributes
Sybase : Monitoring : Listing object names and attributes

Sybase T-SQL ASE 15 Hints: Query Plan Optimization
Sybase : T-SQL : ASE 15 Hints: Query Plan Optimization

Sybase T-SQL Aborting a T-SQL script
Sybase : T-SQL : Aborting a T-SQL script

Sybase T-SQL Detecting What Your tempdb Is
Sybase : T-SQL : Detecting What Your tempdb Is

Sybase T-SQL Executing dynamic SQL in a procedure
Sybase : T-SQL : Executing dynamic SQL in a procedure

Sybase T-SQL Functions in Sybase IQ
Sybase : T-SQL : Functions in Sybase IQ

Sybase T-SQL N-Tile Analytic Queries
Sybase : T-SQL : N-Tile Analytic Queries

Sybase T-SQL Sybase IQ - Lead / Lag Functions
Sybase : T-SQL : Sybase IQ - Lead / Lag Functions

Sybase T-SQL Sybase IQ - Showing Multiple Result Sets
Sybase : T-SQL : Sybase IQ - Showing Multiple Result Sets

Sybase Transact-SQL Case Statement
Sybase : Transact-SQL : Case Statement

Sybase Transact-SQL Creating a stored procedure
Sybase : Transact-SQL : Creating a stored procedure

Sybase Transact-SQL Custom query plans
Sybase : Transact-SQL : Custom query plans

Sybase Transact-SQL Date processing: stripping time from datetime
Sybase : Transact-SQL : Date processing: stripping time from datetime

Sybase Transact-SQL Forcing an index in a query
Sybase : Transact-SQL : Forcing an index in a query

Sybase Transact-SQL Getting the size of a blob or image
Sybase : Transact-SQL : Getting the size of a blob or image

Sybase Transact-SQL Inner/Outer Joins
Sybase : Transact-SQL : Inner/Outer Joins

Sybase Transact-SQL Isolation Levels
Sybase : Transact-SQL : Isolation Levels

Sybase Transact-SQL Lead and Lag with pure SQL
Sybase : Transact-SQL : Lead and Lag with pure SQL

Sybase Transact-SQL Median Calculation, with pure SQL
Sybase : Transact-SQL : Median Calculation, with pure SQL

Sybase Transact-SQL Ranking Data - with Duplicates
Sybase : Transact-SQL : Ranking Data - with Duplicates

Sybase Transact-SQL Reporting: SQL Performance and Tuning
Sybase : Transact-SQL : Reporting: SQL Performance and Tuning

Sybase Transact-SQL Returning Multiple Result Sets in Sybase IQ
Sybase : Transact-SQL : Returning Multiple Result Sets in Sybase IQ

Sybase Transact-SQL Rowcount setting - limiting result sets
Sybase : Transact-SQL : Rowcount setting - limiting result sets

Sybase Transact-SQL Safely delete a large number of rows without blowing the t-log
Sybase : Transact-SQL : Safely delete a large number of rows without blowing the t-log

Sybase Transact-SQL Self-Joins in SQL
Sybase : Transact-SQL : Self-Joins in SQL

Sybase Transact-SQL Transact SQL: Complex Updates
Sybase : Transact-SQL : Transact SQL: Complex Updates

Sybase Transact-SQL Transact SQL: Conditionals
Sybase : Transact-SQL : Transact SQL: Conditionals

Sybase Transact-SQL Transact SQL: Cursors
Sybase : Transact-SQL : Transact SQL: Cursors

Sybase Transact-SQL Transact SQL: Finding duplicate rows in a table
Sybase : Transact-SQL : Transact SQL: Finding duplicate rows in a table

Sybase Transact-SQL Transact SQL: date/time formats
Sybase : Transact-SQL : Transact SQL: date/time formats

Sybase Transact-SQL Transact SQL: date/time functions
Sybase : Transact-SQL : Transact SQL: date/time functions

Sybase Transact-SQL Transact SQL: looping constructs
Sybase : Transact-SQL : Transact SQL: looping constructs

Sybase Transact-SQL Transact SQL: misc functions
Sybase : Transact-SQL : Transact SQL: misc functions

Sybase Transact-SQL Transact SQL: numeric functions
Sybase : Transact-SQL : Transact SQL: numeric functions

Sybase Transact-SQL Transact SQL: string functions
Sybase : Transact-SQL : Transact SQL: string functions

Sybase Transact-SQL Using Temporary Tables
Sybase : Transact-SQL : Using Temporary Tables

Sybase UNIX BCP data to/from a flat file
Sybase : UNIX : BCP data to/from a flat file

Sybase UNIX Interface Files, IP and Port Translation
Sybase : UNIX : Interface Files, IP and Port Translation

Sybase UNIX Running SQL within a script
Sybase : UNIX : Running SQL within a script

Sybase UNIX Shared memory setting
Sybase : UNIX : Shared memory setting

Sybase UNIX Starting the Sybase process
Sybase : UNIX : Starting the Sybase process