Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jrohrbach
-
How to handle operators and dates
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 -
S0CE...What is it and how do I get rid of it? (newb here)
From the reference I have available, In other words, check the data being used within the abending instruction. :-) Ever onward, jar- jrohrbach
- Post #2
- Forum: COBOL General discussion
-
ISPF Split Screen
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... -
Accessing GDGs
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"...- jrohrbach
- Post #4
- Forum: COBOL General discussion
-
x all; fall in browse mode
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 -
Branch Functionality
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...- jrohrbach
- Post #7
- Forum: COBOL General discussion
-
JCL - use symbolic in a LABEL?
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...- jrohrbach
- Post #3
- Forum: COBOL General discussion
-
Is it possible to edit a row in a table?
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... -
list the name of all databases
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... -
list the name of all databases
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... -
Set JCL cond code from within COBOL program
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...- jrohrbach
- Post #3
- Forum: COBOL General discussion
-
management book
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...- jrohrbach
- Post #13
- Forum: My own development as a professional
-
I can't write TS QUEUE of 32,000 bytes of lebgth
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 =...- jrohrbach
- Post #2
- Forum: CICS (IBM)
-
Holiday Processing
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- jrohrbach
- Post #4
- Forum: COBOL General discussion
-
Cursor... Read only?
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
