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

    COBOL with embedded DB2/SQL on open source cobol

    pre-compile, compile. linkedit & bind. Life as usual for a mainframe programmer. But when you want that to work in the outside world.. The ingredients are there: O.S.: linux DBMS: DB2 express C compiler: open-cobol All for free and yes: DB2 still carries the cobol-pre-compiler. The link/edit...
  2. Truusvlugindewind

    Client authentication saver/better than server?

    Interesting thought: Recently I changed the AUTHENTICATION from "server encrypt" to "client" for one of the databases. Something to do with win/ODBC applications forcing users to type their password over and over again. A few minutus later I was (positive)surpised: At my client's it is 100%...
  3. Truusvlugindewind

    STMM/bufferpool NUMBLOCKPAGES synchronize?

    My client is upgrading from 8.2 to 9.5 on MSwindows. I am creating scripts to re-create the databases and to populate with data. I am confused about the combination of STMM and the NUMBLOCKPAGES value in the bufferpool definitions. I've read that NUMBLOCKPAGES should be 2% of the total number of...
  4. Truusvlugindewind

    Will this be more efficient?

    Suppose the functional requitement: Read a, b, c from tab01. When b = 2 read k from tab02 as well (using c as foreign key). The tab02 row does not have to exist. You can code select t1.a , t1.b , t1.c ,coalesce(t2.k,space) from tab01 t1 left outer...
  5. Truusvlugindewind

    edit cobol/DB2 in ISPF

    1 tip and 1 question: 1st the tip: - while editing inline SQL the syntax coloring does not work. But, while editing, you place an "." after the "exec sql" it will not know it is sql and treats it like cobol. Not very usefill but at least it will color the "(" and the matching ")" for you...
  6. Truusvlugindewind

    "Cross-reference of data names" too primitive?

    Ask me and I say "yes". When you populate DCLGEN column by means of embedded SQL, it is not recognised (no Mlinunumber reference). But even when you code 01 group-counters. 03 count-a pic s9(9) comp. 03 count-b pis s9(4) comp. INITIALIZE group-counters REPLACING NUMERIC DATA BY ZERO...
  7. Truusvlugindewind

    Use assembler listing

    On the mainframe, an assembler listing can be included in the compiler-output. It can be used to "educated guess" the impact of a choosen solution. You know: code a section like this, code anohter section like that, both with the same funcionaliy and count the number of assembler lines (=...
  8. Truusvlugindewind

    SQL style

    Given a hypotetical query select a.A1 , a.A2 , b.B1 , c.C9 , d.D8 from tabA a join tabB b on b.B3 = a.A3 join tabC c on c.C2 = b.B2 and c.C4 in ( 1 , 6 , 8 , 9 ) and c.C8 = :hostC8 join tabD d on d.D1 = c.C1 and d.D5 <...
  9. Truusvlugindewind

    from V7 to V8: ah! new SQL features?

    At the office we've got V8 on the mainframe (test only for now) and at home I've got V9 in my linux-laptop. And now the business case is: 1 table with actual data, and 1 table with history-data. Can you delete rows from the actual table and store those in the history? Hmm ... all those new...
  10. Truusvlugindewind

    Less overhead calling stored procedures (on z)?

    I'd like to launch an idea of mine: nowadays I'm coding COBOL stored procedures which are being called from WebSphere/java, other cobol programs and other cobol stored procedures. It seems to me that cobol calling cobol by means of DB2/WLM generates a lot of overhead. But sometimes, when...
  11. Truusvlugindewind

    back on mainframe: what did you miss/what do you miss

    Having done some clients with micro focus cobol and AcuCobol I'm back on the mainframe. There are some things I am glad to have again and some things I miss on the mainframe. I did miss - DB2/embedded SQL - TSO/ISPF editor - QSAM/VSAM file's - "clear" usage when you use COMP-3/COMP-4 I do...
  12. Truusvlugindewind

    db2 on win2003 with /3GB

    I am managing a windows 2003 server with db2/websphere for a client of mine. To optimize the configuration I advised them to change the windows boot.ini file and activate the "/3GB" switch (http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0406qi/index.html#figure14 ). I...
  13. Truusvlugindewind

    A bit like highlander

    There can be only one http://www.acucorp.com/microfocus.php
  14. Truusvlugindewind

    close re-entrancies of the 3rd kind

    Mainframe cobol & re-entrantcy... always a pain in the <beep> Batch/CICS/IMS, bmp or mpp, never a dull moment. Nowadays I'm coding cobol-db2 stored-procedures, a new nail in our re-entrancy coffin. No cics, no batch, no ims but WLM's. Not only working storage fields containing old values, but...
  15. Truusvlugindewind

    Source run report

    I've worked with various cobol versions the past 20 years. I remember the possibility to get a report, generated at run-time, which gave all sections/paragraphs/statements followed by a counter indicating how many times this was executed. Nowadays I work with "Enterprise COBOL for z/OS...
  16. Truusvlugindewind

    ISPF/SQL hilite?

    Back to my roots. After some PC/UDB assignments I'm back at a mainframe/DB2 client. When I work with embedded SQL in cobol or with SQL in a PDS (SPUFI) I notice that SQL is not properly hilited in the "good old" ISPF editor. Is there a way to accomplish this? Are there tips&tricks around?
  17. Truusvlugindewind

    defrag windows disk on db2 server

    DB2 on windows in a 24x7 env. When do you defrag you disks? And why, when using DMS tablespaces, is it still required? At least that's the case at my client's site. My theory is that you should defrag right after the creation of the containers. And then they will never get fragmented unless you...
  18. Truusvlugindewind

    DB2 on windows, too bad: no tail. But wait.....

    On linux/unix you use tail -f db2diag.log and on a windows server you miss that feature, right? Wrong: type db2diag -f
  19. Truusvlugindewind

    No COBOL pre-compiler?

    Years ago I did a project with OS/2, DB2/2 and Micro Fcous COBOL. This was, to my personal opinion, a very good mix. Now, at home, I've got an old computer running OS/2, the Micro Focus workbench installed and recently I've "obtained"(dont't ask, they probably throw it away otherwise) a CD...
  20. Truusvlugindewind

    REXX losing ground?

    It's all about REXX on the mainframe on this forum isn't it? It used to be a SAA language for all platforms. I've coded REXX on OS/2 and I remember when you installed DB/2 on WinNT4, you would get REXX installed automaticly. Recently I've installed DB2V8 on XP, but no REXX came along... So...

Part and Inventory Search

Back
Top