Stack Overflow
Stack Overflow

Questions tagged [zos]

z/OS is a 64-bit operating system that runs on IBM's traditional mainframe hardware, also known as System z.

z/OS, along with zLinux, zTPF, z/VSE and z/VM, is an operating system which runs on IBM's System z hardware.

This tag should be used when asking questions related to the specific operating system z/OS, associated tags may be mainframe, cics or db2 (provided you're talking about the mainframe versions of those products).

A descendant of OS/360, a primary design premise is backward compatibility. Application programs dating from the 1970s continue to run unaltered on modern z/OS systems.

IBM provides the z/OS basic skills education Knowledge Center, click on the table of contents link for a list of topics.

606 questions
0
votes
2 answers

Debugging Zos cobol with RDz

My intetion is to debug the called cobol program aswel. But not sure how to keep a break point to go inside the called cobol program. At the moment i am able to debugg the main cobol program and control just goes over the called copbol…
user2054151
  • 7
  • 1
  • 12
0
votes
1 answer

SQL1476N The current transaction was rolled back because of error "-30080". SQLSTATE=40506

Hi I am getting SQL error -30080 while running a select query on datastage, on google I cannot fing SQL error -30080, can you provide me the reason
salesforce beginner
  • 11
  • 1
  • 5
0
votes
0 answers

User-defined table functions in DB2

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. It does not appear in the "SQL Reference for…
AngocA
  • 7,655
  • 6
  • 39
  • 55
0
votes
2 answers

DB2 for z/os V11 - how to get application id?

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 the jars for the import com.ibm.db2.app.;* so I…
Klaus Schulz
  • 527
  • 1
  • 5
  • 20
0
votes
0 answers

DB2 SQL z/OS - variable equivalent of a hex constant

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) would be ..ëõ The SQL HEX function converts…
Mick O'Hea
  • 1,619
  • 2
  • 14
  • 20
0
votes
4 answers

Connecting to MySQL RDBMS through java

I have a requirement to connect existing cobol application on z/OS to remote MySQL database using java. I read about the stored procedure approach but did not get a clear picture about the architecture. Can you please share your ideas regarding the…
Sherly
  • 1
  • 2
0
votes
2 answers

DB2 v10 zos : identify free index values

My organisation has hundreds of DB2 tables that each have a randomly generated unique integer index. The random values are generated by either COBOL CICS mainframe programs or Java distributed applications. The normal approach taken is to randomly…
Hector
  • 4,016
  • 21
  • 112
  • 211
0
votes
2 answers

db2 z/os transform simple query in dynamic query

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'; So, I tried something like this: DECLARE v_schema…
Francesco
  • 55
  • 7
0
votes
1 answer

SAS PROC SQL CREATE Statement not valid or out of order error

Can anyone help me resolve this error? It's in SAS 9.2. 275 PROC SQL; 276 CREATE TABLE WORK.MATCHREC AS ______ …
Richard_G
  • 4,700
  • 3
  • 42
  • 78
0
votes
1 answer

Do any ORM frameworks allow choreography of multiple database inserts

I have a requirement to perform the following steps (stages/phases) when updating my database. Validate business request to ensure it is valid. Identify what database records need creating. Create these records as Java Objects, populated with the…
Hector
  • 4,016
  • 21
  • 112
  • 211
0
votes
1 answer

Hibernate and DB2 on z/OS - auto-create table

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 DB2-subsystem via JDBC and have to specify the…
J.Beyer
  • 131
  • 6
0
votes
1 answer

How to use SYSIN?

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 web page the confirmations of transactions. My…
Bruno Neuman
  • 125
  • 1
  • 8
0
votes
0 answers

How to return a cursor from an anonymous block from a DB2 z/OS database in .NET

According to the examples in the IBM documentation (see this page) it should be possible in .NET to return a DB2 z/OS cursor from an anonymous block and loop over the results with a datareader, however the following code crashes with the following…
Marc Selis
  • 833
  • 12
  • 17
0
votes
0 answers

activerecord-jdbc-adapter DB2 zOS increment ID issue

Short ID column doesn't increment with INSERT INTO. Long I'm with: JRuby 1.7.11 activerecord (3.2.17) activerecord-jdbc-adapter (1.3.6) DB2 v10 on z/OS (Mainframe) (driver db2jcc4.jar version 4.15.99) /config/database.yml: production: …
Mart
  • 1
  • 1
0
votes
1 answer

Setting break points in z390 Portable Mainframe Assembler and Emulator?

I've been using the old Dos version of Assist and would like to use the z390 Portable Mainframe Assembler and Emulator instead. I'm able to compile and run programs but am not clear on how to set break points. For example in assist given the…
Jared
  • 39,513
  • 29
  • 110
  • 145
1 2 3
…
40 41