Databases

NAVIGATION

ISQL and Linked Server

HI,I can see the table through ISQL from my Windows 2000 machinebut I get an error when I try to use linked server PENQUERY command:select * from [THEFRCE]LE DB provider 'Sybase.ASELEDBProvider' reported an error.[LE/DB provider returned message: [Native Error code: 208][DataDirect AD...

0 answers | 647 bytes |

Exiting ISQL with / w/o exit & quit

Which is Suitable 1) or 2):1)isql -Usa -Ppassword -Sserver_name << EFgoselect * from tablegoEF2)isql -Usa -Ppassword -Sserver_name << EFgoselect * from tablegoquitEFHere in case 1) ,we r not exiting ISQL using exit or quit command.In this case , will the session be remained open/ res...

5 answers | 481 bytes |

Question about Windows 2003 SP1

Is Sybase ASE 12.5.3 & Rep Server 12.6 certified to run on Windows 2003Server SP1?Thanks,Joe...

0 answers | 127 bytes |

Regarding Timestamp

Greetings,This may be very basic but i still would like to askthis.I have a table with a timestamp field that gets updated by the DBengine.select * from testgoid timestamp_value1 0x00000000003da03b(1 row affected)If i try to bcp out the content of this table into flat files, thecontent appears a...

2 answers | 640 bytes |

Database connectivity

I am studying DBMS after a gap of 11+ years. In my days weused to program in xbase and sometime in the mid 90s came upthis idea of Database Connectivity(DBC) and Client/Server(C/S)computing.Is DBC in a C/S framework still the dominant programmingparadigm nowadays? Are any standards in place?Do w...

4 answers | 576 bytes |

Call for Papers: PLC'06 (part of WORLDCOMP'06)

From: Dr. H.R. ArabniaC A L L F R P A P E R SThe 2006 International Conference onProgramming Languages & Compilers(PLC'06)June 26-29, 2006Monte Carlo Resort, Las Vegas, Nevada, USAThe 2006 International Conference on Programming Languages &Compilers (PLC'06) will be held in Las Vegas,...

0 answers | 10590 bytes |

Call for Papers: IKE'06 (part of WORLDCOMP'06)

From: Dr. H. R. ArabniaC A L L F R P A P E R SThe 2006 International Conference onInformation & Knowledge Engineering(IKE'06)June 26-29, 2006Monte Carlo Resort, Las Vegas, Nevada, USAThe 2006 International Conference on Information & KnowledgeEngineering (IKE'06) will be held in Las Ve...

0 answers | 10377 bytes |

dbcc rebuild_text results in full tranlog

We got a database with a very large table, which holds a IMAGE field. Thereare a lot of inconsistensies on this specific table. A dbcc checkstorageresulted in ca. 750 hard- and 350 softfaults :frs2_srcimage 255 100030 page format errorI thought a 'dbcc rebuild_text(frs2_srcimage)' woul...

0 answers | 742 bytes |

Charset 'cp437' not found on ASE 11.0.3 for linux

Hi all,I'm using DBD::Sybase to connect locally to databases on a RH 9 box.dsn looks likedbi:Sybase:database=xxxxx;server=SYBASE;charset=is o_1and another looks likedbi:Sybase:database=yyyyy;server=SYBASEIf the ";charset=iso_1" is not present on the first dsn then I get anerror like this:DB...

1 answers | 841 bytes |

Modeling General Graphs in SQL

This is long, so bear with me.I am trying to come up with a way to model a general graph in SQL whichdoes not use the adjacency list model. Her is what I have so far andI'd like to get any ideas on it.What if we attempt to store all the paths in a directed graph in asingle table in an RDBMS...

13 answers | 3960 bytes |

Dr. Michael Kay Shows the Way to Schema-Aware Queries and Stylesheets

[ANNUNCE] Stylus Studio wants to inform you that Dr. Michael Kay hasreleased a new tutorial called, "Schema-Aware Queries and Stylesheets".This is his third installment of the XQuery tutorial set. You canaccess it here:This tutorial covers the following topics: The Connection Between Queries/Sty...

0 answers | 601 bytes |

theory about foreign key as primary key ?

hiI was searching in net and I can't find enough information about it:for example I have 2 tables:tableA (idA int PK, )is in relation 1 to N withtableB (idB int, idA int FK, )do You meet something like that: foreign key idA and column idB becameprimary key in tableB?if You say 'yes...

7 answers | 810 bytes |