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 following section of an assembly listing 000006 5020C03A 00003C (1/21)21 ...
I have a situation in BIRT reporting. A report I created is insisting on displaying some fields as blank rather than zero. The situation arises when the field is actually a sub-select that returns no rows. So for example, if the select includes: 0 as p3, then the 0 is displayed okay. If however, the select has: (select sum(other_fie...
This is a follow up to this question. I'm totally blind so printed books aren't an option. All the recommended books appear to have been published before electronic publishing got started. I've been able to learn the very basics but would like something between here's what a register is, and the IBM reference material. Searching the norm...
I'd like to use JPA over JDBC for a new application. I'm strictly using Named queries and basic CRUD methods of JPA Entity manager, which allows me (with the help of Hibernate, or any other JPA implementation) to extract all SQL native queries that will be performed on the database. With this list of static queries, I understand that I c...
I am writing a C program in Unix System Services on a z/OS mainframe. One of the requirements is to get a sequence number from a DB2 database residing on the same mainframe. Not having DB2 Connect available, I'm wondering what my options might be. I can open a socket on port 50000 (the default DB2 port), but, from the IBM documentation I...
Hello, We are attempting to rework the SQL in a product. The product stores XML in a table as follows: XML_STORAGE - UID IDENTITY - PARENT_ID INTEGER - SEQ INTEGER - XML VARCHAR(3800) The current way of doing this is as follows: Retrieve all ROWS for PARENT_ID = n. Then go over the fetched rows in the code and concatenate the X...
We have a requirement to delete rows in the order of millions from multiple tables as a batch job (note that we are not deleting all the rows, we are deleting based on a timestamp stored in an indexed column). Obviously a normal DELETE takes forever (because of logging, referential constraint checking etc.). I know in the LUW world, we h...
If you ask a DB2/zOS engine DBA a question about DB2's behavior, the DBA will refer to the DB2 engine as "he" much the way a sailor uses "she" to refer to his ship. For example: "Once you fill the freespace, DB2 still wants to keep those rows in cluster order in the tablespace. That's why he'll split that page in half, and you end up w...
I am comparing some CHAR data in a where clause in my sql like this, where PRI_CODE < PriCode The problem I am having is when the CHAR values are of different lengths. So if PRI_CODE = '0800' and PriCode = '20' it is returning true instead of false. It looks like it is comparing it like this '08' < '20' instead of like '0800' <...
Hello, We are attempting to get the native CCSID (char encoding) on a z/OS system? Is there a way to retrieve the native CCSID on z-series system using XL C/C++ runtime routines or any other C/C++ routine? Please let me know. Thanks! - Azeem ...
Hello, How can i use the IEBGENER utilty to copy a member from one pds to another. something similar to this: //myjob job1 // exec pg=eibgener ?? don't know the the rest. ...
Hi, I'm wondering one thing with REXX-language, how it handles data set locks. The situation: - I have sequential data set open in my ISPF-editor - I start REXX-program what updates (makes changes) that data set - it works fine, but how it is possible? Normally if you have data set open in your editor and you try to use that from anothe...
Is it possible to force all create table statements to use a specific database.tablespace by passing a parameter to the JDBC URL? For example instead of manually specifying it as follows CREATE TABLE Message (id INTEGER NOT NULL, created TIMESTAMP, message VARCHAR(255),PRIMARY KEY (id)) in DATABASE.TABLESPACE I'd like to specify "...