RE: [sqr-users] dynamic array size

[Jeff.Steinfeldt@wellsfargo.com]

According to the documentation, the SIZE= clause only accepts a literal.
Take a reasonable guess and then allow for expansion by declaring a value
for EXTENTS=.

-----Original Message-----
From: sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org
[mailto:sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org] On
Behalf Of Sony Dada
Sent: Wednesday, February 23, 2005 10:29 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] dynamic array size


Hi,

I need some advice from sqr experts. Thought it would be simple but having 
hardtime to resolve it.

Issue:

create-array name=BUs size=100
     field=legal_entity:char

I have to set above 100 as dynamic and I know the count before I create this

array. So, I changed the above code as below:-

select count(*) &cnt
let #count = &cnt
from abc_table
  show 'count : ' #count

create-array name=BUs size=#count
     field=legal_entity:char

After I changed the program, it is not recognizing the #count. I replaced 
with {#count} but not working. I looked at the old postings and looks like 
it can be resolved. Could you send some suggestions on this.

Thanks in advance.
Sony



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users