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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. amosgreg

    Need good advise on COBOL reference for rewriting programs

    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...
  2. amosgreg

    TRIGGER for MULTIPLE ROWS INSERT

    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...
  3. amosgreg

    no tablenames: db2 on win_nt via odbc

    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...
  4. amosgreg

    no tablenames: db2 on win_nt via odbc

    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...
  5. amosgreg

    Comparing two sequential Files

    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...
  6. amosgreg

    GUI interface

    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...
  7. amosgreg

    Differences between COBOL II and COBOL 370

    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...
  8. amosgreg

    QMF 6.1.0 Installation problem

    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...
  9. amosgreg

    Online learning - will it replace the class room?

    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...
  10. amosgreg

    Insterting from a flat file

    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...
  11. amosgreg

    TreeView Applet using an Ms Access Database

    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...
  12. amosgreg

    Migrating MYSQL to DB2

    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...
  13. amosgreg

    ACCESS bites again!

    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...
  14. amosgreg

    VB GUI Interface with COBOL85

    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...
  15. amosgreg

    GUI interface

    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...
  16. amosgreg

    ACCESS bites again!

    Make sure you take the time to read the manual on the DB2UDB. What you want to use is the ALTER TABLE command.<br> This is assuming you have the proper authority to do so.<br> Make sure you have also set up your log-on at an Administrator level.<br> <br> Also there is a great DB2 On-Line Library...
  17. amosgreg

    Writing and reading

    Since this is a PC project, you might try <br> ORGANIZATION IS LINE SEQUENTIAL<br> for both your files. <br> Try this and see if this helps.<br>
  18. amosgreg

    Mainframe connect

    You are going to need an emulator program. This is a program that allows connection to and communication with the Mainframe. Generally this is thru TCP/IP so if the school allows you access(unlikely) and if they will let you load the emulator to your home PC(generaly a program that loads like...
  19. amosgreg

    Basics of e-commerce?

    MBH mentioned the need for a very strong back-end. This is an area I feel is being overlooked in the grand scheme on E-Business in most peoples minds. The connection to the 'normal' day-to-day processing that is a regular part of any businesses daily routine(Order processing, Accounting...
  20. amosgreg

    E-Commerce tools eg programming,database, communication software

    IBM web site <A HREF="http://www.ibm.com" TARGET="_new">www.ibm.com</A> and do a search on e-commerce or e-business. It has some very interesting ideas about E-Commerce. FaisalSaleem in his/her post gave a good overview to the Web side but don't forget the total back-end (HOST/Legacy)...

Part and Inventory Search

Back
Top