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 derfloh 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: ejaggers
  • Content: Threads
  • Order by date
  1. ejaggers

    Need help with case stmt

    How do you label the column using a case stmt? I want the prem_term_date case labe to be "DISABLED", but AS "DISABLED", gives me an error. SELECT prem_fname || " " || prem_lname AS NAME, " " AS LOGON, " " AS EMAIL, CASE WHEN prem_term_date IS NOT NULL AND...
  2. ejaggers

    Help Find Max record using SQL

    I only want the record with the largest FTE, but I don’t want the FTE in the output. example: Select a, b, c from table where x = MAX(x) Data: a b c x --------------------- sam 111 aaa 1 sam 222 bbb 2 sam 333 ccc 3 bob 555 eee 8 bob 222 bbb 4 bob 999...
  3. ejaggers

    Help w/ date sql

    How can I select dates where date > currectDate - 120
  4. ejaggers

    Return value from subroutine

    Is the rtn value from sub() in a special variable, so I don't have to call sub() twice? i.e.: $x = $1 if sub(); I'm doing this: $x = sub() if sub(); I don't want $x set if sub() returns false.
  5. ejaggers

    Need help learning rsync

    I want to move some files in /etc from box pentapp1 to boxes pentapp2 and pentinf1. I also want to create /home directories from pentapp1 if they don’t exist on pentapp2 and pentinf1, but not copy the contents of the directory. I can’t find a tutorial that is helpful. To get the feel of rsync...
  6. ejaggers

    Garbage in output file when using cron.

    I run this code in cron using open(OFH,">$logFH"), and got the first line in the output file with no garbage. But open(OFH,">>$logFH"), gives me garbage at the beginning of the line. However it does NOT give garbage when running it from the command line. Can anybody help??? tt.pl...
  7. ejaggers

    Weird characters in sysout/syserr

    My new Redhat 5.3 system prints weird characters to the screen. i.e. Some, but not all of the lines in the man pages: man ls -C list entries by columns --color[=WHEN] control whether color is used to distinguish file types. WHEN may be ?Çÿnever?ÇÖ, ?Çÿalways?ÇÖ, or...
  8. ejaggers

    Keeping users in sync on different boxes (passwd)

    I have 3 RedHat 5.3 boxes, and I would like to create a user on box1 and automatically create users on box2 and 3. This is what I’m thinking: 1. keep a copy of passwd (passwd.bac) 2. find new users using diff passwd passwd.bac 3. get password from shadow file 4. make useradd.sh with only new...
  9. ejaggers

    laptop powers off by it's self

    I've been ripped off twice, trying to get my daughters laptop fixed. It powers off for no reason. When she came home from college (twice), I tried having it fixed, and when she went back the problem occured again. The 1st guy said over heating and charged me $90. The second charged me $60. So I...
  10. ejaggers

    Going from UNIX TRU64 to REDHAT 5.3

    Need Help With A Few Linux Commands: T64: more xxx - clears the screen and displays file xxx, but does not return to the command line until I enter space or CR. RH: How do I get more on Linux to wait on me? If xxx is less than a screen, more displays and returns to cmd prompt w/o waiting...
  11. ejaggers

    Ready to learn complex data types

    I wrote a utility awhile back that gives me DBA info using Informix onstat commands. The following is the onstat –g ses command, which I want to see sorted 4 different ways. So I created 4 hashes. I’m not familiar with complex data structures because I taught myself Perl, and I’m not there yet...
  12. ejaggers

    Dynamic foreach loop

    I have a foreach that key sorts a hash. The keys can be either all numeric or alpha-numeric. Is there a way to not repeat the foreach, and dynamically sort? i.e. my @sortTpye = ( ‘sort’, ’sort{$a<=>$b}’ ); foreach ( &{“$sortType[$i]”} %hash ) { … }
  13. ejaggers

    Find cmd works on UNIX but not LINUX in Perl script

    I have a Perl script that searches all files starting in the home directory for a string. i.e. file /usr/users/myhome/xzy contains the strings ‘theKing’ and ‘THEKING’. The UNIX command: find /usr/users/myhome -name '*' -exec grep -csi 'theking' -exec grep ls -l {} \; Lists all files and...
  14. ejaggers

    SFTP in Batch!!! Can Anyone Help

    How do you use sftp in batch? It keeps prompting for password, but I need to run it in the cron. Can Anyone Help!!!
  15. ejaggers

    Can't execute a script from a diffent userid

    I can't run a perl script from user informix but can from user ejagger. All permissions on all files and directories in ../Lib/... are chmod 775 *. I'm running on Linux 5.3. Can anyone help me? Perl Script mm.pl: #!/usr/bin/perl use UtilityLibrary; $x = $Today(); print "today is...
  16. ejaggers

    Can't execute a script from a diffent userid

    I can't run a script from user informix but can from user ejagger. All permissions on all files and directories in ../Lib/... are chmod 775 *. I'm running on Linux 5.3. Perl Script mm.pl: #!/usr/bin/perl use UtilityLibrary; $x = $Today(); print "today is $x\n"; Script...
  17. ejaggers

    How do you set an environoment variable

    I want to set an env variable in a Linux shell, LOGx where x=1,2,3, or 4. If x was 1 last time then ++$x; Shell: LOG=logname concat'ed with $x I came u with a perl script to handle $lognum but how do I get ksh to see it; i.e. #!/usr/bin/perl my $logFH =...
  18. ejaggers

    New Red Hat 5.3 server

    We just got a Linux server and we are migrating from UNIX TRU 64. I may need a little help getting started. What are you using to manage users. I’ve heard that VCN viewer and GNOME can be install on the desktop. Any suggestion what I should use, and where to get it?
  19. ejaggers

    Are there any tricks with split?

    The way I pick a field using split is (for instance): $list = 'a b c d e f g'; (@x) = split(' ',$list); $myvalue = $x[5]; Is there a way to tell split which field you want? ($myvalue) = split(' ',???) only return the 6th field???
  20. ejaggers

    Updating one table with another

    I need to update the column reg_user.fld01 with the value of reg.yearofgrad for the correct studentid: - update reg_user - set reg_user.fld03 = reg.yearofgrad - where reg_user.screen_num = 11 Table reg Column name Type Nulls...

Part and Inventory Search

Back
Top