Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
MS Query loses decimal places
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...- MarcLodge
- Thread
- Replies: 3
- Forum: Microsoft: Office
-
Help me abou DB2 Sql Code
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... -
T-SQL YTD query SSMS into IBM DB2
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... -
case when this field = abc then thisother field = 3
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... -
table reorg request
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... -
IDA019L1
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...- MarcLodge
- Post #6
- Forum: COBOL General discussion
-
Security Error
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...- MarcLodge
- Post #4
- Forum: Microsoft: Windows
-
Security Error
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.- MarcLodge
- Post #2
- Forum: Microsoft: Windows
-
Identify Binary data stored in DB2 CHAR field
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... -
IE9 very slow to load, then most settings greyed out
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- MarcLodge
- Post #3
- Forum: Browser issues for IT professionals
-
IE9 very slow to load, then most settings greyed out
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...- MarcLodge
- Thread
- Replies: 2
- Forum: Browser issues for IT professionals
-
Rekursive SQL Query
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... -
Rekursive SQL Query
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... -
ON CALL exception
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...- MarcLodge
- Post #2
- Forum: COBOL General discussion
-
Automatically generated TIMESTAMP field by INSERT and UPDATE operations
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... -
DB2/SQL Task list
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. -
Automatically generated TIMESTAMP field by INSERT and UPDATE operations
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... -
DB2/SQL Task list
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 -
SQL Multiple Joins + Subquery limitation
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... -
What would cause a DB2 mainframe account to suspend...
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?
