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 gmmastros on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MarcLodge

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    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?

Part and Inventory Search

Back
Top