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 Rhinorhino 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: UCF87
  • Order by date
  1. UCF87

    New to SQL

    I think I about got it, but I am getting NULL index numbers. DECLARE @COUNTCOL INT DECLARE @NEWTITLE VARCHAR(50) SELECT rptTitle, SUBSTRING(rptTitle, 1, @COUNTCOL)+ 'Detailed Statement of Income - Dept' FROM ReportRules WHERE (rptTitle LIKE N'%(0001)%') ORDER BY rptTitle SELECT @COUNTCOL
  2. UCF87

    New to SQL

    The table name is ReportRules The column names are rptTitle and rptRuleDescription rptTitle and rptDecription have the same information. (rptTitle is the actual title the user sees and rptDescription is for the administrator for a quick reference in the software) problem: Need to change part of...
  3. UCF87

    Windows XP to AIX FTP Command

    1. I need to know where in the command I place the userid and password? Is there a way to get around it just for a file transfer? :-D 2. Can a specify on AIX the exact directory path where to place the file? What would be the syntax ftp -n -s:\CMAX\dls.prt 125.9.99.99 /Path? Thanks for you...
  4. UCF87

    Removing leading space in a file

    sed "s/^0/0/g" file > newfile This works... I was making this too complicated. Other zeros are moved but does not corrupt the file.
  5. UCF87

    Removing leading space in a file

    well shoot, I have tried every tr and sed sequence I can think of and still can not remove the space. Thanks for your help anyway.
  6. UCF87

    Removing leading space in a file

    What application uses trim? Forget to mention I am on AIX 5.1.
  7. UCF87

    Removing leading space in a file

    Need a way to remove the space before 0444 and 0068(bottom) without affecting other data in the file. I have about 730 numbers in this file that I need to remove the leading space. Thanks in advance. Sample data: dscoggi CAPVBRET 55 55 Transfer output file VENBAL to 2...
  8. UCF87

    AIX 4.3 - 5.1 difference ??

    That is exactly what is happening. For some reason "something" is creating a -346 directory on our NFS mounted drive (NT Server). It is not being created in AIX because it will not allow you to create a dash in front of a directory name. We are unable to determine at this time how...
  9. UCF87

    AIX 4.3.2 verses 5.1

    I found the problem, I had a -386 directory. Once I deleted it, it ran ok. Thank you for responding
  10. UCF87

    AIX 4.3.2 verses 5.1

    Tried that already... same error.
  11. UCF87

    AIX 4.3.2 verses 5.1

    ...specified flag is not valid for this command. Script: for DIRA in `ls` do if [ -d $DIRA ] then cd $DIRA <--- Line failure ls dis* > /dev/null 2>&1 if [ $? -eq 0 ] then pwd > /lcca/work/tmp/faclist fac=`cut -c17-21 /lcca/work/tmp/faclist|head...
  12. UCF87

    AIX 4.3 - 5.1 difference ??

    ...specified flag is not valid for this command. Script: for DIRA in `ls` do if [ -d $DIRA ] then cd $DIRA <--- Line failure ls dis* > /dev/null 2>&1 if [ $? -eq 0 ] then pwd > /lcca/work/tmp/faclist fac=`cut -c17-21 /lcca/work/tmp/faclist|head...
  13. UCF87

    If Statement question

    Is it possible in an if statement, to determine if a variable contains a two or three digit number? Then I will need to add 2 or 1 preceeding zero(s) to that number respectively.
  14. UCF87

    searching for a specific Pattern

    Thank you! That worked.
  15. UCF87

    searching for a specific Pattern

    The ^ for begining of line still does not capture and print CCCC only. Maybe AWK does not work well with spaces? I want the output to show all occurrences of any lines without numbers.
  16. UCF87

    searching for a specific Pattern

    I have the following input: AAAA011 BBBB022 CCCC EEEE222 FFFFF333 ~ I want to create an exception report to find CCCC, without knowing what CCCC is. I have tried: awk '{if($1~/.... */) print $0}' input > output Thank you in advance
    • UCF87
    • Thread
    • Replies: 5
    • Forum: AWK
  17. UCF87

    qadm -U command

    Thank you, this will help
  18. UCF87

    qadm -U command

    With the qadm command you need to be SuperUser. Is there a way to give access to only this command to someone who is not a su?
  19. UCF87

    SQL Statement timesout

    dkyle: Now I get: Query designer does not support SET STATEMENT SQL Construct.
  20. UCF87

    SQL Statement timesout

    Still got Time out expired..

Part and Inventory Search

Back
Top