



Two questions:Situation 1: Normalized database, have several lookup-only tables thatcontain anywhere from 3 rows to ~5,000. Insert / update activity israre. They have identity columns that are used for joins to muchlarger (transactional) tables. Their identity keys are never sorted orranged; no...
test...
Needing help with this scriptselect sub_a.reason_code,sum(sub_b.col_b)from(select t.reason_code from reason_types tgroup by t.reason_code) sub_a,(select t.reason_code,count(c.ref_no) col_bfrom case_decisions c, tariff_reason_types twheregroup by t.reason_code) sub_bwhere sub_a.reason_code = sub_...
Hi all.I have a need to replicate data across heterogenious data sources.Fortunately within our enterprise each of our replication needs areuni-directional, i.e., one master.This is not a data warehouse project so ETL/BI is not required. I'mlooking for a package that does basic database rep...
Hi all.I have a need to replicate data across heterogenious data sources.Fortunately within our enterprise each of our replication needs areuni-directional, i.e., one master.This is not a data warehouse project so ETL/BI is not required. I'mlooking for a package that does basic database rep...
I've been developing an application using SQL Anywhere. I would nowlike to deploy it so other users can work with it. I set theapplication up on a remote server that anyone can access using remotedesktop. The problem is that it will only let one user in at a time.I need to know how I start...
Its only test.Please klick on a link to test:Thanks...
Performance drop-outs with Sybase ASE 12.5.1, 12.5.2: company is developing a large database application already formany years for use in the market of *big* libraries (of universitylibraries or big public ones). To get an idea what I'm talking aboutwith 'big', let's say for...
i'm looking simple database undr c++ or java, which realizedcoumunication client- serverit's my homework and i need help !!thx...
ACM CIKM 2005 Call for PapersFourteenth Conference on Information and Knowledge Management -Industrial Track 31st - Nov 5th 2005Bremen, Germanyhttp://www.tzi.de/CIKM2005/Since 1992, CIKM has successfully brought together leading researchersanddevelopers from the database, information retrieval a...
Hello,I would like to save sentences of a text as elements of database. 255characters (available in type char) should be not enough. And I havedecided to use either type text or tinytext or mediumtext or longtext.However I do not know how many symbols I can use in each of these typesand as a con...
Hi i have database dumps named as "train_2005_03_21.bkp"I dont how to load this back into database -sybase obviouslyPls help me out with exact commandCheersGopal...
