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!

  • Congratulations TouchToneTommy 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: *

  1. awood69

    KORN Copy file with PID and rename it

    I have a file named like this report_nbr.xml.2356 need to copy it and call it report_nbr.xml Very new to KORN, need all the help I can get. Thanks
  2. awood69

    KORN Remove PID from FIlename

    Very cool thanks a lot!
  3. awood69

    KORN Remove PID from FIlename

    Is there a way to do it without using the " * "?
  4. awood69

    KORN Remove PID from FIlename

    I have a file name like this report_name.xml.12345 where the 12345 was added by using the $$ I need to remove the .12345 from the end of the filename before I email it out. Thanks in advance.
  5. awood69

    Number Formatting in XLS

    Andy, thanks for the response but that will still show the decimal.
  6. awood69

    Number Formatting in XLS

    I need to be able to use the same style for multiple number formats. For example, I need to show anywhere between 0 & 2 decimal places. I have this like below - <NumberFormat ss:Format="#,###.##;[Red]\(-#,###.##\)"/> Problem is I get the following results and I need to not show the decimal...
  7. awood69

    SQR to XLS Column Number

    I have a sqr program that I am using to create a XLS file. I need to be able to enter what column I want the data printed to. Like below but need the 1, 2, 3 to represent the column number in XLS. do xml-init-column(#xml_file_number, 1, 48) do xml-init-column(#xml_file_number, 2, 51) do...
  8. awood69

    ksh for each file in a directory

    Newbie to ksh any help would be appreciated. I need to loop through a directory and copy all the *.xls files to a different directory based off of what value is returned by a sql query. Something like this... for each file in folder where file like *.xls run sql cp to new folder
  9. awood69

    to_number PL/SQL

    If I change the data to - 11, 12 and use select * from region where email_flag = 'Y' and ((region in(SELECT comments from report_dist where group_type = 'PLT01') and 'PLT01' like 'PLT%') or 'PLT01' NOT LIKE 'PLT%') order by region I...
  10. awood69

    to_number PL/SQL

    If i change the data to a single number then it works. Maybe I need another approach?
  11. awood69

    to_number PL/SQL

    Thanks but that didn't work still get - Example data - '11, 12' ORA-01722: invalid number select * from region where email_flag = 'Y' and ((to_char(region) in(SELECT to_number(comments, '99') from report_dist where group_type = 'PLT01')...
  12. awood69

    to_number PL/SQL

    I get ORA-01722: invalid number select * from region where email_flag = 'Y' and ((region in(SELECT to_number(comments, '99') from report_dist where group_type = 'PLT01') and 'PLT01' like 'PLT%') or 'PLT01' NOT LIKE 'PLT%') order by region
  13. awood69

    to_number PL/SQL

    I a column names comments, the record I am working with has the following value in comments - '11, 12' I want to use this select statement as a sub query that would replace the 11, 12 for region in the bottom statement - SELECT to_number(comments, '99') from report_dist where group_type =...
  14. awood69

    sqlplus and Korn case statement

    Thanks but that didn't do it, I get the same messages.
  15. awood69

    sqlplus and Korn case statement

    I keep getting these errors... unknown command beginning "case "PLT0..." - rest of line ignored unknown command beginning "PLT01) sql..." - rest of line ignored unknown command "esac" - rest of line ignored For a list of known commands enter HELP to leave enter EXIT here is my code function...
  16. awood69

    sqlplus and Korn case statement

    The code was just to try and get my point accross, you are right it is not for either ksh or oracle. I am moving over from a Microsoft world to oracle and unix and seem to be having some challanges. If I wanted to include an else do I just? case "$var" ZZZ) sql='one statement' ;; DDD)...
  17. awood69

    sqlplus and Korn case statement

    I have a function and based on a parameter I need to call different sql statement something like below? function get_regions { sqlplus -s <<EOF $CONNECT_DB2 set pause off set heading off set pagesize 0 set feedback off Case $var = "XXX" case ZZZ do this sql statement case DDD do this...
  18. awood69

    Korn string compair

    Thanks that fixed my problem.
  19. awood69

    Korn string compair

    I am new to Korn program and trying to do a simple task. $group_type = "PLT01" if [[ $group_type == PLT* ]] then print "Success" fi Not sure why this will not work?

Part and Inventory Search

Back
Top