Search results for query: *

I have a spreadsheet with various worksheets in it. From these worksheets, I want to create another, based on the data in the previous worksheets. I've tried to do this using MS Query and SQL to grab the data and this works fine, except one of the columns I wish to display is a percentage...

Try: SELECT S.COMPANY, S.CATEGORY, R.CATEGORY FROM TABLE S ,TABLE R WHERE S.CATEGORY = 'SALE' AND S.COMPANY = R.COMPANY AND R.CATEGORY = 'RETURN' This would take two lines and combine into 1. The problem with this is that it will only give a line if the Company has both sales and...

Hi fka006, I've not been to this site in absolutely ages so was pleased to find a nice problem on my return! The main problem you have with writing this in SQL is that the end day of the previous month can change from 31, to 30 or 28 and 29. What you therefore need to do is build a date of the...

Hi evr72, What are you expecting to be returned with the piece of code: WEBQRY.SHPORD.DDAAGP=3 and WEBQRY.SHPORD.EXT_PRICE=3*WEBQRY.SHPORD.DDARQT Are you expecting 2 values back? The other WHEN clauses return one value so you need to examine exactly what it is you are trying to achieve and...

Hi Denny, Did the reorgs all complete successfully? Are there any messages in the log that might indicate that they didn't 100% complete? Alternatively, do any of the tables fall into the category as defined in this IBM fix? http://www-01.ibm.com/support/docview.wss?uid=swg1IY88193 Hope this...

Hi moulisea, IDA019L1 is one of the control module programs that is called when accessing VSAM files. If you type 'IDA019L1 VSAM' into Google, you get quite a number of hits, any of which might be pertinent to your problem. If you are not getting enough information out of the failing or slow...

I'm not sure where this comes from but I believe it's malware rather than a virus, not that I really understand the definition. I think that there are many different flavours of this, some more difficult to get rid of than others. If you type 'metropolitan police virus' into Google, you'll get...

It's a virus. I've seen this one before and it's quite difficult to get rid of. If the'res very little on the machine then a rebuild might be the best bet.

Hi lml, Like papadba, I believe the data will be packed-decimal rather than binary as you've spoken about Cobol and comp-3. If this is the case, then it might be possible to find the data via a SELECT. The last bit of the last byte of a comp-3 field contains the sign, which if positive is C...

Geates, Genius! I'd updated windows, uninstalled IE9 and re-installed, but hadn't thought to check the Java. Uninstalled that (there were more than one version) and re-installed just the most up to date one, and problem disappeared. Many thanks for your steer. Marc

Hi, I have a W7 64 bit laptop running IE9. For some reason, it takes an absolute age to open and do anything with, and 'interet options', 'manage add-ons' etc. are greyed out. I've run malwarebytes which found nothing. In safe mode, everything is fine. This is a personal home laptop,so anybody...

The line ClientAddress t1 INNER JOIN ClientAddress t2 ON t1.Clientnr = T2.Clientnr t1.Stopdate <> '9999-12-31' seems wrong to me. You're missing and AND between T2.Clientnr and t1.Stopdate. I think it should read: ClientAddress t1 INNER JOIN ClientAddress t2 ON t1.Clientnr = T2.Clientnr...

Hi Galaxy, I've no idea if this will work as I've obviously not got your tables so am unable to test, but something like this might lead you to the answer: SELECT t1.Clientnr, t1.Country as Old_Country, t2.Country as NEW_Country, t1.Stopdate as Changedate from ClientAddress t1...

Hi Rajesh, I must admit I've never used the ON EXCEPTION statement as I've always passed return codes between programs and allowed the Operating System to sort out any errors where the program doesn't exist. To my mind, if somebody has gone to the trouble of including exception handling of this...

I believe you have to have a trigger for each of the possible update actions. We have a library which stores all of our triggers and each is uniquely identified with a 6 character prefix which identifies the table, followed by either a U, and A or a D, then lastly a numeric digit. That way, we...

Hmmmm..... not sure if that's supported. Have a look at http://www.ca.com/us/~/media/files/productbriefs/insight_db_monitor_dist_product_brief.aspx or type CA INSIGHT into Google. Give them a ring and ask, I'm sure they'll be only to interested to help.

Most sites I've worked at have had tables with last updated timestamp, and we have always done this programatically. It's always been part of the standard to code it in the SQL. Your way is the only other way I can think of, but as you can't do it all in the DDL, I'd probably leave that bit out...

Depends what platform you are on I guess. We are on a Z/Os mainframe and have available CA-Insight which does exactly what you describe - shows all current threads with CPU usuage, actual time running, the SQL being executed etc etc. What OS are you running under? Marc

Hi Martin, I could be wrong as I'm finding the SQL very difficult to understand, but from your brackets and everything, it looks to me as if the very last join LEFT JOIN SRS.Lookuptable as Lookuptable_COUNTRY ON Address.ADDR_CNTRY = Lookuptable_COUNTRY.CODE and...

A mainframe account only usually gets suspended if the password is entered incorrectly a set number of times. Are all of your queries where the user and password as hard coded, actually correct?