Recent content by amosgreg

I found the following yesterday and can't find the link quickly. It was from a dissertation about modernization of COBOL and I found it relevent but make your on mind up. Greg APPENDIX A - Rules for Modernization of Programs RULE 1 - Use "/" in column 7 and blank or comment lines to...

I think you are going to have to set up a looping mechanism of some sort and insert each row 1 at a time. (ugly, I know).<br>The select Max function will give you your autonumber but as you founf out the rows are processed as a whole.<br><br>I havn't had time latly to play with this sort of...

I don't think you have an option. You say you cannot change the migration job SQL and since this is the case you have no way of associating the Table name with the column.<br><br>If the migration job &quot;MUST&quot; be used as is there is nothing that I am aware of that will solve your...

Try Naming the result as ( Ithink this is the syntax but look it up)<br><br>Select Person.name as person.name, state.name as state.name<br>from person, state ....<br><br>again it goes something like this but check the manual fro the exact syntax.<br><br>Hope this helps<br>&nbsp;&nbsp;Greg...

Another way would be if the files are keyed,<br>(Psudo Code)<br>Sort both files on the same key<br>read 1 record from both files (Prime Read)<br>&nbsp;&nbsp;&nbsp;Move each record to a single working storage area of the length of the record&nbsp;&nbsp;File-1-rec...

I just attended aN IBM roadshow for S390 and one of the topics covered was Web Enabling CICS.<br>The Transaction Gateway that is a current module with CICS allows you to reassemble BMS maps to generate HTML pages.<br>You need to do NO recoding of the CORE CICS application!<br>This was very cool...

Check out the IBM Web site <A HREF="http://www.ibm.com" TARGET="_new">www.ibm.com</A> and search on COBOL, or go to the COBOL Homepage. They have an on-line Library that contains most of the current Redbooks and other manuals on bookmanager. you should be able to get the information there. Look...

Try thr IBM DB2 Web site on-line library at the following address.<br><br><A HREF="http://www-4.ibm.com/software/data/db2/library/" TARGET="_new">http://www-4.ibm.com/software/data/db2/library/</A><br><br>There are a couple of Messages and Codes referances that should answer your question...

The problem I have had with most (and I should bold and cap the word most! ) is that the content ranges from very easy with an extreamly long curve to get into the detail, or the opposite in which even at the introductory level the detail is overwelming. I have yet to take a on-line course or...

Try the IBM Web site&nbsp;&nbsp;<A HREF="http://www.IBM.com" TARGET="_new">www.IBM.com</A> and search on DB2 this should bring up a link to the IBM DB2 on-line library.<br>you should be able to find an answer there. I believe that you can use the substring to break up the data but unless you are...

That should be do-able.<br> <br> In Psudo code<br> read the table sequentially<br> do while (or similar for each entry) loop <br> use the called key as a foreign key and in the loop read the calling table. <br> As long as there is a return add this relationship to your output...

Depending on how large this field is you might use a CLOB or just a variable Char field. Thwe CLOB is a character Large object and can be stored on a seperate table with a pointer to it so DB2 does not need to read that field for joins and other queries not requiring this field.<br> Try the IBM...

Another approach would be to import the table from access,<br> Create a table in thhe format you want and write a conversion script to move the values from on table to another with the length and format changes you require.<br> Yes this is a fair amount of work but it also prepares you for...

Word to the wise, <br> Learn the "Boring CICS terminal Text" method. It is complicated enough that trying to go "All Out" as you put it will mean you spen to much time on the VB front end and not enough on the handling of the CICS code.<br> <br> If you have the CICS application finished with...

IBM also has developed Enterprise JAVA Beans that will call CICS. These allow teh GUI to be JAVA, execute the BEAN and pass the required parameters to the bean for the call.<br> <br> (I have use the word call for clearity, I have not used the beans yet so I am not exactly sure if it is a true...