Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DZIOVRLY (OGL Compiler) through a DB2 stored procedure

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Balaji Krishnamurthy

New User


Joined: 26 Feb 2008
Posts: 20
Location: chennai

PostPosted: Tue Apr 08, 2008 12:16 am    Post subject: DZIOVRLY (OGL Compiler) through a DB2 stored procedure
Reply with quote

Anyone tried executing DZIOVRLY (OGL Compiler) through a DB2 stored procedure?
Back to top
View user's profile Send private message

Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Wed Apr 09, 2008 11:47 am    Post subject:
Reply with quote

Seems to be strange requirement. Can you please elaborate your requirement.
Back to top
View user's profile Send private message
Balaji Krishnamurthy

New User


Joined: 26 Feb 2008
Posts: 20
Location: chennai

PostPosted: Sat Apr 12, 2008 3:51 am    Post subject: Reply to: DZIOVRLY (OGL Compiler) through a DB2 stored proce
Reply with quote

I have found the solution.. But i would like to share my knowledge about this. DZIOVRLY is a utility in IBM mainframes which compiles an Overlay Generation Language (OGL). I need to call this utility inside a DB2 stored procedure and this stored procedure is executed through a trigger. I was facing some issues in executing the utility which was resolved finally. I woud like to tell the resolution, but if you are not clear about whatever i had explained till now, then that would be much more confusing
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2150
Location: At my coffee table

PostPosted: Sat Apr 12, 2008 4:00 am    Post subject:
Reply with quote

Like Dick would say,
Welcome to the forums,
and thanks for the additional information......
Back to top
View user's profile Send private message
Balaji Krishnamurthy

New User


Joined: 26 Feb 2008
Posts: 20
Location: chennai

PostPosted: Thu Apr 17, 2008 2:25 am    Post subject:
Reply with quote

Now i am running up into a new issue in executing DZIOVRLY through a triggered Stored Procedure. Can anyone help me out in resolving this? I will specify the issue once i get a valid reply to this post.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Apr 17, 2008 4:32 am    Post subject:
Reply with quote

Hello,

Quote:
but if you are not clear about whatever i had explained till now
I expect that many people here are clear on what you posted.

Quote:
I woud like to tell the resolution
Please do. . .

Quote:
Now i am running up into a new issue in executing DZIOVRLY through a triggered Stored Procedure. Can anyone help me out in resolving this? I will specify the issue once i get a valid reply to this post.
I must say - that approach will get few usable replies. There are enough people who actually want answers that we will probably not try to drag your question onto the forum.

The way our forums works is that folks who have an issue (that would be you), post the issue and any information that will help clarify the issue. Those of us who believe they can contribute - well, we do.
Back to top
View user's profile Send private message
Balaji Krishnamurthy

New User


Joined: 26 Feb 2008
Posts: 20
Location: chennai

PostPosted: Thu Apr 17, 2008 8:21 pm    Post subject: Reply to: DZIOVRLY (OGL Compiler) through a DB2 stored proce
Reply with quote

Hi dick,

thanks for your suggestions. I feel this forum is of great use to me.

Let me tell the first issue i faced which is resolved now.

DZIOVRLY utility needs a SYSPRINT and SYSIN file for it. SYSIN file contains the OGL to be compiled and SYSPRINT will show the compilation errors. Since, the utility is called inside a triggered DB2 stored procedure, we were dynamically allocating these files. But, the utility thowed an error. Finally we sorted out that when the trigger is invoked, a job runs in the DB2 sub-system (which is obvious) and a SYSPRINT and SYSIN is allocated by DB2 system for this job. We de-allocated these files and allocated our files before calling the utility and the utility passed without any errors.

Now, the issue is, we are trying to re-allocate the files (previously allocated by DB2 system and de-allocated by us) in order to have things back in place. We do no have the authority to allocate a files with the DB2 system HLQ (SYSxxxxx). Issue with SYSPRINT file is fixed. The DB2 system will automatically allocated another temporary file whenever needed. But, SYSIN file issue is pending. Need some help on this.
Back to top
View user's profile Send private message
Balaji Krishnamurthy

New User


Joined: 26 Feb 2008
Posts: 20
Location: chennai

PostPosted: Fri Apr 18, 2008 2:26 am    Post subject: Reply to: dynamic copy from one dataset to other
Reply with quote

i use a trigger initiated DB2 stored procedure, which calls 5 sub-programs. One of the program requires a user defined SYSIN file. The DB2 system in-turn creates a SYSIN file for its job in the address space. Now, i have to dynamically allocated my files to SYSIN before calling this particular sub-program.

Once i de-allocate the DB2 allocated SYSIN files, they are lost and i am not able to re-allocate them after executing this sub-porogram. i am trying out some way to allocate my files to SYSIN without de-allocating the DB2 allocated files.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Is the 'prompt' data for the DSLIST p... Willy Jensen TSO/ISPF 2 Tue Dec 06, 2016 4:38 am
No new posts Regarding COBOL Stored Procedure opti... selvamsrinivasan85 DB2 4 Fri Nov 04, 2016 8:57 pm
No new posts Access SQLCA fields inside a stored p... gangapd DB2 4 Thu Oct 27, 2016 10:20 am
No new posts Any docs / links for isub- cobol comp... SRICOBSAS COBOL Programming 4 Fri Aug 26, 2016 2:35 pm
No new posts Problem Compiling cobol code with Cob... amitc23 COBOL Programming 2 Wed Aug 24, 2016 1:50 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us