Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by RajD

  1. RajD

    Help/Advice needed to install DBI.pm module

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

    How to access .DBF files from perl on UNIX

    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
  3. RajD

    How to access .DBF files from perl on UNIX

    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...
    • RajD
    • Thread
    • Replies: 3
    • Forum: Perl
  4. RajD

    Row level access control

    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...
  5. RajD

    Displaying col names from a table

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

    Sybase-UDB interface

    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...
  7. RajD

    Reading Interfaces file

    Thanks to all. It was really helpful RajD
  8. RajD

    Send mail from Command Prompt

    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...
  9. RajD

    SQL 6.5 Replication

    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...
  10. RajD

    Which H/ware I am connected to???

    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
  11. RajD

    Which H/ware I am connected to???

    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...
  12. RajD

    Start master in Single-User Mode (11.5) WinNT

    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...
  13. RajD

    How to Store database

    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...
  14. RajD

    Improving Processing Speed (any tips?)

    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 --...
  15. RajD

    run external commands from stored procs

    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
See more

Part and Inventory Search

Back
Top