Recent content by RajD

Why do you have semicolons after MiddleName Char(20) (also for CellPhone and BirthDay) RajD

Are these modules for UNIX? How does my unix perl script talk to the ODBC or XBase drivers. Do I need to install it on the UNIX folder. Please help RajD

If someone can guide me, probably with a simple example to access data in .dbf (dbase / foxpro) file from perl on UNIX My perl environment with perl -V is as follows ======================= Characteristics of this binary (from libperl): Built under hpux Compiled at Mar 13 2000 15:44:37...

Hi guys, Is there a way in sybase I can limit access to rows in certain/all tables based on the login-id? I believe there is a way in Oracle( I just heard. Never used Oracle) something called context which can be used to satisfy this. Well, the requirement is: We are managing a database for...

Try this, select name from syscolumns where id = object_id("my_table") order by colid RajD

Hi All, With my present job as Sybase DBA/Developer (Purely Sybase ), a new requirement coming-up is to interface UDB with Sybase. Since this seems to be an Unknown-Devil to me, could anyone give hint/s to me. I have few basic queries poping up in my mind, immediate after I got the...

Thanks to all. It was really helpful RajD

Hi guys, I have a batch (.bat) program which runs frequently on one of my NT server. I want to modify this batch program to send mail when certain step/s fail. Is there a "Command" which I can run within this batch program which sends mail? I have mail setup on this box and am able...

Hi guys, I am trying to setup replication on SQL 6.5. Setting up SQL6.5 as distributor and for Publications and another Oracle server for subscription. Everything looks fine, but the LogReader. The LogReader history shows an error message &quot;Unable to connect to <SQL_Server_Name>&quot...

Hi qyllr, Looks like you were busy these days. I hope all is well. Well, I did the same thing for now. Created a new interfaces file called global_interfaces and added entries to different servers with different names. Thanks, RajD

Hi guys, I have two sybase installations on two different H/w. Both(ASE) has the same name PROD_SRVR12, PROD_SRVR12. Well, before you start advising me, let me explain why these two have the same names. One of the Server (with powerful H/w) is going to replace the other one(earlier setup...

Recovering the master Database This example rebuilds the master database on a 17MB (8704 2K pages) master device: d:\sybase\bin> bldmastr -d d:\devices\master.dat -s8704 -m The following example loads the most recent backup of the master database from tape with the load database command: load...

Hi jeeseck, By this time, I hope you must have got solution to you problem. Anyway, what appears from your question is that you need to &quot;Dump&quot; (backup) some or all data but restore only few of them as and when required. If this is true, you may try 'bcp' as your backup/restore tool...

Hi Old lad, As far as I know, there is no &quot;Formula&quot; for improving performance. The definition of heavy SQL processing itself is not well defined yet. It all depends on -- The Resources available -- The quality of the SQL code -- The frequency -- # simultaneous instances --...

Hi gensan, What does that exactly mean? Do you mean to say, you want to run a &quot;Dos Command&quot; from within isql, like isql -S<server> -U<user> -P<password> 1> run calc 2> go ??? RajD