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...
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%...
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...
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...
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...
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...
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 (=...
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 <...
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...
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...
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...
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...
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...
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...
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?
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.