Sybase IQ error Syntax error near 'SET' on line

Many times you may get Sybase IQ error like Syntax error near 'SET'. Suppose if I am trying to execute below statements

SET TEMPORARY OPTION Temp_Extract_Column_Delimiter =',';

SET TEMPORARY OPTION Temp_Extract_Row_Delimiter = '';

SET TEMPORARY OPTION Temp_Extract_Name1='\\\\XYZServer\\Backup\\test.txt';

SELECT column1, column2, column3 FROM tblTest

SET TEMPORARY OPTION Temp_Extract_Name1='';

commit;

Then Sybase IQ display below error

ERROR[42000][Sybase][ODBC Driver][Sybase IQ]Syntax error near 'SET' on line 5

Solution:

It simply means end SELECT query with semicolon “;”.

Every statement in Sybase IQ should be end with semicolon.

SELECT column1, column2, column3 FROM tblTest;

SET TEMPORARY OPTION Temp_Extract_Name1='';

Please leave your comments or share this tip if it’s useful for you.

How to show multiple messages in alert box in JavaScript?

An alert box is used to pop up the information where user has to click “OK”.

alert("This is single line message.");

Generally we are showing single line message in alert box. But do you know how to show multiple message in single alert box?

Trick is to use “\n” after every message to separate one message with other like

alert('-1. Tajmahal in India. \n\n-2. Pyramids in Egypt. \n\n-3. Great wall of China.');

Here I want separation of two lines between each message, so I used “\n\n”.

So finally it should look like this

Please leave your comments or share this tip if it’s useful for you.

column Id is constrained to be unique. value is already present

If you are working with dataset in .NET and facing error as "column Id is constrained to be unique. value is already present."

Then simply set

datasset.EnforceConstraints = false;

It does not check the constraints at .net side. When you are going to update dataset records into database, all constraints fire at database level.

Please leave your comments or share this tip if it’s useful for you.

Quick guide to install and use NCache in .NET application

NCache is a distributed in-memory object cache for mission .NET applications which are hosted on web farm environment.

Here are quick steps to install and use NCache in .NET application.

·         Download and install Ncache express from http://www.alachisoft.com/download.html#ncache

·         Open C:\Program Files\NCache Express\config and change cache.config name="mytestreplicatedcache" in config.ncconf file.

·         In client.ncconf, change cache id ="mytestreplicatedcache".

·         Open Perfmon from Run window and test the Ncache counter for object mytestreplicatedcache.

·         Start cache on all nodes, one for Local Cache & two for Replicated Cache. Startcache.exe is located in “%InstallDir%\NCache Express\bin\tools” folder. Do this once for each cache server:

Startcache  cache-id /s serverName

C:\Program Files\NCache Express\bin\tools > Startcache  mytestreplicatedcache /s SERVERNAME

·         Run “AddTestData” command-line program provided with NCache to add some test data to the cache. It is located in “%InstallDir%\NCache Express\bin\tools” folder. Following command adds 100 items of size 1024 bytes each:

AddTestData  cache-id /c 1000 /s 1024

C:\Program Files\NCache Express\bin\tools > AddTestData  mytestreplicatedcache /c 1000 /s 1024

·         Check Green marked Additions/sec counter in performance counter that, it is showing value for addition of 1000s items.

·         After 5 min., check blue marked Expirations/sec counter in performance counter that, it is showing items going to expire.

·         If the above operations succeed, then you can rest assured that you’ve configured the cache correctly. You can either let the “test data” expire in 5 minutes of manually clear the cache with the following command (again in “%InstallDir%\NCache Express\bin\tools”)

ClearCache cache-id

C:\Program Files\NCache Express\bin\tools > ClearCache mytestreplicatedcache

·         Open web application in visual studio add reference of "Alachisoft.NCacheExpress.Web.dll" from C:\Program Files\NCache Express\bin\assembly\clr20

·         Mark all entities that need to be cached as [Serializable].

Please leave your comments or share this guide if it’s useful for you.

15 Apr 2014 6:00 PM | Magical number 10,000

15 Apr 2014 6:00 PM is remarkable day for my blog as it crossed magical number 10,000+ visitors with 150+ technical articles.

Hope it will grow to 1,00,000+ in near future.

How to use SQL Server Profiler in easy steps

Most of the .NET developers have to deal with SQL server. Some may be good in database while most of the developers are great in front end but know only the basic knowledge of SQL Server database.

During development, these developers have to face the database performance issues. For most of the developers this database query performance kind of tasks are bouncers. 

Here I am trying to explain how you can use SQL Server profiler for identifying query performance.

Suppose I have to check performance of below queries

SELECT * FROM TableA

GO

SELECT * FROM TableB

GO

SELECT * FROM TableC

GO

1.    First open SQL Server Profiler from Tools -> SQL Server Profiler

2.    Login to SQL Server Profiler and click on Events Selection tab of Trace Properties window.

 

3.    Uncheck all events in Events Selection tab except SQL:BatchCompleted. Select Show All Columns radiobutton and click on Column Filters… button.

 

4.    Select HostName filter from Edit Filter screen and click on Like option. Enter here filter value as ‘%ComputerName%’. Click Ok.

 

5.    Click Run.

6.    Now run queries in SQL Server.

7.    Check status of all queries in SQL Server profiler as below

 

8.    The most important data are CPU, Reads, Writes and Duration. Here higher figures of these columns show the action required for query optimization.

Please leave your comments or share this article if it’s useful for you.

No server is available to process the request in NCache

If you are getting error "No server is available to process the request" for NCache then follow below steps to fix it.

·         Restart NCache Express from windows service

·         Go to command prompt and start cache as

Startcache  cache-id /s serverName

Please leave your comments or share this tip if it’s useful for you.