Search results for query: *

I have a script that runs a program with an interactive user parameters screen. In order to run this as a CRON job 'we' have created a script that passes the key depressions to the job. The trouble is the CRON job is "blind" so any on-screen messages that may have occured during an interactive...

Hi, The system we are using has a unique date identifier rather than using a recognised date format. I need to convert this date into a "DATE" format field so that the reporting tool (Business Objects) can work with it. I tried to create a lookup table with a field 'date' in it using the...

Thanks, I tried that but got an error, I think it doesn't help dealing with multi-million row tables so I wanted an exception only solution. I also realised that I could use the "where not exists" statement as well. Thank you.

Hi, I'm trying to identify where some records may be missing from a file using a shared key field. For illustration tables 'movements' and 'ledger' should both have records for every movement with a key value of 'journal' To show all details I would use sql: select * from movements, ledger...

Hi, Excellent answer & you've read the situation well. It is a transactional database, point taken on DW structures though. Items are unique so no risk of cartesians. Joined query is fine but I'm resisting as there are a number of these situations that I need to resolve & I don't need the...

Thank you for your response. Couple of questions if you don't mind. I'm quite used to databases, but at the basic end of the market. I'm running BO over a long established Informix database so I have no opportunity to influence it's design. In BO terminology what is a fact table versus a...

Hi, I have the need to sum a value in a query with a join. For example: I have Stock table including Cost of Item Sales table including Item and Sales Vales I want to show: Item, Sum(Sales Value), Sum(Cost) When I define Cost and Sales Value as measures without sum() in the Universe all is...

Shriyan, Thank you, that's perfect. You're right about eg.s as well. Regards, Jonathan.

Hi, I'm looking for a simple statement to conditionally replace a value. I have a value field that could be negative or positive depending on a Debit/Credit field. Thus I need to query something like: select {IF type = "debit" THEN value ELSE value * -1} from table Obviously the...