Denne opdelte meddelelse er i MIME-format.
------=_NextPart_000_0059_01C19CEF.80266040
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Jon,
If it is feasible performance- and otherwise, you may write your records =
to a temporary table in your Oracle-database using QTP, and retrieve =
them again using a SQL cursor with an 'order by' statement in your =
access statement (and 'sorted by' later in the QTP-code if yor require =
the sort-break), e.g.
....
; LOAD DATA INTO temp_table
output temp_table add include key1,key2,data_element1,.....
....
; RETRIEVE DATA SORTED
declare cursor getsorted cursor for &
select * from temp_table order by key1,key2
access getsorted
....
sorted on key1 on key2
....
<rest of code>
Ole Hansen
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
E-mail: oh@scanconsult.dk Cell Phone: +45 40 40 11 50
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
ScanConsult IT-Partners ApS Voice : +45 87 38 74 74
Jegstrupvej 96A Fax : +45 87 38 74 75
DK-8361 Hasselager Support : support@scanconsult.dk
Denmark Sales : sales@scanconsult.dk
http://www.scanconsult.dk
=3D=3D=3D ParaSuite : A Suite of Air Cargo Handling solutions =
=3D=3D=3D
=3D=3D=3D ParaSafe : A Suite of IT-Security solutions =
=3D=3D=3D
=3D=3D=3D We partner with Hewlett-Packard, Cognos, Lotus and others =
=3D=3D=3D
-----Oprindelig meddelelse-----
Fra: Boyle, Joe <Joe.Boyle@cognos.com>
Til: 'Jon.Kvisli@lindorffapplications.com' =
<Jon.Kvisli@lindorffapplications.com>; powerh-l@lists.swau.edu =
<powerh-l@lists.swau.edu>
Dato: 14. januar 2002 10:34
Emne: RE: QTP scratchfile 2 GB limit?
=20
=20
Hi Jon,
=20
there is no way around this limitation using the Unix platform. It =
is hoped that the 8.4 release will be able to handle larger file sizes, =
but this is not due out for some time, and may not contain the new =
feature.
=20
The only solution I am aware of in similar situations, is where PH =
has been available on other platforms such as Mpe/ix or Openvms, and =
those servers have been used to process a portable subfile and the =
resulting subfile ( which is now less than 2 Gig and pre-sorted ) =
ported back to the Unix platform for processing.
-----Original Message-----
From: Jon.Kvisli@lindorffapplications.com =
[mailto:Jon.Kvisli@lindorffapplications.com]
Sent: 14 January 2002 08:10
To: powerh-l@lists.swau.edu
Subject: QTP scratchfile 2 GB limit?
=20
=20
=20
We have a problem with qtp terminating with the following =
error-message:=20
=20
Error on scratch file. =
=20
=
=20
Action Taken: Run terminated.=20
=20
We have 16 GB free disk space for scratch files, but the problem =
seems to occur when the file reaches 2 GB size..=20
Is this a known limitation in qtp?=20
If so, are there any configurable parameters in PH where this =
can be changed?=20
=20
We are running PH 8.23.D4 on HP-UX and Oracle8i.=20
=20
Jon Kvisli
----------------------------------------------
Senior systemkonsulent
Lindorff Applications as
Hellandtunet forsknings- og n=E6ringssenter
Postboks 4, 3833 B=F8 i Telemark
tlf: 35 06 15 71
fax: 35 06 15 01
e-post: jon.kvisli@lindorffapplications.com
www.lindorffapplications.com
----------------------------------------------=20
=20
=20
=20
This message may contain privileged and/or confidential information. =
If you have received this e-mail in error or are not the intended =
recipient, you may not use, copy, disseminate or distribute it; do not =
open any attachments, delete it immediately from your system and notify =
the sender promptly by e-mail that you have done so. Thank you.
------=_NextPart_000_0059_01C19CEF.80266040
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
Jon,
If it is feasible =
performance- and=20
otherwise, you may write your records to a temporary table in your=20
Oracle-database using QTP, and retrieve them again using a SQL cursor =
with an=20
'order by' statement in your access statement (and 'sorted by' later in =
the=20
QTP-code if yor require the sort-break), e.g.
....
; LOAD DATA INTO temp_table
output temp_table add include=20
key1,key2,data_element1,.....
....
; RETRIEVE DATA SORTED
declare cursor getsorted cursor=20
for &nbs=
p; =20
&
select * from =
temp_table order by=20
key1,key2
access =
getsorted
....
sorted on key1 on key2
....
<rest of code>
Ole =
Hansen
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
E-mail=
:=20
oh@scanconsult.dk =
=
Cell Phone: +45 40 40 11=20
50
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
ScanConsu=
lt=20
IT-Partners=20
ApS &nbs=
p; =20
Voice : +45 87 38 74 74
Jegstrupvej=20
96A &nbs=
p; =
; =20
Fax : +45 87 38 74 75
DK-8361=20
Hasselager &nb=
sp; =20
Support : support@scanconsult.dk
Denm=
ark &nbs=
p; =
; =20
Sales : sales@scanconsult.dk
&n=
bsp; &nb=
sp; =20
http://www.scanconsult.dk
=3D=3D=
=3D =20
ParaSuite : A Suite of Air Cargo Handling=20
solutions =
=3D=3D=3D
=3D=3D=3D =20
ParaSafe : A Suite of IT-Security=20
solutions &nbs=
p;=20
=3D=3D=3D
=3D=3D=3D We partner with Hewlett-Packard, =
Cognos, Lotus and=20
others =3D=3D=3D
-----Oprindelig=20
meddelelse-----
Fra: Boyle, Joe <Joe.Boyle@cognos.com>
T=
il:=20
'Jon.Kvisli@lindorf=
fapplications.com'=20
<Jon.Kvisli@lindorffap=
plications.com>;=20
powerh-l@lists.swau.edu =
<powerh-l@lists.swau.edu>Dato:=20
14. januar 2002 10:34
Emne: RE: QTP scratchfile 2 GB=20
limit?
Hi=20
Jon,
there is no way around this limitation =
using the=20
Unix platform. It is hoped that the 8.4 release will be able =
to handle=20
larger file sizes, but this is not due out for some time, and may =
not=20
contain the new feature.
The only solution I am aware of in =
similar=20
situations, is where PH has been available on other platforms such =
as Mpe/ix=20
or Openvms, and those servers have been used to process a portable =
subfile=20
and the resulting subfile ( which is now less than 2 Gig and =
pre-sorted=20
) ported back to the Unix platform for=20
processing.
-----Original Message-----
From:=20
Jon.Kvisli@lindorffapplications.com=20
[mailto:Jon.Kvisli@lindorffapplications.com]
Sent: 14 =
January=20
2002 08:10
To: =
powerh-l@lists.swau.edu
Subject: QTP=20
scratchfile 2 GB limit?
We have a problem with qtp terminating with the =
following=20
error-message:
Error on =
scratch file.=20
=
=20
=
=20
=20
=
=20
=
=20
=
=20
=
=20
Action Taken: Run terminated. =
We have 16 GB free disk space for =
scratch files,=20
but the problem seems to occur when the file reaches 2 GB size.. =
Is this a known =
limitation in=20
qtp?
If so, are =
there any=20
configurable parameters in PH where this can be changed?=20
We are running PH =
8.23.D4 on HP-UX=20
and Oracle8i.
Jon=20
=
Kvisli
----------------------------------------------
Senior=20
systemkonsulent
Lindorff Applications as
Hellandtunet =
forsknings-=20
og næringssenter
Postboks 4, 3833 Bø i =
Telemark
tlf:=20
35 06 15 71
fax: 35 06 15 01
e-post:=20
=
jon.kvisli@lindorffapplications.com
www.lindorffapplications.com
--=
--------------------------------------------=20
This message may contain privileged =
and/or=20
confidential information. If you have received this e-mail in error =
or are=20
not the intended recipient, you may not use, copy, disseminate or =
distribute=20
it; do not open any attachments, delete it immediately from your =
system and=20
notify the sender promptly by e-mail that you have done so. Thank=20
you.