Search results for query: *

Hi Guys, We have a MS-Access based application. Its growing a lot and we are slowly thinking, what if we migrate it to some bigger RDBMS ? So, as usual there is a question. Should we go to Oracle or Sybase ? why ? why not ? The application is modarate on with say 500 to 1000 inserts a day and...

Hi all, I am not a very expert Oracle DBA. I have all the data files from a Oracle database which we have stopped using a long ago and does not exist. Also I do not have the control files, just all the data files. If I have to create the database just from the data files, what steps I need to...

Hi all, Whats difference between Character set and National Character set of a database ? The question came to my mind when I was trying with LOBs and was trying to understand the difference between CLOB and NCLOB. Please guide. Regards

Hi Guys, We have a MS-Access based application. Its growing a lot and we are slowly thinking, what if we migrate it to some bigger RDBMS ? So, as usual there is a question. Should we go to Oracle or Sybase ? why ? why not ? Your opinions and experiances are most valuable. Regards

Hi All , I have a strange problem. There 2 programs, which run one after the another, once a day. First one inserts records in a table ( may be between 3000 to 5000 records each day ) and another update on the table. The second program which updates, starts running immediatly after first is...

Hi all , I have landed in a slight confusion over the value of "number of locks", we get in sp_configure. What does that indicate ? Does it give the number of locks, which can be made in that data server ( at any given point of time for all possible objects in the data server ) ? Or it gives...

Hi there, I was working on AIX and used to use fuser command to check if a file is locked ( in use ) by any user. Does the same command exist on Solaris or what is the equivalant then ? Please help. Regards

Hi all , I want to put a single quote at the begining and single quote plus a comma at the end of each line in a file. I did the following , sed -e "s/^/'/" -e "s/$/',/" filename It worked. But if I do , sed -e 's/^/\'/' -e 's/$/\',/' filename That do not work, I am given a secondary prompt...

Hi all, I am on Solaris. One of the C codes (Pro*C) we have has following declaration statement, int (*dbg_print) (const char *fmt_str,...); What is the meaning of this ? I can make out that this is pointer to function. But what the three dots "..." stand for ? Please explain. Regards

Hi Guys , I am learning XML. I have read a book on XML and familier with the concept and theory of XML. Some reality stuff ...... Which are the softwares or software layers involved in a typical J2EE based XML messaging application. Please explain. Basically I want to create one example...

Hi all, I am still in 8.1.7, but will be soon going to 9.2 . I want to know experiances of people. Theoratically we can say, locally managed tablespaces are very good, there are many advantages, specially when we make them autoextend. I want to know if somebody has faced any problems with...

Hi there , I use sqsh for querying database . If I run a command in sqsh , sp_help SomeTableName ; | /usr/myself/myscript This works fine, means the output of sp_help is redirected to one of my scripts, /usr/myself/myscript and I get the output. What I want to do is define a alias or...

Hi all , I have a awk like this , awk '/Column_name/,/^ *$/ { print $0 }' tab.txt Simply, select all lines between ( including ) the line containing the word 'Column_name' and subsequent blank line. What I want if lines between ( and including ) line containing 'Column_name' and "subsequent...

Hi all, I am using awk on Solaris. The simple command I am using is, awk -v var1=1 '{print var1 }' databases where databases is a file in current directory. I get error, awk: syntax error near line 1 awk: bailing out near line 1 What/where is the error ? I have used similiar syntax with...

Hi all, I have one machine where Sybase::DBlib is installed and used extensively. Iwant to install it on other machine, from where can I get it ? Also where can I find some documentation for the same ? So that I can start programming using the same. Regards

Hi Guys , I am on Sybase 12.5 . I know that if I have to write a C program interacting with SYbase database, there are more than 1 methodologies , one of which is DB-Library. Is that the case with Perl also ? Are there more than one Perl modules/APIs for Perl to interact with Sybase ? Which...

Hi all , I have IP address of a machine on the network. How can I find out all possible domain name aliases defined for that machine ? If there is a way to do this, will it work for internet and intranet both ? Please guide . Regards

Hi Guys , I have a comma saperated text, say , aaaaa,a123,345,x3e345r,,,wer,234 bbbbbb,f345,89000,,,,,g45,34 in a file. ** Using only sed ** , I want to convert the same to , "aaaaa","a123",345,"x3e345r",,,"wer",234 "bbbbbb","f345",89000,,,,,"g45",34 here , 1) empty commas should remain as...

Hi Guys , I am on ASE 12.5 on Solaris. I want to search a string in all the stored procedures and triggers in a database, how can I do that ?? Basically, in one of our tables a column is being updated by a string say 'FUNNY', I want to know from where that is happening ?? Please help. Regards

Hi all , Is there any software which will record every key stroke made on my PC, whilenormal operation is going on. Basically what I want is, the software should be running in background and should keep a record of every word/letter typed on the PC in background. This should NOT disturb normal...