Search results for query: *

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?

...corresponding to SQL error "-725" in the message file on this workstation. The error was returned from module "DSNLXRSS" with original tokens "CURRENT SQLID(*PRIOR FAILURE*) DUN1 ". SQLSTATE=42721 {SQLTables} Anybody have any ideas what this...

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

It's ok lads, i've been onto the database programmers about this problem, and apparently i've spotted an error. It appears that some VB script that was supposed to create a date, doesn't work properly. Thanks for the offers of help though - It can be very frustrating when stuff like this...

Steve, thanks for the offer, could you forward your notes on context to me at andysmithhsbc(at)hotmail.com.,.. Cheers...

I'm currently in the process of building a new universe based on a db2 database and have found several loops. I've gotten around this by creating aliases of the looped tables, which seems to work ok. However, a colleague has told me that i should try incorporating contaext in a loop situation...

I'm reporting on a db2 database and am having a problem with max dates. At universe level i've created an object (based on a date field in the database) as a measure and asked it to show me the max of the field - however, i'm getting returns which are not the max date of the field (in fact they...

Aaaahhhh