IBM Mainframe Forum

Mainframe Technical Support Forums

Skip to content


JCL to execute PL/I w ISPF tables & DB2 tables



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...
Post a reply

Re: JCL to execute PL/I w ISPF tables & DB2 tables

Postby pucca71 » Mon Nov 01, 2010 9:50 am

Hi Dick,
I did post it within the JCL section. The dsname is LIQUIDL.LIQUID.PTABL.
I continued trying and finally I got it solved.

At the first time I have coded:
CALL ISPLINK('LIBDEF ',ISPTABL ,'DATASET ',('LIQUIDL.LIQUID.PTABL')); which ended with the mentioned error, but, if you count the characters, it is not greater than 44 at all.

Then I've tried to take out the owner id and corrected the quotes, so I left:
CALL ISPLINK('LIBDEF ',ISPTABL ,'DATASET ','(LIQUID.PTABL)');

which worked.

Hi Nic,
Thanks for checking ! I know it is an unusual combination, but it is what was requested to me.
I am still trying to find out how to invoque the DB2 part.

Thanks !
Thank you so much.
Pucca.
User avatar
pucca71
 
Posts: 19
Joined: Wed Sep 22, 2010 6:38 am
Has thanked: 0 time
Been thanked: 0 time
Top

Re: JCL to execute PL/I w ISPF tables & DB2 tables

Postby NicC » Mon Nov 01, 2010 10:44 am

I think you may have a lot of reading to do and redesign! Start with the 'DB2 for 'your release' Application Programming and SQL Guide'. I was looking at the OS390 V5 guide.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times
Top

Re: JCL to execute PL/I w ISPF tables & DB2 tables

Postby enrico-sorichetti » Mon Nov 01, 2010 12:18 pm

the most practical way for accessing DB2 within an ISPF dialog is to use CAF
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3006
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 165 times
Top

Re: JCL to execute PL/I w ISPF tables & DB2 tables

Postby pucca71 » Mon Nov 01, 2010 6:46 pm

Thanks Enrico !

I will try CAF and let you know.
Thank you so much.
Pucca.
User avatar
pucca71
 
Posts: 19
Joined: Wed Sep 22, 2010 6:38 am
Has thanked: 0 time
Been thanked: 0 time
Top

Re: JCL to execute PL/I w ISPF tables & DB2 tables

Postby pucca71 » Wed Nov 10, 2010 8:45 am

Hello all,

Finally the job that worked was like this:
Select all
//*-------------------------------------------------         
//* EXECUTION                                               
//*-------------------------------------------------         
//ST01 EXEC PGM=IKJEFT01                                     
//STEPLIB  DD DSN=LIQUIDL.PLI.LOAD,DISP=SHR                 
//SYSPROC  DD DSN=DSN2.NEW.SDSNCLST,DISP=SHR                         
//         DD DSN=CEE.SCEELKED,DISP=SHR                             
//         DD DSN=DSN2.SDSNLOAD,DISP=SHR                             
//         DD DSN=ISP.SISPLOAD,DISP=SHR                             
//         DD DSN=DSN2.RUNLIB.ENTPL1.LOAD,DISP=SHR                   
//*- - ALLOCATE PROFILE, PANELS, MSGS, PROCS, AND TABLES -*/         
//ISPPROF  DD SPACE=(CYL,(1,1,5),RLSE),UNIT=SYSDA,                   
//            DCB=(RECFM=FB,LRECL=80,BLKSIZE=23440)                 
//ISPPLIB  DD DSN=ISP.SISPPENU,DISP=SHR                             
//ISPMLIB  DD DSN=ISP.SISPMENU,DISP=SHR                             
//ISPSLIB  DD DSN=ISP.SISPSENU,DISP=SHR                             
//         DD DSN=ISP.SISPSLIB,DISP=SHR                                                 
//ISPTLIB  DD DSN=ISP.SISPTENU,DISP=SHR                             
//CPTABL   DD DSN=LIQUIDL.CSP.CPTABL,DISP=SHR                             
//DPTABL   DD DSN=LIQUIDL.CSP.DPTABL,DISP=SHR                             
//MPTABL   DD DSN=LIQUIDL.CSP.MPTABL,DISP=SHR                             
//NPTABL   DD DSN=LIQUIDL.CSP.NPTABL,DISP=SHR                             
//INDPROD  DD DSN=LIQUIDL.ISPTLIB,DISP=SHR                               
//ISPTABL  DD DSN=LIQUIDL.PTABL,DISP=SHR                                 
//*- - ALLOCATE ISPF LOG DATA SET  - - - - - - - - - - - -*/             
//ISPLOG   DD DSN=LIQUIDL.PLI.ISPF.LOG,DISP=OLD                           
//*                                                                       
//*- - ALLOCATE DIALOG PROGRAM AND TSO COMMAND LIBRARIES -*/             
//ISPLLIB  DD DSN=LIQUIDL.PLI.LOAD,DISP=SHR                               
//SYSEXEC  DD DSN=LIQUIDL.PLI.LOAD,DISP=SHR                               
//SYSTSPRT DD DSN=LIQUIDL.PLI.SYSTSPRT,                                   
//            DISP=OLD                                                             
//SYSPRINT DD DSN=LIQUIDL.PLI.SYSPRINT,                                   
//            DISP=OLD                                       
//SYSTSIN  DD *                                               
  DSN SYSTEM(DSN)                                             
  RUN CP PLAN(CSPTABML)                                                                     
  ISPSTART PGM(CSPTABML)                                     
  END                                                         
//*


Hope it can help someone.
Thank you so much.
Pucca.
User avatar
pucca71
 
Posts: 19
Joined: Wed Sep 22, 2010 6:38 am
Has thanked: 0 time
Been thanked: 0 time
Top

Re: JCL to execute PL/I w ISPF tables & DB2 tables

Postby dick scherrer » Wed Nov 10, 2010 9:08 am

Good to hear it is working - thank you for posting your solution :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times
Top

Re: JCL to execute PL/I w ISPF tables & DB2 tables

Postby NicC » Thu Nov 11, 2010 5:12 pm

Nice one - saved!
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times
Top

Re: JCL to execute PL/I w ISPF tables & DB2 tables

Postby Akatsukami » Thu Nov 08, 2012 3:54 am

At the risk of catching flak for performing thread necromancy...
NicC wrote:1 - I do not ever recall seeing a combination of PL/1, ISPF and DB2. I have done Rexx, ISPF and DB2 but that was in foreground.

I'm updating such a program for our Compuware sunset project. It comprises over two dozen source modules and uses reverse-engineered File-AID selection criteria; the lead analyst for the MVS->E PL/I conversion missed it (I'm going to flick her on the ear for that when I catch up to her :D) and my first move was to run all the source modules through our current EPL/I compiler (V4.2.0). It's clabbered misery to work with.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times
Top

Re: JCL to execute PL/I w ISPF tables & DB2 tables

Postby dick scherrer » Fri Nov 09, 2012 12:53 am

When it sucks, it sucks.

No flak from here (an advantage of being a major contributor). . .

Maybe you can transfer ownership . . . 8-)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times
Top
Previous
Post a reply

Return to JCL

 


  • Related topics
    Replies
    Views
    Last post
Forum Rules|FAQ|Subscriptions|Bookmarks