Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [db2]

12 questions
4
votes
2 answers

What's new in PL/I, DB2, and S/390 assembler?

I have an upcoming technical interview with a former employer that will focus on PL/I, DB2, and ISPF. The job will be with systems that I architected and wrote myself 20 years ago. The few years of professional programming that I did since then was…
MF Dinosaur
  • 41
  • 4
3
votes
1 answer

COBOL program or JCL?

I have to perform 3 tasks: an insert, a delete, and a write I'm not sure what the best way to do this is. My mainframe program design skills aren't too tight, so I was looking for advice. Could I avoid doing a COBOL program for this? The way I see…
Frantumn
  • 185
  • 6
3
votes
1 answer

Where can I obtain the specification for Distributed Relational Database Architecture?

I'm developing a DBMS that should be able to connect to IBM DB2 via the DRDA protocol. I found a DRDA reference manual that mentions "DRDA Implementation Programmer's Guide, SC21-9529" as a publication about DRDA, and seems that this manual is…
dtumaykin
  • 133
  • 4
3
votes
1 answer

Are there restrictions on table and column names in DB2?

I'm working with a DB2 database and I can't help but notice - these table and column names are really confusing! I realize that good names are important in every facet of software development, and it's quite possible that the non-intuitive names are…
Jim G.
  • 8,006
  • 3
  • 35
  • 66
2
votes
2 answers

Creating experimental database

This question is about databases but I prefer to post it here and not in dba.stackexchange. The reason is that I have concerns with the application as well as database design. Programmers can better assist in this regard. My four year old .NET…
RPK
  • 4,378
  • 11
  • 41
  • 65
1
vote
2 answers

How to gradually improve on an old IBM Host C++ framework

Imagine a C++ framework as a business layer, but with controlling logic as well. E.g. user rights, state of the webflow etc. With some plain C code to access DB2. The whole framework is host based. We are looking for a way to replace the existing…
Toskan
  • 256
  • 1
  • 7
1
vote
1 answer

Avoidance of Lost Update in DB2 for z/OS

I have a question concerning the "Uncommitted Read" Isolation Level under DB2 DBMS for z/OS. In this article https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/perf/src/tpc/db2z_isolationissues.html in the IBM Knowledge center it is stated…
Monty Burns
  • 13
  • 3
1
vote
4 answers

is stored procedure having multiple UNION efficient than running all SQL's in parallel?

I have below in my stored proc if then SELECT TABLE1.COLUMN1,TABLE1.COLUMN2,TABLE1.COLUMN3,TABLE1.COLUMN4 FROM TABLE1,TABLE2 where criteria1 (covers functionality 1) UNION SELECT…
Vipin
  • 141
  • 1
  • 8
1
vote
1 answer

How do tablespaces differ in DB2 from databases in MySQL or MS SQL Server?

In DB2, it seems there is a strong separation between what a database is and what a tablespace is. Where as in MySQL and MS SQL Server tablespace and database seemed to be used synonymously. What are the differences, if any?
developer1234
  • 237
  • 2
  • 13
1
vote
2 answers

Company wants to move its programs to a new framework / concept - what are options?

So there is an insurance company which wants to move long term its proprietorially written software for different insurance products to a new platform / framework / concept / something. One of the applications is ~700 pages big. We would require…
Toskan
  • 256
  • 1
  • 7
0
votes
2 answers

What are the pros and cons of storing files in DB2 vs folders?

I work in a Web Application where users are allowed to upload files. They can retrieve and view those files at a later point in time. A solution that user works with can have multiple attachments but the click to view only one at a time. No version…
Abi
  • 155
  • 1
  • 4
-1
votes
1 answer

Cursor select on 2nd Primary key on db2 sql field for embedded positional value - Unable to determine most efficient for longterm design

I have a SQL DB2 table where the first two fields are the primary keys (not including the third field which is date/time stamp). The table was designed by another team with the intent to make it generic. I was brought into the project after the key…
Cindy LB
  • 9
  • 4