Archive for the ‘Sybase’ Category

How to install sample databases in Sybase

Sybase provides three databases i.e. pubs2,pubs and pix2. These can be installed either at the time of ASE(sybase) installation or after installation. pubs2: database to test our server connections and to practice Transact-SQL. pubs3: is the upgraded version of pubs2. pix2: installs the image data Install scripts for sample databases are kept by default at […]

How to run script in Sybase

We can create scripts and execute using isql. This is useful when you need to execute the same set of commands. Script execution Syntax: isql -Uuser_name -Ppassword -Sserver_name -iscript_name -oscript_output How to create scripts: Create text file and paste the commands to be executed on SYBASE ASE. root$vi databaseslist.txt select name from sysdatabase go :wq!

isql history

What is isql? isql tool is interactive parser to ASE(Sybase). isql tool sends commands to ASE and displays the results on standard output. Syntax: isql [-b] [-e] [-F] [-n] [-p] [-v] [-W] [-X] [-Y] [-Q] [-a display_charset] [-A packet_size] [-c cmdend] [-D database] [-E editor] [-h header] [-H hostname] [-i inputfile] [-I interfaces_file] [-J client_charset] […]

Restore Master database in Sybase

Why master database? The master database controls the operation of Sybase(ASE) server and stores information about all user databases and database devices information. It stores User accounts, Remote User accounts, Ongoing process, System Error Messages, List of databases on Sybase server(ASE), Active locks,Character-sets, Server Roles, etc. If we want to create new database, we should […]

ddlgen tool in Sybase

Sybase ddlgen tool used to extract the creation script for any server-level or database level object. This is OS level command. Syntax: ddlgen -Ulogin -Ppassword -S[[ssl:]server | host_name : port_number] [-I interfaces_file] [-Tobject_type] [-Nobject_name] [-Ddbname] [-Xextended_object_type] [-Ooutput_file] [-Eerror_file] [-Lprogress_log_file] [-Jclient_charset] [-LC -N logical_cluster_name -F[ % | SGM | GRP | USR | R | D […]

How to start Sybase IQ server

To start Sybase IQ Server, first we have to set the Environment variables. Then, we have to create demo database. Using start_iq, we can Sybase IQ server. Setting Environmental Variables: 1. Navigate to Sybase Installation directory. In my case /opt/sapiq is the install directory.

Sybase IQ installation on Linux

We are going to install the Sybase IQ on Redhat Linux.SAP is providing for Sybase IQ 30 days Trial Evaluation copy. 1. Download the Sybase IQ from here 2. tar the Sybase IQ iq160_LinuxAMD64.tgz file by running following command. tar -xf iq160_LinuxAMD64.tgz 3. Navigate to extracted folder SAPIQ_1600_SP11-LinuxAMD64-eval is in my case. 4. Then, run […]

Sybase Checkpoint Process

What is checkpoint. A check point server event which causes all of database dirty pages to be copied from cache to disk. A checkpoint exists primarily to reduce the work of server at recovery time which means brings Sybase database up faster. We can run checkpoint on one or more databases. To run checkpoint, we […]

Get Sybase Database Information

We can get the information about databases and its objects using sytem procedures, built-in functions and system tables. sp_helpdb reports database(s) information like name,db_size,owner,dbid,created,durability,status. To get list of databases in ASE: We can get the list of databases(system and user databases) either using sp_helpdb or sysdatabases. Sysdatabases table gives us more information than sp_helpdb, but […]

Alter table in Sybase

Using alter command, we can change the structure of the table. Following changes can be done on tables: Add and Drop columns Add and Drop constraints Add null columns Change locking scheme Convert column datatypes Partition or Unpartition tables Increase or decrease the column length Syntax: alter table table_name [add column_name datatype [identity | null […]

Powered by k2schools