Databases

NAVIGATION

character set support

I'm looking at an MS SQL server database and it stores city namesacross the world. All aarabic , chinese etc names are converted to the latin alphabet.I feel it is probably critical we support accents as a means todistinguish between cities that would be converted to the same Latinalphabet...

0 answers | 776 bytes |

View current transaction blockings

Hi,Would someone please take a look at this query, and let me know ifthere is an easier/better/nicer way to obtain a picture of currentusers that are blocking other users.selectsp1.spid as blockEE_SPID,sp1.program_name blockEE_Program,sp1.tran_name blockEE_TranName,rtrim(ltrim(sdb.name + '....

1 answers | 963 bytes |

Text Field Returned as Null?

Hi,This may well have been posted 1000 times before, if so, I am sorry.I have an DBC driver (ASE 4.10.00.10) that when I execute a queryreturns NULL for a field of type Text.I have tried increasing the default buffer size for long columns to4096 (4 meg), and used the parameter initilalization st...

0 answers | 444 bytes |

ODBC DSN List?

Hey All,I'm writing a program in c-like language (VTS) which accesses an DBCdatabase with SQL commands. In order to use the SQL commands you mustconnect to the database using a CDBC() command in the VTSlanguage. The connect command requires the DSN name (not the path ofdatabase) in order to...

1 answers | 646 bytes |

New survey book in data streams

BK ANNUNCEMENTDATA STREAMS: Models and AlgorithmsEd. Charu AggarwalSpringer.To appear Dec 2006, approx. 370 pagesAvailable for pre-order at Springer/Amazon.comThis book contains a set of survey chapters on several important topicsin data streams.The book is meant for an audience of advanced stud...

3 answers | 531 bytes |

How to split a data definition SQL script file (DDL script)

Hello,I need to split a data definition SQL script file (DDL script) tomany files, each file corresponding to one command category (tablecreation, constraint creation, index creation, etc).Do you know some tool to do that ?Thanks in advance for your answers !...

5 answers | 302 bytes |

Yellowfin Announces Release 3 OLAP Connectivity

Yellowfin Announces Release 3 LAP ConnectivityNew Features Including LAP-to-Relational Drill Through ProvideCustomers with Complete Web BI Tool for LAP AnalysisYellowfin, today announced the availability of Yellowfin Release 3, thenewest version of the leading query, reporting, and analysis tool...

0 answers | 2879 bytes |

Insert if not present

Hi,I need to insert a set of values into table_2 and these values are readfrom table_1. This insertion now goes only if an identitycolumn doesnot match an existing value.For exampleinsert into table_2values (select val1,val2,valn from table_1 where valk not in (selectvalk from table_2)).valk is...

2 answers | 830 bytes |

Novell certs ?

i want to be cne certified. how good are ********* preps for novell exams ?. i have heared they r very close to real exams . any comments ?...

0 answers | 154 bytes |

How much RAM?

Following are some quick questions?1. How much RAM we need to assign (for Sybase) to install Sybase(Windows S) to our new db server?2. Is there some type of default RAM setting that I can go with thatwill suffice?We have not installed it yet, just got the machine recently and waitingfor the Syba...

1 answers | 611 bytes |

SQL Query - A better way?

I have a query that I have written and it works, but it seems a bitredundant and I am wondering if there is a better way to write it.My basic problem is I want to pull only 1 record, and that record isthe newest one based on the LASTUPDATE date field.Here is my attempt at the querySELECT * FRM A...

4 answers | 612 bytes |

Pricing for Quest, BMC, etc Sybase Management Tools

I am looking to get some pricing or Sybase ASE, Rep Server and IQManagement tools. Any input on the below would be greatly appreciated.QuestDoes Quest have management tools for ASE, Rep Server and IQ?Price for Foglight Sybase cartridge ? Is it priced per CPU?Price for Foglight S modules?Price fo...

1 answers | 1110 bytes |