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 Chriss Miller 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 dhecht

  1. dhecht

    how the change the value of return code

    set maxcc and set lastcc work directly in the jcl without forward slashes
  2. dhecht

    how the change the value of return code

    In a COBOL progam you can set the RETURN-CODE system variable which will populate that value in the LASTCC and MAXCC variables in the JCL. You can check LASTCC (the return code of the last step) or MAXCC (the highest return code for all steps) implicitly by coding the COND= statement on the...
  3. dhecht

    Appending records to a sequential file

    Here's a link which may be helpful and a snippet from the page. http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/igy3lr00/6.2.26?ACTION=MATCHES&REQUEST=open&TYPE=FUZZY&SHELF=&DT=20011206182158&searchTopic=TOPIC&searchText=TEXT&searchIndex=INDEX&rank=RANK&ScrollTOP=FIRSTHIT#FIRSTHIT...
  4. dhecht

    Linkage Section : Occurs Clause

    As a caveat, careful your subscript doesn't ever extend beyond the last element or you'll start referencing procedure division code, with extremely unpredictable results.
  5. dhecht

    Stored Procedure Builder Debug Features Disabled??

    I think interactive debugger requires sp compiled by not linked source residing locally on a workstation in order to see activated dubug pull-downs. That is, the debugger actually requires addressibility to C code on the local workstation. (When sp's are compiled, a C deck is created.) After...
  6. dhecht

    set the transaction isolation level in a stored procedure

    This is a bind parameter ISOLATION. Most common is CS (Cursor Stability.)
  7. dhecht

    Retrieve data from second database using stored procedure

    In an OS/390 platform, you can use DDF (Distributed Data Facility.) This is an OS/390 address space. This requires binding remote packages locally in the BIND PLAN PKLIST parm by specifying the remote node, collection name, package name or wildcard. You CONNECT in you application code to the...
  8. dhecht

    Determining SP Status via DML

    Using z/OS DB2 V6., I need to determine if a stored procedure is stopped or started by running DML. I can't locate a status-type column in SYSROUTINES. Where is DB2 getting this information when a DSN -DISPLAY PROCEDURE command is issued? Thanks.
  9. dhecht

    How can I display Arabic,Chinese or Thai characters In cobol

    Here's an IBM link discussing COBOLs national language support: http://www-3.ibm.com/software/ad/cobol/zos/about/
  10. dhecht

    Index Foreign Keys

    Is it always a good idea to index foreign keys or should this be done only when parent rows are deleted? That is, do indexes on foreign keys improve Select, Insert, or Update performance. I've heard 'do it always' and 'only when parent rows often deleted'. If a general rule is to use indexable...
  11. dhecht

    VSAM to DB2 conversion - SQL

    Use the IBM-supplied sample program DSNTIAUL to create load cards. This is an unload program. Although there will not be any data, the program will still create the load cards. If there isn't a one-to-one correspondence between VSAM files and tables (and there shouldn't be if the model is...
  12. dhecht

    Merging files

    Depends if the 2nd file is appended to the first or acutally 'merged'. The queston doesn't state what the index key is. Perhaps it's customer number not date. So, the merged file woudl have cust 1, date1, date2....cust2, date1, date2. What we do know is that both files contain May data. Are...
  13. dhecht

    Merging files

    Rather than writing a program, why not use a product like SYNCSORT to do the merge? Also, if you have Easytrieve Plus, he'll do about the same thing and will give you a report if you want it. I'm not sure what either of these products will do with an ISAM file. You may have to repro them down...
  14. dhecht

    JCL

    In a nutshell, though I'm sure someone will have a more scientific definition, JCL(Job Controll Language) executes a progam (compiled and linked machine code) within a load library, providing a number of resources to that program: File names (data files, work files), input parameters, and other...
  15. dhecht

    Page Numbering

    I've tried different combinations without success. Placing cursor on the page I want to being paging on, hitting next page one time, coninuous the next; then inserting page numbers with continue from next section selected or not selected. I'll still get page numbering starting at the first page...

Part and Inventory Search

Back
Top