Variable length records
SGreenspon@STSSystems.com
SGreenspon@STSSystems.com
Tue, 29 Feb 2000 15:47:34 -0500
Quiz might have a restriction, but QTP doesn't (as far as I know).
You could create a subfile in QTP, and the resulting .sf (or .dat if you use
the NODICT option) file could be the body of your text file.
Couple of things to keep in mind..
1) Anything you write to the subfile needs to be a string.. if you are
dealing with numbers or dates, make a define.
2) Each line should be terminated with a carriage return (ascii 10)
Given a file called CUSTOMERS that contained...
CUSTOMER-NAME CHAR*30
CREATED-DATE DATE
QUANTITY NUM*04
.. we could dump the information into a flat text file as follows:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ACCESS CUSTOMERS
DEFINE DEF-CRA INTEGER*02 = 10
DEFINE DEF-CR CHAR *01 = CHAR(DEF-CRA)[2:1]
DEFINE DEF-CREATE-DATE CHAR*8 = ASCII(CREATED-DATE OF CUSTOMERS,8)
DEFINE DEF-QUANTITY CHAR*4 = ASCII(QUANTITY OF CUSTOMERS,4)
SUBFILE MYFILE NODICT KEEP INCLUDE &
CUSTOMER-NAME OF CUSTOMERS, &
DEF-CREATE-DATE, &
DEF-QUANTITY, &
DEF-CR
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-----Original Message-----
From: CORA VANDENDRIESSCHE [mailto:cmvandendrie@cambrianc.on.ca]
Sent: Monday, February 28, 2000 3:27 PM
To: POWERH-L@lists.swau.edu
Subject: Variable length records
We need to create an ascii delimited file with variable length records.
(One of the record types has a length of 640 bytes therefore we can not use
quiz to create a report file that has a limit of 255.)
Can you create an ascii file using powerhouse with variable length records
that exceed 255 ?
Cora Vandendriessche
Manager Software Development
Cambrian College
cmvandendrie@cambrianc.on.ca
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.