Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kathi
  • Order by date
  1. kathi

    Stored procedures vs. Dynamic SQL

    I wouldn't assume that using stored procedures would make it more difficult to port your application. We've recently done this and in fact it's the SQL in the application that presented the bigger headache.
  2. kathi

    Validating Numbers & Strings

    I need to inspect some varchar variables in a SQL Stored procedure in UDB DB2 v8.1, to determine whether their contents are all numbers or whether there are some non-numeric characters in there. I cannot change the datatype - it has to be a varchar. We were able to do this in Sybase using the...
  3. kathi

    ls question

    Thanks. I got round this in the end by using find, but that gave me the whole directory listing too. Eventually stripped this out using basename. Original code: for usename in `ls pbe_rep*.txt` do Replaced by: for usename in `find $LOCATION -name "pbe_rep*.txt"` do...
  4. kathi

    ls question

    I have a script which involves an ls on a directory which contains files derived from an external source. All works fine, but VERY occasionally we get a massive number of files and the ls throws the following error: /usr/bin/ls: 0403-027 The parameter list is too long. Is there anything I...
  5. kathi

    Killing a background process

    Thanks for the help - I bodged it with a file that holds the pid and retrieves it when you run the stop script, but I may investigate some of these.
  6. kathi

    Killing a background process

    The problem I'm having is really in identifying and sending the signal and am having problems with the man pages on this box (unfortunately I don't really have control over it)
  7. kathi

    Text replacement within a file

    This might work and it's simple tr 'FRED 10' 'PETE 20' < file1> file2
  8. kathi

    Killing a background process

    I have a script running some code as a background process via nohup. I need to be able to run a script which will kill that process. I've tried to get the pid and kill it but am having trouble with that. There has to be a simple command for non-unix people to use to stop the service - i.e. I...
  9. kathi

    rexec on RS6K

    Possibly a dumb question... From a W2K server I can use rexec to perform commands such as date and who on a RS6K, however I really need to execute a script on the RS and get the output to go to a file that I can then ftp back from the RS. Additionally I can't seem to find how to include the...

Part and Inventory Search

Back
Top