Search results for query: *

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

There seems to be some confusion here between EDIT and ISREDIT. The former invokes the editor while the latter identifies edit macro commands. There is no edit macro specifically named "ISREDIT" unless you write one and place it into an appropriate library (CList, REXX exec, or loadlib...

When I was in college, we distinguished people as being "geeks, freaks, and jocks." A geek was one that studied a subject all the time and talked about little else but had no real flair or style (which matches a dictionary definition I found, "singled-minded or accomplished in scientific or...

Having used TSO for 25+ years and ISPF for as long as it has been around (and SPF before that and FSE before that), I have picked up a thing or two along the way. Before I just go spouting off, though, I'd like to know if you are asking about TSO/ISPF in general or specifically as they relate...

If year_description is a numeric field and will always be greater then 1998, you could use something like: EXEC SQL SELECT CHAR(year_description - 1998) INTO :year_code ... If year_description is a character field, it is a little more difficult. And if I have misunderstood the...

Apparently, the TIME FORMAT for your system is set to ISO (International Standards Organization), which gives the time as HH.MM.SS. In order to convert the time to HH:MM:SS, you need to use the CHAR function and the JIS (Japanese Industrial Standard Christian Era) format as follows...