Variable length records

[Ronald W. Olenic]

This is a multi-part message in MIME format.
--------------7CFA5E8081D7D56D7017873F
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi Cora!

As usual, I'm confused.  Do you want variable length records or do you
need fixed length (640 bytes).  
For variable length records, you can always concatenate multiple
variable length records into a temporary variable, and then write the
variable to a subfile.


(I'm guessing at this syntax)

QTP

> access bigfile
>
>  temporary t_running_count int * 8
>  temporary t_record_delimiter char * 1 initial "#"  
>  temporary t_large_temp char*3000
>
>  let t_larg_temp = t_large_temp + trunc(new_field) +   &                     t_record_delimiter 
>
>  item t_running_count count
>  subfile some_sub keep include t_large_temp &
                                 if 0 = mod(t_running_count,100)

> go 

This will write one subfile record for every 100 records read from the
original file.  The data portion of the subfile would be a variable
record ascii delimited file.


Ron Olenic
The opinions expressed are my own.  Carefully culled from years of
experience, trial and error, and error, and error, and error, and error,
and ....

CORA VANDENDRIESSCHE wrote:
> 
> 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.
--------------7CFA5E8081D7D56D7017873F
Content-Type: text/x-vcard; charset=us-ascii;
 name="olenicr.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Ronald W. Olenic
Content-Disposition: attachment;
 filename="olenicr.vcf"

begin:vcard 
n:Olenic;Ronald
x-mozilla-html:TRUE
org:Compuware
adr:;;;;;;
version:2.1
email;internet:ronolenic@bigfoot.com
title:Senior Systems Analyst
note;quoted-printable:The opinions expressed are my own, and as such are subject to change or  even complete reversal without notice=0D=0A
fn:Ronald Olenic
end:vcard

--------------7CFA5E8081D7D56D7017873F--

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.