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

    load a usage comp field from a COBOL/DB2 flat file into Teradata

    I have an input file that was created in a COBOL program that extracted the data from DB2. The file layout is as follows: 01 DCLGFTRSTY. 10 GFTRSTY-RGS-ID PIC S9(9) USAGE COMP. 10 GFTRSTY-LOC-NBR PIC S9(9) USAGE COMP...
  2. hmoe

    How do I load a char field in text file into a decimal(7,2) field?

    I have a file that I'm trying to load into Teradata. The field is defined as a char(7) in the .layout and I need to load it into a decimal(7,2) field in Teradata. I thought a definition of (7,2) means 5 digits before and two digits after the decimal. My data isn't appearing correctly in the...
  3. hmoe

    forcing a different evaluation time in a running total

    I'm running version 10 and my report needs to calculate a percentage using a grand total that is created with a running total. It looks like the totals and percentages are being calculated during the same pass. I need the grand total for the # ordered to calculate first so that I can use that...
  4. hmoe

    Using Distinct count formula

    I am a fairly new user to Crystal and I'm creating a summary report that keeps track of the number of orders received for a particular credit card. I created the first couple of columns using running totals and I inserted summaries to display the percentage of usage by credit card. That part...

Part and Inventory Search

Back
Top