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

thanks for the input guys.. based on the latter 'if exists' concept - I have seen in practice that this is faster. this is good as this will be part of a process which polls the database regularly.

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

Here is some information that may help. To create an identical structure of the database, you could use Sybase Central, right click over the name of a database: and select Generate Create Database DDL - to get the SQL to build the database - which you can alter to use different devices...

thanks for the information... E220R seems the better option..

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

For me, the 1st solution just returns nothing at all.

I'll revisit the suggestion and let you know!

Thanks for replies,,,, Couldn't seem to get the 1st and 3rd suggestions to work. (using ksh) However this works mostly: awk ' /TESTDATA/ {print prev} {prev=$0} ' $scripthome/sp_text2.tmp except, rather than searching for TESTDATA each time, the test will be for different strings. I...

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

That works fine, great. Basically I am working with an unfamiliar database at present and this helps quickly look at sample data.

Additionally: I am accessing the database via ODBC drivers and WinSQL.

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

I was told by the guy who did the reboot it was in single user mode but he didn't sound too convincing to me. Would this be a likely cause?

We have had to restore the machine as it would not boot up! The output we NOW have from that command is: $ ldd -r /usr/sadm/install/bin/pkginstall libadm.so.1 => /usr/lib/libadm.so.1 libnsl.so.1 => /usr/lib/libnsl.so.1 libsocket.so.1 =>...

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