I'm working on a program that will need to remove a JOB card from a JCL member. I'm having a lot of trouble building something that satisfies all possible options and configurations.
Below is a good ...

I have a INSERT + SELECT statement. One column is a VARCHAR but must be filled with a date with 'yyyyMMdd' format in 3 different dialect.
With SQL server and Oracle there's no problem, but in Db2 I ...

I am trying to compare two smallint fields to look for differences. One table is a pending change table that is read by a batch job at night that then updates the other table along with doing other ...

Please help with the below scenario, I have set of records that I need to loop over for a given ID and Case_Type and mark the record as Valid or ERROR.
Since it is an Audit table, the events has to ...

I'm looking to run a parser generated by ANTLR 3.5.2 on an IBM mainframe under zOS. I don't need to run ANTLR itself on the mainframe. But I do need to be able to run the C code that ANTLR generates ...

I want do a COBOL compile with Embedded SQL using the DB2 co-processor.
I am compiling on AIX, but have to use a remote z/OS DB2 Database.
I can get the program to compile if on the cob2 command by ...

Using JZOS launcher to execute java programs in batch.
The DB2 driver for JDBC supports XA transactions but it seems that it's only possible to use them when the process is running under the control ...

I want to place DB2 Triggers for Insert, Update and Delete on DB2 Tables heavily used in parallel online Transactions. The tables are shared by several members on a Sysplex, DB2 Version 10.
In each of ...

we are right now developing a system which runs on websphere z/OS 8.5 with a db2 z/OS 10. At the moment we face the following performance problem:
We need to copy records from one table to another. ...

We are developing software that generates and executes SQL queries for Oracle and SQL Server using ODBC drivers. We are researching the possibility to expand to DB2, but I read that there are several ...

I have a script that currently uses php ibm_db2 functions to connect to DB2 Express C on an Ubuntu 14.04 server. When I try to translate that same script to remotely connect to a database on DB2 z/OS, ...

I need to find the whole size (in TRACKS) of the given n datasets. For example, if there are 15000 datasets under user1.* , I should get the value by adding all the 15000 dataset's size.
Is there any ...

I would like to know the DB2 platforms where it is possible to create User-defined table functions in SQL-PL. It seems that it is possible in DB2 for i, but I haven't seen anything for LUW, not z/OS.
...

Can anybode give me a hint on how to extract the application id of my DB2 subsystem in z/os?
I tried the "V8 approach" from here: Application ID from db2 8.1.5 on Z/OS
but my shop has not installed ...

I'm trying to extract data (using SPUFI) from a DB2 table to a file, with one of the output fields converting a decimal field to the same format as a COBOL comp field.
So e.g. today's date (20141007) ...

I connect to a z/os-System via "tso ftp" with specifying my user-id, password and the hostname.
The command "help" shows me a list of commands that I am allowed to use, for example "site".
So far so ...

I want to transform a simple query in a dynamic query, passing some variables directly.
The query could be something like this:
SELECT * FROM mySchema.THETABLE a
WHERE a.THECOLUMN = 'someVariable';
...

I have been asked this question and I cannot come to an agreement as to whether or not this is true or false.
Would it be a true statement to say that JES does not start initiators and that the Work ...

My question is for QR Code support on the ZOS platform. We have legacy systems that produce many printed documents and mailings. I have been tasked with the challenge of developing a called routine ...

I want to create some Rexx code that allows me to allocate new data sets, in any format, such as PDS, Sequential etc.. by reading the data set information of an existing data set then applying those ...

my current problem is that I want to use Hibernate on DB2 to do this nice ORM-stuff and it somehow works, but not really like I want it to ..
The core of the problem is that I can only connect to a ...

I've an exercise that I need to complete and execute the necessary applications to
distribute the information about the transactions of credit cards business, with the ultimate goal of showing at a ...

I have to run a query against several million records comparing the SSN in one table against the derived SSN(I'm deriving it from a longer ID that stores the SSN as the first nine characters in this ...