Recent content by funkmonsteruk

I'm using db2, one of my column names is 18 characters and the problem comes when i use an alias for this table...

I'm working on a BO universe at the moment and getting a SQLSTATE=42622 error, it is telling me that the names of a couple of my tables are too long (maximum 18 characters). It tells me this when i am checking the integrity status. I've tried re-naming the tables in question, but I'm still...

I'm running a query on a db2 database and i'm having problems using the max date as a condition. Basically the field is called diry_ts and it relates to several events within a particular case. I want the report to show me cases where the last diry_ts date is over a month ago, but the report...

That seems to work fine Steve.... Cheers for the pointer!!! Have you come accross anything like this before? [cannon]

The most bizarre thing has happened to me, I've got a condition that uses a between query prompt at report level. The date is formated at universe level as dd/mm/yyyy, the start date prompt i have added works fine i enter a date using dd/mm/yyyy format and averything is ok, however the end date...

Cheers Steve

I've just come accross a universe design issue which i haven't attempted before, so was wondering if anybody had a solution. Basically i have a table called Person, the primary key of this table is PersonID, and it contains all details relating to an individual. Within the table is a column...

This problem has now been solved, aparently it was down to my access rights on this particular database. After i initially logged on somebody thought i was trying to sabotage the database, so my access rights were restricted. Very strange, cause i could still access the database through...

Very strange, but this seems to have sorted itself out. Used the old re-boot method (seems to work for most things computer related) and i'm no longer getting an error...

I'm currently working on a new universe and am having problems with an object. The object is a character and it parses OK, but when i use it in a report i get the following error message: [IBM][CLI Driver][DB2] SQL0502N The cursor specified in an OPEN statement is already open...

I've been given this code to get a Business Objects report to go through all available variables in a particular field, filter the report by that variable and save the output to a file whose name is based on the variable. It works fine but i also need to incorporate a stage to e-mail the report...

Cheers Blom max number of agents is 200

Yes, it's an interesting problem, when i check the connection BO tells me that the server is responding (so user id and password are intact), where would i find a value for maxagents?

I'm doing a bit of work on a universe at the moment based on a db2 database, however whenever i try pick more tables to insert i get the above error message with details as follows - [IBM][CLI Driver][DB2] SQL0969N There is no message text corresponding to SQL error "-725" in the...

Thanks for forwarding the notes Steve, you're a star...