Recent content by MarcLodge

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...