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

Does IBM Z/OS Connect EE allow authoring custom REST API

In our current project , We have a need to run queries from Azure on z/os systems. We plan to use IBM Z/OS Connect EE for integration from Azure cloud to Z/OS. We found that Z/OS Connect EE provides out of box features, to construct API on z/os…
user27032018
  • 1
-1
votes
1 answer

oracle sql to db2 sql

I have to change an Oracle SQL DDL to use it in zOS/DB2. Now I'm stuck in this part: ... ATTRIBUTE1 char check (IS_FINISHED in (0,1)), ATTRIBUTE2 char check (HAS_ERROR in (0,1)),... I have never used a 'check' in oracle, neither in DB2. Can…
dandelion
  • 3
  • 2
-1
votes
1 answer

DB2 Z/OS native stored procedures, Restful WebService ,JSON

I am thinking to create a DB2 Z/OS native stored procedures that calls Restful service with JSON as interchangeable format. Is it possible to consume Restful/JSON ? If yes can you provide some documentation or info. Thanks
VenkataK
  • 11
  • 2
-1
votes
2 answers

Z390 Assembler, first time coding

So I'm trying to learn assembler and I'm using z390 as an emulator(not my choice) and I'm having a great deal of difficulty. I was hoping for some help because I have ALOT of errors. Here's the assignment: So I took the college try at it and got…
Frank
  • 75
  • 2
  • 13
-1
votes
2 answers

How can I run ISPF Edit Macros in Batch

I frequently write and use ISPF edit macros. However, invoking them in foreground is time consuming. Can I use a Rexx program to run the edit macros against all, or a selection of, members of a PDS via batch?
MikeT
  • 51,415
  • 16
  • 49
  • 68
-1
votes
2 answers

Mule ESB and Mainframe integration possible solutions

i am trying to connect mainframe from MuleESB we have CICS regions but i am not sure how useful CICS regions to connect and do we need to connect MQ to intgrate with Mainframe. is thr any way with out connecting MQ can we connect mainframes
Chandra
  • 1
  • 3
-1
votes
1 answer

Error in DB2 on z/OS revoke

I am observing weird behavior with db2 z/OS revoke operation. Suppose I create a user, assign some privileges and try to drop a user or if I try to revoke some privileges, I get error "DB2 SQL Error: SQLCODE=-556, SQLSTATE=42504,…
Aniruddh Kulkarni
  • 1
-1
votes
1 answer

Email intercepting techniques

I have a requirement where I intend to build a tool to scan the email contents including the attachments. The email servers is either going to be SendMail or z/OS Communication Server, both support SMTP. The sever is not Miscrosoft implementation so…
User2709
  • 573
  • 5
  • 17
-1
votes
1 answer

SORT to replace a column in JCL

Do you know a command to sort a file to replace a column with the same value in all the rows? For example, I want to generate a new file with the same order as the original, except at the column 66 to 68, I want to put XX in all the rows. Note: the…
Nico
  • 309
  • 1
  • 3
  • 18
-1
votes
1 answer

Im not seeing Datasets on the envirnoment z/OS unix shell

Just to give the context I had the same doubt of the our coleague @JOB in this Thread: "Unable to Access PDS , ok its was solved. I have one question which is related to: Why when us are on that envirnoment Linux, from the command TSO OMVS, we…
Edifirst
  • 88
  • 5
-1
votes
1 answer

How to create a top generic racf profile from rexx

So i'm definig users to racf on a z/OS (ADCD version at my university) using a rexx script. Therefore i want to create top generic profiles for the users in order to secure their datasets. Say i'm creating a user called TEST1. Therefore i would use…
Jonas Kreusch
  • 316
  • 1
  • 15
-1
votes
1 answer

How to delete the millions of records from a db2 table

I am using DB2 9.7 for Z/oS. I have a table with 10+ million rows and I want to delete about 9 million rows. I have tried with below stored procedure, but without success. CREATE PROCEDURE DELETE_DATA (IN V_TABLE_NAME VARCHAR(24), IN…
Bobby
  • 320
  • 5
  • 23
-1
votes
1 answer

z/os DB2 V 9.1 MUTIPLE ROWS INSERT FAIL ERROR CODE -104

Inserting a single row is successful, but inserting multiple rows is not working. INSERT INTO EMPLYEE(EMPID,EMPNAME,DEPARTMENT,SALARY,DESIGNATION) VALUES('1000','XXXXXXX','XX',10000,'SE'), …
user3789104
  • 1
  • 1
-1
votes
1 answer

Site code to enable UTF-8 to EBCDIC encoding

I'm trying to transmit a rather large UTF-8 file to a Z/OS dataset. Unfortunately, the command SITE EN=MBCS MBD=(1047,1208) RECFM=VB TYPE A STOR STORE.WRK.DATA responds with 504 Multi-byte encoding not supported for RECFM=FB It seems the…
Stavr00
  • 3,219
  • 1
  • 16
  • 28
-1
votes
1 answer

unable to create a database connection using Aqua Data Studio ETL tool

When try to connect to DB2 Z/OS, the following error message is displayed, [jcc][t4][10509][13454][3.67.28] Connection to the data server failed. The IBM Data Server for JDBC and SQLJ license was invalid or was not activated for the DB2 for z/OS…
Muthuraja S
  • 1
  • 1
1 2 3
…
40
41