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 Mike Lewis 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. luvrexx

    Truncating trailing zeros

    Hi, I have a query where I am multiplying A & B. A is a decimal of (15,14).Hence the result is a decimal digit with 14 positions after decimal point.I need to bring that down to 3 digits after decimal point.can anyone please help me. Thanks, Kunal
  2. luvrexx

    calculating Business days

    Hi, what are the cases and what is the logic for taking 3 as the condition.......and of doing 2 the 2-1 then 2-1.Please reply
  3. luvrexx

    calculating Business days

    Hi ddiamond, I want to exclude the weekends only. Kunal
  4. luvrexx

    calculating Business days

    Hi, Given a date range I need to calculate the no. of business days in it.Can any one help me with the sql query that i should use in QMF. Thanks, Kunal
  5. luvrexx

    Group By With Timestamp

    Hi, I am writing a query that requires a date which is a timestamp,i am using the date()fun to eliminate the hrs:sec etc part. Moreover I also need to use group by here which is creating the problem.Its showing duplicate rows because i have to use the timestamp to group by.Can anyone help,please.
  6. luvrexx

    Executil & ISPSTART

    Can anyone help me in understanding the usage and parameters used in Executil and ISPSTART in detail.I would also like to know the finctionalities of the above. Thanks, Luvrexx
  7. luvrexx

    Copying one dataset to another

    I want to write a rexx routine that will copy one dataset(PS or PDS) to another without going to 3.3 in mainframe. Can anyone help me on this. Thanks, luvrexx

Part and Inventory Search

Back
Top