Archive for the ‘Sybase IQ’ Category

Difference between delete and truncate

Delete: Whenever we are using delete from tablename, then automatically deleted data internally stored in buffer. We can get it back by using rollback command.

Differences between where and having clause

WHERE: Where clause is used to filter the data based on condition. Only rows that meets conditions contribute data to the result set. Filters rows Where clause is executed before group by clause. Use where clause, if there is no aggregate function in condition.

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 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 Configuration on Linux

1. Provide the http and hppts port numbers on which you want to configure Sybase IQ server. Default ports are 4282 and 4283. If you enter blank means default port 4282 and 4283.

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 […]

Powered by k2schools