Search results for query: *

Thanks for the reply Chazoid, I just missed your response earlier. Can I just add this command to main script, not sure how to close it off, etc.. Cheers!

I have tried to add the following subroutine: sub copyDSTfile($) { # copy file to server my $copy; my $chperm; $copy = qx{ rcp -p $filename $rshUser $rshHost":"$filename }; $chperm = qx{ rsh -l $rshUser $rshHost 'chmod 755 $filename' }; ) not sure if...

I would like to parse the contents of a text file. This text file is built from a sql query. /text_file.txt Contents of text_file.txt would be: 0123456789YYYYMMDDHHMMSS 0123456789YYYYMMDDHHMMSS 0123456789YYYYMMDDHHMMSS each line will have a unique 'YYYYMMDDHHMMSS' I will need to append...

Hi PHV, Thanks for the reply. I am basically stuck at trying to write this script. I am not sure how I can parse the text file and I am not sure how to use the contents of the file to make the source and destination directory as well as filename to copy. I know what I want to do with it, but...

Hi, I orginally posted in Sun Solaris (apologies, now reposting in UNIX Scripting) Would like to use /bin/sh *nix version FreeBSD I would like to parse the contents of a text file. This text file is built from a sql query. /text_file.txt Contents of text_file.txt would be...

Hi Let me add to this request above as it woul dbe nice to have the following: Each line item in the text file is from a query to a database and has a special naming convention: example filename.txt 012YYYYMMDDHHMMSS 012YYYYMMDDHHMMSS 012YYYYMMDDHHMMSS .... each line is unique. I am using a...

Hello! I command in a script that I would like to run against the contents of a text file by adding to the script. This text file just one entry for each line, so the script would parse this: line1 line2 line3 .....etc Any help would be greatly apprecited!

Thanks that worked great!

Hello, I am new to scripting on Solaris. I need to create and run a shell script that will take some input and then perform the commands in the shell script, for example: #./shellscript.sh input contents of the script: rcp -p input user@host1:input rsh -l user host1 "chmod 755 input" So...

my bad, posted as a reply! Admin please delete above reply! (and this one!)

Hello, I am new to scripting on Solaris. I need to create and run a shell script that will take some input and then perform the commands in the shell script, for example: #./shellscript.sh input contents of the script: rcp -p input user@host1:input rsh -l user host1 "chmod 755 input" So...

I am trying to do a query comparison between a sql server v7 and a sql server 2005 and output the results in sql analyser. The db schema is the same between both servers, they reside on different machines, but are on the same physical network and subnet. I am not sure that sql server 7...

excellent! thanks gmmastros! I knew I needed to convert the int datatype was wasn't aware bigint existed! Cheers!

Hi There, When trying to run a query: select sum(col1) from table I get the following error: Server: Msg 8115, Level 16, State 2, Line 1 Arithmetic overflow error converting expression to data type int. Is there anyway to avoid this to get the results I need? Thanks!

Hi, If I have output from ls -l: drwxr-xr-x 2 root system 512 Sep 12 09:55 12sept drwxr-xr-x 2 root system 512 Sep 14 13:39 14sept what does the 2 mean in second column? there are different numbers that are possible as well, tried the man page but no luck. Thanks!

Thanks! that worked! But now I am having a problem with winxp pro clients not having the required sqldmo.dll and sqldmo.rll by default. If I install the Backwards Compatibility msi package the proper files are loaded. But this turns my small script into something really bulky. is there...

Hi, I have a vbscript that uses SQLDMO and an input file to perform a query on the sql database and return the results to a msgbox. To create the connection I use: Set objServer = ("SQLDMO.SQLServer2") and login with the current user account: objServer.LoginSecure = True objServer.Connect...

That works like a charm gmmastros! Thanks very much! and Thanks to everyone else that responded too!! Cheers!

Thanks for your replies! I tried the left and right functions but they are not suitable, at least in the way I am using them. Here is a more accurate description of what I am trying to do: when I do a select query I get results for a workstation hostname, with additional characters on the...

Hi, I have searched this forum, but I am finding it difficult to locate exactly what I am trying to do. I have a select statement, I would like to strip some of the output of the query, for example, if I get the result 'something' but I only want to show 'some' in the query result. How can...