SV: write to file with quick

[Jari.Kaljunen@teliasonera.com]

I am not sure of anything. We have not been running this kind of quick in batch before.
I am reading a subfile sequential and get the data from RDB with indexes which are normally very fast in qtp and quiz.

Anyhow my senior OpenVms administrator believes (after examination of system while execution of the batch) that the file is opened and closed all the time and normally he has right.
It is possible to see both the used and allocated disc space with "dir /size=all". Normally when creating a subfile only the allocated disc space is shown until the qtp or quiz is ready and closes the file. 

/Jari
 

-----Ursprungligt meddelande-----
Från: Johnson, Harold A EDUC:EX
[mailto:Harold.A.Johnson@gems1.gov.bc.ca]
Skickat: den 15 september 2004 17:50
Till: Kaljunen, Jari S. /TSS - Sergel Kredittjänster /+46-8-4526435;
powerh-l@lists.sowder.com
Ämne: RE: write to file with quick


Are you sure the performance problem is with the writing and not with the
reading of the original data?   I would suspect a problem there instead.  


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com]On Behalf Of
Jari.Kaljunen@teliasonera.com
Sent: 2004 September 15 8:41 AM
To: powerh-l@lists.sowder.com
Subject: write to file with quick


Hello,

I am writing to 

File: ASC600
Organization: SEQUENTIAL
Type: RMS
Open: ASC600
Record Format: Variable
Supersede: No
Records & Sizes: ASC600 600 bytes
Item Type Size Occ Offset
REC600 CHARACTER 600 

in quick using let and put as follows

let rec600 = "<HeaderRef2>" + asc(arnr of arenden,8) + asc(parmblnr,2) &
+ atgkod of atgkoder + "</HeaderRef2>"

put asc600 reset


The performance is very poor. The administrator believs that quick closes
and opens the file all the time. 
Can that be true?
What should I do?

We are creating an xml-file (it will be about 5 GB) with data from several
tables and our solution with qtp needed too many subfiles and sortings using
lots of space.

/Jari

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.