Search results for query: *

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

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

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

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

Hi guys, Just a simple one for you guys, but important for me. How do I know which shell I am working on? C-; B-; K- ??? What is the simplest way to identify? Any variable/parameter/setting etc??? I know its a simple one, but don't leave it to others please. Thanks Raj

Hi Guys, I need to know where my entries are pointing to (I mean which server) If I go to the interfaces file, it shows the IP Address and Port Number in Hex. What does this means master tli tcp /devp/tcp \x000212f2929567470000000000000000 Is there any tool or method to convert this junk to...

Hey guys, I came across a M/c with solaris installed on it. The situation is, the person who installed and was maintaining it disappeared all of a sudden and now I have to take care of it. I don't have the password (even I don't know the user names having su access). No user directly connects...

Hi, Is there a way I can get a list of stored procedures using one particular index in my database? I have table which is used by many SPs(over 100 in #). This table has 7 indexes on various columns. I feel one of the 7 indexes is useless and want to drop it. But before doing so, I wanted to...

Hi, I want to know where the IP address of my NT-Workstation stored on my machine. I am able to get the IP address by issuing a DOS command >ping mymachine But I want to read it from a file on my machine. Thanks RajD

Hi friends, I am totally new to solaris, so some basic queries. 1) How do I check the current version of solaris on my machine? 2) How do I check the available physical memory on my m/c? Thanks RajD

Hi, I have Sybase 11.9.2 installed on a sun box and using &quot;Sybase 11&quot; ODBC to connect to it from WIN-NT Now I got another sun box installed with ASE 12.0 and want all my applications to use the new box. Will it be possible for me to have both &quot;Sybase 11&quot; as well as ASE-12...

Hi, I have Sybase 11.9.2 installed on a sun box and using &quot;Sybase 11&quot; ODBC to connect to it from WIN-NT Now I got another sun box installed with ASE 12.0 and want all my applications to use the new box. Will it be possible for me to have both &quot;Sybase 11&quot; as well as ASE-12...

Hi, In one of my SP, which runs 100s of lines, I am using a #temp table to store the results during the process. At the end of the SP, a simple select statement returns rows from #temp using &quot;Select * from #temp&quot; The procedure works fine when run in SQL-QA, but when I am trying to...

Hi guys, One of my friend truncated syslogins on master database on a 'SQL Server 6.5' server. Is there anyway to restore it??? There is no backup available on this recently built server and it has few databases on it. Pl help. Thanks

Hey Friends, I am friendly with UNIX Scripts but now my manager want's me to get the things done with PERL. I agree PERL has more to offer(and I guess its fun too to work with PERL). All I need to know is ... 1) Which is a Good Book (The Good Book) to start with, having lots of examples 2) Is...

Hi, How do I write &quot;GOTO Label&quot; in KSH script?(If possible at all)

How do I write &quot;GOTO Label&quot; in KSH shell script? (IF it is possible at all)