Recent content by MIKELEIBO

I know this information is in SYIBM. tables. Just can't find it :( Thanks, Mike

My boss asked us if our "stuff" will work once we go to DB2 V8. I know that vs cobol is no longer supported - anything else to be aware of? Do you have a pointer to aa differences chart? thanks, Mike

Sorry that I'm having trouble explaining this but you almost have it stated right... It must have been my error If the rows look like this. AA1,AB1,null,null AA2,AB2,null,AA3 AA3,AB3,AA2,null The result has to look like this. AB XY XZ == == == AB1 ' ' ' ' AB2 AB3...

Thanks! I hope you can help. xy AND zy ARE COLUMNS IN TABLE ST. THEY REFERENCE OTHER ROWS IN THE TABLE (A SORT OF FOREIGN KEY?) WHERE xy/xz can = aa. SOMETIMES XY/XZ are NULL. I have to get ab(other row) when ay(1st row) = aa(other row) There are two tables; ST and SX both provide columns in...

Problem: Table ST with column aa, ab, ac, etc. has column ay pointing to another row in table ST where aa = xy. az also matches to aa in different row in ST. (sometimes xy and az are filled and sometimes not). The result table has to show: a.aa, a.ab, a.ac, b.xx (c.ab(xy = aa) or ' ')...

You guys are basically correct - thanks - the systems programmer decided to update the sytem to cobol complier 3.3.0 and "somehow it got changed xpeditor" to 3.3.1 - of course, he never notified anyone that he was altering the environment.

anyone have a clue how to fix this? PCOPTN008-S LANGUAGE NOT DETERMINED, PROCESSING MAY NOT BE COMPLETE. PCDRVR053-I ** ERRORS PROCESSING LISTING DATED 20 AT; LISTING NOT WRITTEN

I fixed it and my guess about a duplicate key was correct, (but lucky). This file had three different indices - prinmary and two secondary keys, all defined as unique. I managed to establish a test environment (many DB2 tables and VSAM files). I then ran under expeditor and put a stop in the...

yes - file-status

thanks for asking... and helping... 3. Because I am guessing and the 44 makes no sense for other reasons. 1. It is a program that has worked without change for a long time... 2. SELECT ACCOUNT-OUTPUT-FILE ASSIGN TO ACCTOUT ORGANIZATION INDEXED...

While not exactly a COBOL question, problem is occuring in a COBOL program... According to everywhere I search, a code 44 means a VSAM rewrite where the length was changed or a write of a record that isn't within the specified file sizes, (too short/too long). However, the problem is occuring...

I am trying to new copy a program, one of a series, using cemt do to a commarea change. All of the programs new copy except for one, which shows a resident count of one. How do I remove it from residency? cemt s prog(x) ne STATUS: RESULTS -...

greek - i can use your help - all these new languages are Greek to me

I don't know if this is still supoported but we used to define files as format "U", (undefined), in jcl. you used to be able to bypass dcb processing. (i come from a world where we had 4k machines. we had to write our own iocs, (input output control system), and do necessary label...

Amazing how we complicate the simple. If it's numeric, it will past a numeric test and can be refined as numeric and used that way. If it contains alpha characters - it ain't numeric, was created inproperly as the result of poor design or poor data entry controls, so attempts to treat it as...