-tok is a startup parameter. Can be put into a .pf file or a .vtg file.
Default = 1024.
4.0 max = 1600.
5.0 max is system dependant depending on available memory.
Jim
-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 17, 2003 3:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB error -tok parameter
Patrick,
Thank you, that let me get in that last join. It should let me put back
in
the company joins as well to speed things back up. I used -tok 2048.
Is
anyone aware of any negative impact of this choice? For now, I am just
very
grateful that it works.
Aaron Hoyt
Design Standards
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Monday, February 17, 2003 4:09 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB error -tok parameter
Try the -tok option on the Report Builder.vtg ConnectOptions line.
Patrick Winter
-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 17, 2003 3:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB error -tok parameter
That is a good call, and exactly where I am at, no table has more than 3
characters as it's alias. I will try to cut them to 2 and see if I can
squeeze in the last couple of joins. Thanks
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Monday, February 17, 2003 3:50 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB error -tok parameter
If you have a ton of joins and this is where you are getting this
message
here is a work around. Rename some of the key tables with aliases such
as
"part" to "P", "JobHead" to "JH", etc... All it does is save on
characters
so you can add more statements. Keep in mind that joins use multiple
fields
so each occurace of the table name is reduced in character length.
Patrick Winter
-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 17, 2003 2:42 PM
To: 'Vantage E-Group (E-mail) ' (E-mail)
Subject: [Vantage] RB error -tok parameter
I am getting the following error when running a RB report that I am
building. "Database error is: **More than 1024 items in a single
statement.
Use the -tok parameter. (136) **" Anyone know where to enter this
parameter,
if I can change it, or if I am just stuck having to keep down the number
of
joins? Any help is appreciated. Thank you,
Aaron Hoyt
Design Standards
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Default = 1024.
4.0 max = 1600.
5.0 max is system dependant depending on available memory.
Jim
-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 17, 2003 3:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB error -tok parameter
Patrick,
Thank you, that let me get in that last join. It should let me put back
in
the company joins as well to speed things back up. I used -tok 2048.
Is
anyone aware of any negative impact of this choice? For now, I am just
very
grateful that it works.
Aaron Hoyt
Design Standards
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Monday, February 17, 2003 4:09 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB error -tok parameter
Try the -tok option on the Report Builder.vtg ConnectOptions line.
Patrick Winter
-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 17, 2003 3:00 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RB error -tok parameter
That is a good call, and exactly where I am at, no table has more than 3
characters as it's alias. I will try to cut them to 2 and see if I can
squeeze in the last couple of joins. Thanks
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Monday, February 17, 2003 3:50 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB error -tok parameter
If you have a ton of joins and this is where you are getting this
message
here is a work around. Rename some of the key tables with aliases such
as
"part" to "P", "JobHead" to "JH", etc... All it does is save on
characters
so you can add more statements. Keep in mind that joins use multiple
fields
so each occurace of the table name is reduced in character length.
Patrick Winter
-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Monday, February 17, 2003 2:42 PM
To: 'Vantage E-Group (E-mail) ' (E-mail)
Subject: [Vantage] RB error -tok parameter
I am getting the following error when running a RB report that I am
building. "Database error is: **More than 1024 items in a single
statement.
Use the -tok parameter. (136) **" Anyone know where to enter this
parameter,
if I can change it, or if I am just stuck having to keep down the number
of
joins? Any help is appreciated. Thank you,
Aaron Hoyt
Design Standards
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/