LEFT OUTER JOIN IN COBOL VSE ENVIRONMENT

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
mcovre
Member
Posts: 2
Joined: Thu Apr 29, 2010 5:11 pm

LEFT OUTER JOIN IN COBOL VSE ENVIRONMENT

Post by mcovre » Thu Apr 29, 2010 5:21 pm

Hi, is it possible to embed an SQL statement with OUTER JOIN or INNER JOIN keywords in a COBOL program connecting to a DB2 7.5 server for VSE
example:
SELECT EMPNO, LASTNAME, PROJNO
FROM CORPDATA.PROJECT RIGHT OUTER JOIN CORPDATA.EMPLOYEE
ON EMPNO = RESPEMP
WHERE LASTNAME > 'S'


Thank you in advance for your help

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Fri Apr 30, 2010 2:54 pm

The only suggestion I can give is - please try this out.
Regards,
Anuj

mcovre
Member
Posts: 2
Joined: Thu Apr 29, 2010 5:11 pm

I WOULD IF I COULD

Post by mcovre » Fri Apr 30, 2010 8:20 pm

You're right...but I can't...I need to know the rules without having the chance to test them...I have to teach to some programmers how to write a db2 cobol program, and i just have this doubt, because they work with VSE instead of MVS, where I'm used to work...

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Sat May 01, 2010 1:22 pm

Regards,
Anuj

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others