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
1 answer

Create UDF in DB2 on z/os V11 - mutually exclusive clauses

I want to play a little bit with UDFs but I am stuck just at the start: I even can't get the examples from the manuals to work. The SYSIBM.Version variable for my DB2 system is DSN11015. Executing the sample code: CREATE FUNCTION FINDSTRING…
Klaus Schulz
  • 527
  • 1
  • 5
  • 20
0
votes
1 answer

How to make Inheritance in DB2 Z/OS?

I'm working on a JavaEE project, with DB2 Database and JPA. Can we make Inheritance between tables ? In the IBM DB2 Website, i found nothing on the DB2 documentation to do this via SQL code. This is what i want to do Exemple : CREATE TABLE…
ilias
  • 182
  • 1
  • 3
  • 13
0
votes
1 answer

How to use period in PARM parameters (JCL)?

The situation is the following. I have PARM parameters: CSQ1 - Queue manager name CARD.PAYMENTS - Request queue name CCD3050.REPLY - Reply queue name CCD3050 - Contestant user ID 400.05 - Payment amount "MY PAYMENT" …
user3275068
  • 15
  • 3
0
votes
1 answer

What's wrong with my C-code?

Working in z/os mainframe, I have the following situation. I can't record a transaction. here is my code, it is written for transaction using jcl. Bur something goes wrong. /* Include standard C header files */ #include …
user3275068
  • 15
  • 3
0
votes
1 answer

PARM value not interpreted as expected

Working in z/os mainframe, I have the following situation 1) That's my JCL, which I've submited: //PAYMENT JOB MSGCLASS=H //****************************************************************** //*…
user3275068
  • 15
  • 3
0
votes
1 answer

Why is z/OS USS "date" command output different from TSO TIME?

A "date" command on USS says: Wed Jan 22 17:51:30 EST 2014 A couple of seconds later, a TSO TIME command says: IKJ56650I TIME-04:51:58 PM. CPU-00:00:02 SERVICE-196896 SESSION-07:08:30 JANUARY 22,2014 (There's a one-hour time zone difference.) TSO…
Singlestone
  • 2,019
  • 3
  • 16
  • 18
0
votes
2 answers

MQ EOL Data conversion

we are sending data trough MQ from a z/OS/CICS system to an AS400. Original encoding of the message is CCSID 500 with a MQSTR Format. The client application is getting the message with the CONVERT option and CCSID 819. Data is almost converted…
lemotdit
  • 448
  • 1
  • 10
  • 21
0
votes
1 answer

Error while creation of queue in WebSphere MQ for z/OS

The problem is regarding IBM z/OS and WebSphere MQ. The task at hand is to create(define) a reply queue for WebSphere MQ. This is the main WebSphere terminal: IBM Websphere MQ for z/OS - Main Menu1 The reply queue is to be defined with all the…
user3067345
  • 1
0
votes
1 answer

z/OS TSO STACK MACRO to specify alternate DDnames

I am trying to use the STACK macro ( http://pic.dhe.ibm.com/infocenter/zos/v1r11/index.jsp?topic=/com.ibm.zos.r11.ikjb700/lfosmi.htm ) to specify an alternate DDname for SYSTSPRT, but I can't get it to work. Has anyone ever had success with STACK…
mike
  • 819
  • 4
  • 14
0
votes
1 answer

DB2 10 for Z/OS, SQL LIKE Column Value Plus Wildcard DB2 w/o losing stage 1

So, this is related to SQL LIKE Column Value Plus Wildcard DB2, but a more specific question b/c of the OS So, I want to: select a.columnA b.columnZ from a join table b on b.columnB LIKE a.columnA || '%' b.columnB is an Index and I'd like…
johnnyB
  • 77
  • 1
  • 10
0
votes
2 answers

Does JasperReports read the columns metadata before generating reports?

I have a few JasperReports made and running very fine on a Windows machine. The problem started when the reports were set to run on a mainframe with zOS operating system. The problem is: when Jasper creates the report it seems to read the tables…
mohdajami
  • 9,604
  • 3
  • 32
  • 53
0
votes
0 answers

Using NORMALIZE_STRING inside of a UDF --> "VARIABLE ... IS NOT DEFINED OR NOT USABLE"

I am trying to use NORMALIZE_STRING inside a stored function under DB2,: CREATE FUNCTION foo(INSTR VARCHAR(4000) CCSID UNICODE) RETURNS VARCHAR(4000) CCSID UNICODE READS SQL DATA APPLICATION ENCODING SCHEME UNICODE BEGIN …
Matthias
  • 12,053
  • 4
  • 49
  • 91
0
votes
1 answer

DB2 V10 zOS JDBC getting SQLCODE -302

I'm trying to execute a query against z/OS DB2 using JDBC Type 4 Connection. The query is simplified: PreparedStatement stmt = conn.prepareStatement("SELECT * FROM EMP WHERE ? = ' ' OR NAME = ?"); stmt.setString(1, "Joe"); …
user2740037
  • 3
  • 1
0
votes
2 answers

Does Flyway support DB2 for zOS?

Does Flyway support DB2 for zOS? The information here http://flywaydb.org/documentation/database/db2.html seems to indicate it is only tested on DB2 for LUW.
skytis
  • 3
  • 1
0
votes
1 answer

How can I connect to SUPRA database from a Java application, without the supported JDBC driver

I want to work supra database and my application is written in Java. I need use tje Java JDBC for connect supra. We use lib and jar file for connect to another database like Mysql and Oracle. Is there a tool or lib to connect supra database? - java…
mojtaba
  • 1
1 2 3
…
40 41