Recent content by jrohrbach

A second solution is to get the date portion of the column value and compare it to your value: Select * from schema.table where DATE(table.TS_LOAD) > '2005-11-23'; Ever onward, jar

From the reference I have available, In other words, check the data being used within the abending instruction. :-) Ever onward, jar

If your question is how to split your screen when in that application, the answer is to enter the "SPLIT" command on the command line, assuming that the developer did not take away the command line as well. Another possibility is using "KEYS" command to redefine the PF key definitions within...

Along with the aforementioned "gotcha," the problem with a relative GDG reference such as (0) or (-24) is that the file being referenced will change if anyone creates a new version of the file. If it is critical that you get the 25th version, then the best way is as "NS10.RAD.CFILE.G0025V00"...

Unfortunately, some files are too big to be "viewed" and will automiatically invoke "browse" mode. For a file like that, you need to either use a third party tool to select only the records you are intersted in, or use IEBGENER or SORT to copy only those records to another file. Ever onward, jar

You can use the LISTA command to find out what datasets are allocated to your TSO session. From within ISPF, for example, enter this on any command line: TSO LISTA HISTORY STATUS It is not a pretty display but is fairly easy to decipher. You should be able to tell which datasets are...

The problem is that symbolic parameters can not be used everywhere within the JCL, but rather only certain places: However, there is more than one way to skin a cat. I can think of two alternatives off the top of my head. (1) Use a DDNAME reference and code all the required "LABELxx" DDs...

Is this one column of one rwo or multiple columns? Any column can be edited, that is, updated, so long as it is not one of the index keys. The short answer is that you would fetch the row, manipulate the data as deisred, then update the row with the new value for that column. If what you are...

I do not have any experience with DB2 Universal Database Express Edition. However, I have to believe the the system tables are there somewhere. I make tremendous use of SYSTABLES, SYSTABLESPACE, SYSPLANS, and the like. I had never used SYSDATABASE until you posed your question but found it...

I have no experience with JDBC and therefore can not tell you how to make use of this information, but on the mainframe, the SYSDATABASE table contains all the databases within a particular DB2 system. For instance, I might use SELECT * FROM SYSIBM.SYSDATABASE to see what what was out there...

In a little greater detail... Depending on the severity of the error and how I want the system to respond, I have also used ILBOABN0: (above quote taken from Enterprise COBOL for z/OS Compiler and Run-Time Migration Guide Version 3 Release 3 Document Number GC27-1409-02) There's always more...

I heartily recommend Zapp! The Lightning of Empowerment: How to Improve Productivity, Quality, and Employee Satisfaction by William Byham and Jeff Cox. It is a light read and presents a lot of good lessons on general management philosophy and skills. I reread it about once a year not only to...

Which version of the compiler are you using? I just ran a test using "IBM ENTERPRISE COBOL FOR Z/OS 3.3.1" with the following results: Program - ... 01 WS-QUEUE-LEN PIC S9(4) COMP VALUE +32000. ... DISPLAY 'WS-QUEUE-LEN = ' WS-QUEUE-LEN. ... Results - WS-QUEUE-LEN =...

Although this is not specific to COBOL, it is always useful to know the actual rule involved, if for no other reason than to remind ourselves that oversimplification is dangerous. - excerpted from http://aa.usno.navy.mil/faq/docs/easter.html Pedantically yours, jar

The simple answer, to the best of my knowledge, is that cursors are for use within application programs and not within interactive environments. In other words, yes, you have to compile and execute your program in order to test your cursor logic. Ever onward, jar