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

    subselect - Resultset in a comma separated row

    LOOKS LIKE NOT POSSIBLE BY USING SQL; PLEASE LET ME KNOW, IF YOU HAVE SOLUTION. THANKS.
  2. delta403

    multiple table access in COBOL

    This can be done by two way: 1. Please check on the below link http://mainframealldtime.wordpress.com/2012/05/01/positioned-update-in-db2/ or, 2. develop a store procedure or sub program and call the sub program with different year value. Please let me know if you have any question.
  3. delta403

    How do I convert hex into numeric

    You can use the inspect verb to solve: INSPECT PORT REPLACING LEADING SPACES BY "0". MOVE PORT TO WS-PORT-NUM. ;where WS-PORT-NUM will be defined as PIC 9(05).
  4. delta403

    Conditional parsing on sort clause

    Can you please share your table information?
  5. delta403

    How to write case statement

    I think you should use the '=' operator. like below Case When Config.tblManagementUnit.TimeZone = "US/Central" then (StartMinute+60)
  6. delta403

    Committed records after program abends

    if you have file system, it is good idea that you should divide the file with 1000 records. Use split files code of FILEAID in JCL. and then run each file in another step. Hope it will work for your file system.
  7. delta403

    subquery in From Clause

    There should be data type mismatch. Please share the SQLCODE for abend.
  8. delta403

    Committed records after program abends

    No. Each Unit of work represented by completion of commit. if the prev UOW is completed with Commit then the abend of job will not roll back the previous committed records in DB2.
  9. delta403

    SQL statement for approximate string matching

    We can simplyfy the same query as below: SELECT (CASE WHEN LOWER(COMPANYFULLNAME) LIKE '%mic%' THEN 1 WHEN LOWER(COMPANYFULLNAME) LIKE '%icr%' THEN 1 WHEN LOWER(COMPANYFULLNAME) LIKE '%cro%' THEN 1 ELSE 0 END) FROM COMPANY;
  10. delta403

    Using BMS, how to code a row containing a bank # field 11 times?

    First define a group in the BMS as below: BANKNBR DFHMDF POS=(ROWNO,COLNO),ATTRB=(UNPROT,NUM), X LENGTH=4,GRPNAME=BANKS,OCCURS=11 BANK1 DFHMDF POS=(ROWNO,1),LENGTH=4,ATTRB(UNPROT,NUM), X GRPNAME=BANKS BANK2 DFHMDF POS=(ROWNO,6),LENGTH=4,ATTRB(UNPROT,NUM), X...

Part and Inventory Search

Back
Top