Arrays in Qtp

[Walker, Chris]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_000_01BE77A2.2381CA70
Content-Type: text/plain

For smallish arrays I would cheat by using a macro in my TPU editor that
replicates a selected block with embedded numbers (not a very coherent
explanation, but it produces the 30 defines without having to type them
all).

For big arrays you could start your QTP run by writing a subfile containing
one record holding the array index for each array element.  Depending on
your access statement, this could either be a sequential file that becomes
the new master file (eg Access *index link <expression> to RRR), or it could
be an indexed subfile linked from the existing master (eg Access RRR link
"X" to dummy_key of *index).  This will give you a record complex for every
occurrence in your array, so you can write the subfile in one statement:
Subfile subfile_name if qualification(no of index) ne " " include
qualification(no of index).

Chris Walker
Tate & Lyle
London



> -----Original Message-----
> From:	Ray Bailey [SMTP:rayb@specialist.co.uk]
> Sent:	Friday, March 26, 1999 3:25 PM
> To:	Cognos Mailing List
> Subject:	Arrays in Qtp
> 
> VMS 7.1 P/H 710G & HPUX 10.2 P/H 7.33.d3
> 
> Picture the following
> 
> Record RRR layout
> 
> NAME        	Char*10
> QUALIFICATION	Char*5 occurs 30
> 
> I want to create a subfile holding one record per valid QUALIFICATION so I
> tried the following.
> 
> Access RRR
> 
> Subfile SUBFILE_NAME keep alias SUB_01 &
> 	if QUALIFICATION(1) ne " " &
> 	include NAME, QUALIFICATION(1)
> 
> Subfile SUBFILE_NAME keep alias SUB_02 &
> 	if QUALIFICATION(2) ne " " &
> 	include NAME, QUALIFICATION(2)
> 
> ~~~~~~~~
> 
> Subfile SUBFILE_NAME keep alias SUB_30 &
> 	if QUALIFICATION(30) ne " " &
> 	include NAME, QUALIFICATION(30)
> 
> 
> This seems to be okay with the subscript being specified on the IF option
> but not as part of the INCLUDE.
> 
> Does anyone know any way I can do this without having to define thirty
> items
> or creating a redefinition in the dictionary.
> 
> BTW I've allow tried it specifying "of RRR".
> 
> 
> Ray Bailey
> Leicester
> England
> 
> 
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> =
> Subscribe: "subscribe powerh-l" in message body to
> majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
> This list is closed, thus to post to the list, you must be a subscriber.

