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!

Recent content by Truusvlugindewind

  1. Truusvlugindewind

    ODBC to AIX DB2 (I know...)

    suppose you have a db2 server with tcipip# 192.168.1.100 and a db2instance listening to port 50000. There is a database called mydbase running under control of that instance. You need te access that database by means of ODBC. It is just 3 simple lines, just do not forget to execute them in the...
  2. Truusvlugindewind

    Conditional parsing on sort clause

    I use this syntaxselect empno , sex , salary , case when sex = 'F' then salary * -1 else salary end as sort_col from employee order by sort_col Nonsence example, but when you replace "sex = male/female" by some kind of "debit/credit" code it...
  3. Truusvlugindewind

    Aliases for fields

    Try this syntax select * from table ( select empno as xx , salary as monthly_insult , bonus as robbed_by_banker from employee ) a where a.monthly_insult + a.robbed_by_banker > 10000
  4. Truusvlugindewind

    SQL to List All Database Names

    JDBC/ODBC connectors are not designed for that. You use it to connect to a specific database and that database is the scope. You could try to use the "SYSPROC.ADMIN_CMD" for the LIST DB DIRECTORY.
  5. Truusvlugindewind

    How to migrate database between two computers using ibm db2 udb

    Could you supply more info about the 2 configurations? When you make a backup from the source computer, make sure that it is an uncompressed offline backup! Do not rely on the control centre too much but try to make your own backup/(redericted) restore scripts. Believe me, it works, but the...
  6. Truusvlugindewind

    DB2 SQL Syntax for CASE Statement

    Why don't you google for "COALESCE"? select COALESCE(B.USR_R_NM,'USER DELETED' from ...
  7. Truusvlugindewind

    MicroFocus COBOL on AIX 6 with Oracle 11

    Sounds over-complex to me. Are there many non-cobol routines? If not: Just compile to "*.int" modules on your windows development machines, on the aix compile the "*.int" into "*.gnt" and just execute the "*.gnt"s. All your sources and copybook can remain on the windows environment. I do not...
  8. 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...
  9. Truusvlugindewind

    Recover data from .dat and .idx

    Hmmm... The topic-starter mentiones .IDX files, so the organization is indexed. This leaves record-length and record layout. Just trail&error until you can retrieve a whole record and then analyse the hexadecial structure: PIC X fields should be readable in normal format PIX 9 packed-deciaml...
  10. Truusvlugindewind

    Recover data from .dat and .idx

    Whenever you must access MF files from another language than MFCobol, you can call the MF I/O routines separately. This module is called extfh (http://docs.hp.com/en/64/fh/fhexfh.htm)
  11. Truusvlugindewind

    Query another table for data

    Reference Graeme's cookbook when a question like this comes up get you a purple star. I agree, its a great book (has been for years now).
  12. Truusvlugindewind

    db2 files to exclude from windows filesystem backup

    Remember: "backup is for dummy's, restore is for pro's" So, what is your recovery stratigy? Do you have a dedicated database server? How fast can you re-build that server and restore the database? How well did you secure your backup-images and transaction log files? Did you test? How long did...
  13. Truusvlugindewind

    wrong cobol source on the internet

    even worse: you find that in an IBM magazine.... Maybe they should try a "hello world" first, see if that is not too difficult for them.
  14. Truusvlugindewind

    Stored proc passing Null values

    The same syntax as used in "create table": INOUT1 char (3) INOUT2 char (3) NOT NULL So every paramteter which is nullable should be called with the indicator variable. No difference with tables.
  15. Truusvlugindewind

    Next sentence coding

    Sane coding standards: next sentence and end-if are mutual exclusive in 1 line, even better in 1 section even better in 1 program. In the past I had to maintain old '74 programs. In the section were you made you changes it was good habit to convert all IF statements and add END-IF's and take...

Part and Inventory Search

Back
Top