You need to go to AdminSB+ SetupSB+ Configuration PatternsF5-System Defaults
and set the SB+ Subroutines in Dictionaries field to Y
After that you would need to regenerate the dictionary entries so that the
default ERROR i-type gets replaced with an i-type that uses the
SB.SMART.QUERY function. Try re-saving one or two fields you are interested in
after you set the flag above.
What SB.SMART.QUERY does is use the executable expression of your SB+
expression to return a value that can be used in query statements. What the
flag does is tell SB+ to generate the executable expression and create the
i-type that uses it with SB.SMART.QUERY, after you save a field definition.
I did a similar thing myself before they made SB.SMART.QUERY available.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dennis bartlett
Sent: Sunday, August 19, 2012 8:00 PM
To: U2 Users List
Subject: [U2] SB.SMART.QUERY
Hi
Does anyone know how I can get SB.SMART.QUERY documentation? Alternatively (or
maybe in addition) do you know how to call SB.SMART.QUERY to decifer DICT items
much like ITYPE(xx) does in BASIC?
The IBM release notes talk about SB.SMART.QUERY being IBM's response to people
wanting to use SB reporting outside of the SB+ environment - now this is
EXACTLY what I need, but I can't figure out how to do it. I've written my own
half-blown version, but it would be oh-so-easy to simply use theirs..
Thanks
Dennis Bartlett
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Dave Davis
Team Lead, RD
P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[http://www.harriscomputer.com/images/signatures/HarrisSchools.gif]
[http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]http://www.harriscomputer.com/
6110 Enterprise Parkway
Grove City, OH
43123
www.harris-schoolsolutions.comhttp://www.harris-schoolsolutions.com
This message is intended exclusively for the individual or entity to which it
is addressed. This communication may contain information that is proprietary,
privileged or confidential or otherwise legally exempt from disclosure. If you
are not the named addressee, you are not authorized to read, print, retain,
copy or disseminate this message or any part of it. If you have received this
message in error, please notify the sender immediately by e-mail and delete all
copies of the message.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users