------_=_NextPart_000_01BE77A2.2381CA70
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IgkQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAAzwcDABoADwA7AC0ABQBvAQEggAMADgAAAM8HAwAa
ABAAAwAHAAUAEgEBCYABACEAAAA5OTk1RjFCQzgwRTNEMjExODZGQjAwMDhDN0ZBQzFDNAA+BwEE
gAEAEgAAAFJFOiBBcnJheXMgaW4gUXRwAK8FAQ2ABAACAAAAAgACAAEDkAYAxAsAAC4AAAADAACA
CCAGAAAAAADAAAAAAAAARgAAAABShQAAtw0AAB4AAYAIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAAB
AAAABAAAADguMAADAAKACCAGAAAAAADAAAAAAAAARgAAAAABhQAAAAAAAAsAA4AIIAYAAAAAAMAA
AAAAAABGAAAAAAOFAAAAAAAACwAEgAggBgAAAAAAwAAAAAAAAEYAAAAADoUAAAAAAAADAAWACCAG
AAAAAADAAAAAAAAARgAAAAAQhQAAAAAAAAMABoAIIAYAAAAAAMAAAAAAAABGAAAAABGFAAAAAAAA
AwAHgAggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAeAAiACCAGAAAAAADAAAAAAAAARgAAAAA2
hQAAAQAAAAEAAAAAAAAAHgAJgAggBgAAAAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAB4A
CoAIIAYAAAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAAACAQkQAQAAAJMGAACPBgAAsgsA
AExaRnUN6x4qAwAKAHJjcGcxMjXSMgD7MzYB6CACpAPjCQIAY2gKwHNldDAeIAcTAoMAUBBWcHJx
3jIRWQ5QA9URZX0KgAjIbCA7CW8OMDUCgAqBdbZjAFALA2MAQQtgbg4QSDAzMwumIEYFsXNJAMBs
bAQAaCAKwHJEYXkEIEkgdwhgbCRkIBDQZWEFQGJ53CB1AJAYABmwIADBA2AOIAuAG7AbIFRQVSDp
CYBpdAWxdBDgBUAJcL8LUA3gGuAHkRugERBsBZDHHfAakAJgb2NrGkAc4D0ZoGUG0AmAAQAakG51
wx+hEQAgKG5vBUAboP52BJAbIAWgGsAJcAIwHLCqeAtRbhrgaQIgLBsA9nUFQBzgIBKgBHAXEAeR
8R0wZSAzEUABAQuAB5HvH0IIYAVAEOB2G2Ic8B0gbHlwI+AjwW0ZsBlgKZ4uCqIKhAqAGPJiaRuB
3RnUeQhgIVEacnMBkAAg2yhiBcBRHIAdcHUDoBsRjncFECJgG3NzdWIkUP8ecCFRAjALcRtiAiAj
4Alw/wWhGpAk4BqAJWMj0RnDHBH5AQB4IAIQBcAa0BDQLaWHHmEHgAIwLiAgRB2Q/wnwLSMCIClk
ANAjgQQgKRG/HfAvkiKgHTAEACilZR9R7wSQGwAtkR5BcQpQAjAHMf8uYCtSHTMfsAWgB4IjwiRw
nwfgAMApEDMxK0MoZRuAWkExNCouFBlwbh8gPK8h8QlwBBAicT4lklI5MP4pIqAFsSMBKLQzYgOg
LhP/HrErFjfiHrEDUiOzIfAEAB8qozYFNsk5MTfUIlgiayWSI2BtHFBfO+AbIG/uZjdlJqAv4FQy
UgPwGWD4IGdpIRAoYxugLIU1Ie8LUC5GIRMfAGMIcCGhI4DvHBIw1BnSIqBzHAAocwORvypyJgMr
BxwhLEIxlzoGAPsrJSsVXyJAB4AcEEAQM9D/B0AGkB3CInEgoT/yQEQ1sfc+4EuRC4BjCkABAEm/
SsjZJrtDaAUQBCBXB0A74ApyJsRUHeEgJiBM1nkecCbETAIgZAIgJsr/Uc4LMBlwDzEXkQFAIzEd
8EMekBHkMTYgLVTiTy8FEEFwIkADIE0xUWFnfmVU4ybGU/RTwQsTU/ZpMC0xNDQBQBlwMThuMAFA
DNBYg2IY4ANhOtUMg2IRQFIt4UILcB5wURsgW1NNHIA6GeFitEBzJfBjBzE80S4FoPAudWtdJsVZ
sAZgSAHTWiZZ0GlkRRJNCsAu0WQyNiKgMTlfoCPwOpEOMCBQTV0XVG9aF30IUGcgsAQgXvADEBti
TPc80V0YKyBqHoFaFwcQGePxHCFRdHBWj1eaU0QX4rkB0DU3E3QMASbTVgXhyDcuMWAgL0ho4Bgg
KkdQMUgckFhfgDAuyxLQaTMuGEAuZBhQJtl6UA3gdAhwRkQCEBlgb/cD8BgAJspSLJQ+YxnwJPHh
JspOQU1FL+BwFAyCG2GAEOEqGCAmxFFVQQBMSUZJQ0FUSfxPTnCYYBBDswQgJAAmyv8aMQBwBUAl
oQUAGtEzcysl7yz2LEkl8AXAdkyBGpBxu/VFQkkmxHQIgRqQbHsmu0c9+CbKSEZTVUJyAEz8RV9v
0zvgHZAmYQcwBkHpfYBfMGkQJibFcKJJkflxuygxS1d/a0v1b9IioH+AXnw/fU9+XRLQf2+AejLv
gU+CX4iPJsp+jXWEf4WP/35cJAGHr4B6JACJj4qfkg//hGtPlTJSERAfkCOhHAAzYfxvay3hH0NG
ZQT1H7AbYv9cAyRQHrEwoSPCcfAsMAUw/yJxJsQiwiCzBCAKsQVAQAGBmzNOQ0xVREUmu7REbx4C
bihwLFFrILD/B+CfYXShGyAaMEXCUTAyNP8kvyQlMjIAIC3xMcEQoCbT/wWxdTMbZAlxJEIqkTCh
HCFfI8Ic0B6QInEKwHkmu0L0VFcaICdBkRlRn/F5lGsjAZpkeRtiIkABOTEi/ya7baVat1ClMvAj
gTYxJsSeRRgAF+ELMVHuPSCvL/+wP7FPsl+yw45XBPIfsEggNiKZZTNhcGzwBJBoLf5sS8IbsFXU
GwAEcBsgJaFNAMBqLLEDcG9AXGJz4i4D4GF1LgmADHAm0/5VAIC0SSoQtP+2DLc/uE7vuua8/RwQ
BCBnHeGgYZrTb1YgoGKYIhzgLr0DBJB2/i665pcZXGK/skwAYdAJgP8yIhtAJZK64MNhJaIj0Vxi
eyKgKHJtG0A04irktGRyCya1FJEAyBAAAwAuAAAAAAALAAIAAQAAAB4AcAABAAAADgAAAEFycmF5
cyBpbiBRdHAAAAACAXEAAQAAABsAAAABvnefeZIRM7ac420R0pV+AAjH6pI5AAAMvBAAQAA5AABb
L6uhd74BAwDxPwkEAAAeADFAAQAAAAgAAABXQUxLRVJDAAMAGkAAAAAAHgAwQAEAAAAIAAAAV0FM
S0VSQwADABlAAAAAAAMA/T/kBAAAAwAmAAAAAAADADYAAAAAAAMAgBD/////AgFHAAEAAAA9AAAA
Yz1HQjthPUlCTVg0MDA7cD1UQVRFICsgTFlMRTtsPURFWEVYQzAxLTk5MDMyNjE1NTk0NVotMTM0
ODA1AAAAAAIB+T8BAAAAWAAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAAAAAvTz1TVUdBUi9P
VT1VTklURUQgTU9MQVNTRVMgTE9ORE9OL0NOPVJFQ0lQSUVOVFMvQ049V0FMS0VSQwAeAPg/AQAA
AA4AAABXYWxrZXIsIENocmlzAAAAHgA4QAEAAAAIAAAAV0FMS0VSQwACAfs/AQAAAFgAAAAAAAAA
3KdAyMBCEBq0uQgAKy/hggEAAAAAAAAAL089U1VHQVIvT1U9VU5JVEVEIE1PTEFTU0VTIExPTkRP
Ti9DTj1SRUNJUElFTlRTL0NOPVdBTEtFUkMAHgD6PwEAAAAOAAAAV2Fsa2VyLCBDaHJpcwAAAB4A
OUABAAAACAAAAFdBTEtFUkMAQAAHMMD2Lauhd74BQAAIMHDKgSOid74BHgA9AAEAAAAFAAAAUkU6
IAAAAAAeAB0OAQAAAA4AAABBcnJheXMgaW4gUXRwAAAAHgA1EAEAAAAyAAAAPDExODhCRUZBNjEz
N0QyMTE4NkU0MDAwOEM3RkFDMUM0MUQyMUQzQERFWEVYQzAxPgAAAAsAKQAAAAAACwAjAAAAAAAD
AAYQjVsl9QMABxAZBwAAAwAQEAAAAAADABEQAQAAAB4ACBABAAAAZQAAAEZPUlNNQUxMSVNIQVJS
QVlTSVdPVUxEQ0hFQVRCWVVTSU5HQU1BQ1JPSU5NWVRQVUVESVRPUlRIQVRSRVBMSUNBVEVTQVNF
TEVDVEVEQkxPQ0tXSVRIRU1CRURERUROVU1CRVIAAAAAAgF/AAEAAAAyAAAAPDExODhCRUZBNjEz
N0QyMTE4NkU0MDAwOEM3RkFDMUM0MUQyMUQzQERFWEVYQzAxPgAAAEUd

------_=_NextPart_000_01BE77A2.2381CA70--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.