Search results for query: *

Hi, For a 'script' I have put together I needed to get the PATH variable - and convert the contents of it from: /usr/dt/bin:/usr/openwin/bin.... etc to a file... /usr/dt/bin /usr/openwin/bin I have achieved this using: echo $PATH | tr ":" "\012" This is absolutely fine, but how could you...

Is there an alternative way to testing if a table is empty other than using select count(*) from ..........? Basically I am looking for a potentially quicker test, as select count(*) from.... might take a fair bit of time if the table is quite heavily populated...

I have 2 machines and can anyone help me establish which is the better machine? Maybe by pointing me to a good web page? I have available a Sun Ultra 5/10 with 1 UltraSparc IIi processor running at 440Mhz compared with a Sun Enterprise E220R with 1 UltraSparc II processor running at...

I have a NT 'batch' which cannot be executed until some unix batches have finshed. Ideally, I would like to be able to kick off the NT batch from the unix script - anyone know of a simple method of doing this?? It's solaris 2.8 / windows 2000.

Have a piece of SQL: select INSTNUM,'',IDXCOD,INSTFREE,INSTFREE2,YLD from HIST h where DAT = (select max(DAT) from HIST h2 where h.INSTNUM = h2.INSTNUM) go which runs fine, albeit a bit slow. An unique clustered index exists for INSTNUM, DAT The subquery uses this, the outer query does...

Hi, I've thrown a script together which works ok, but it runs pretty slow. Without going into too greater detail - it searches all the stored procedures in a sybase database for a piece of text. (ie: a table name). If you imagine the following example file exists by the time the script gets to...

Like a lot of others, I am new to java/applets. I have written a basic applet which rolls through a number of jpg pics at the click of a mouse. It works fine when on my pc along with calling html code. The html, class files and jpg files are all in the same directory. The jpg files are loaded...

What command can I issue to limit the number of rows returned from a DB2 database? Thanks

Following install instructions, eg: shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell> gunzip < /path/to/mysql-VERSION-OS.tar.gz | tar xvf - shell> ln -s full-path-to-mysql-VERSION-OS mysql shell> cd mysql shell> scripts/mysql_install_db ((added...

When attempting to add a unix patch, we have received the following 'nasty' error message. We now get this every time we run pkgadd. Has anybody come across this before/any ideas how to resolve this problem? ## Executing checkinstall script. ld.so.1: /usr/sadm/install/bin/pkginstall: fatal...

what do I need to put in the .profile (ksh) to replace the need to type in stty erase <backspace> after logging in?

I cannot use 'root' to ftp onto a unix box. Other users are ok. Is their a file I need to modify in the same way that i have to modify /etc/default/login to allow root access via telnet?

Has anybody experienced a problem whereby tempdb space is used up - but after the spids have disconnected, the space is still not freed up? and what solution did they find? sp_spaceused shows on syslogs the space is still allocated. We believe a known bug is if 'trunc log on chkpt' AND...

We have a question on sizing Tempdb. We have 4 databases on an ASE 12.0 server, each at 5GB. Tempdb is currently filling up intermittently and causing us problems, I think it was sized too small to begin with at 850mb. In the Sybooks 12.0 documentation with regard to sizing tempdb, it goes...

I have seen a number of scripts which have the following at the end of the command line. I understand the & is 'background mode' but I am unsure about the other parts of 2>& 1. Can anyone clear this up? Thanks

Hi, this is my first post on tek-tips. We have a portable 'Tadpole' machine running 5.8. When the machine is on the network in London, we could not access the machine from Birmingham - so I added a default route using the following syntax: route add default 255.255.255.255 Checked ok with...