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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

9700sql

Status
Not open for further replies.
davidstanley01

davidstanley01

Programmer
Nov 29, 2010
3
US
Anyone experienced at using 9700sql utility? I'm trying to get a the tracking group totals by cashier from the system via the cashier totals file and am having some issues.

I'm using the following in my script:

Code: 
OUTPUT_TO d:\csh.out
MAX_FIELDS_PER_LINE 4
MAX_LINE_LENGTH 64
PAD_NUMBERS OFF
PAD_STRINGS OFF
FIELD_SEPARATOR , 
SELECT * FROM cshr_ttls.1
the output is pretty much unreadable. further, I'm not quite sure how to get the system to iterate through all sub-records and all revenue centers. any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top