Recent content by blakmk

Im trying to log in to a sun Ultra5 using a serial connection and Window 2000's hyperterminal program. When the machine boots up, I can see the output on the screen but the keyboard doesnt seem to work properly, preventing me from typing in the root password.

Im trying to write some perl scripts for windows using the activestate documentation. I would have liked to use the syscall function to kick off some batch scripts but according to the activestate docco the syscall is unimplemented for this platform. Does anyone know of a workaround for...

Well it does seem to. Im running the script from a bourne shell using the following arguments: RESULT=`isql -U$USERNAME -P$USERPASSWORD -e -S$SQLSERVERNAME -D$DBNAME -e -i$SQLFILE` LOG=$? ECHO $RESULT The script does seem to throw up errors and continue running. Here is a sample of the...

Is there anyway to get a script to stop running if an error occurs. In microsft sql server running isql with the -b paramter does this but in sybase the -b parameter disables the display of the table headers output.

Are there any houskeeping tasks that need to be performed on a regular basis with tivoli storage manager?

I'm quite new to sybase and have recently been asked to support a sybase ASE 12.0 clustered environment running on solaris 7. Can anyone give me some indications of what kind of housekeeping tasks I would need to do on a daily or weekly basis. Thanks in advance

Thanks for replying, but you havn't specified exactly how to start the command in the background. I've tried using the & symbol but it doesnt seem to work on windows.

Does anyone know a way to start a dos batch command in the background. This is similar to the unix technique of preceeding the command with a & eg c:> somebatchFile.bat > logfile.bat & c:>

I know database storage requirements are different to those of standard file servers, in terms of the way that they use files etc. Does anyone know which is better for a NAS based database storage solution, SMB or CIFS? Or can offer any advice on which would be more appropriate.

Im considering consolidating the database storage for several sql server boxes onto a NAS system. I'd like to use SMB/CIFS for this. Does anyone know how sql server performs using either of these protocols? Or has any recommendations in terms of hardware at the low end of the market ~150Gb

does anone know how to set the transaction isolation level in a stored procedure?

Does anyone know of a way to get the next value of a sequence without inserting it into a table. Ie to get the value into a stored procedure variable. Thanks in advance Mark

Im not sure whats going on but when i create the following procedure using the development center it compiles ok. CREATE PROCEDURE GIRS.PR_GetNextSeqNumber ( IN i_SequenceName VARCHAR(50), OUT o_SequenceNumber INTEGER ) DYNAMIC RESULT SETS 1...

How do I get sql server to recognise a drive i've mapped on to a NAS device? The drive appears as FAT network drive and I get the following sql server error whenever I try to create a database on this disk. CREATE FILE encountered operating system error 3(The system cannot find the path...

UDB 8.1 on windows 2000