IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need help MF Stored procedure and tablebase


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Sureet Mookherjee

New User


Joined: 08 May 2009
Posts: 19
Location: India

PostPosted: Tue Aug 11, 2009 12:52 pm
Reply with quote

In my Mainframe project, We have created a new DB2 Stored Procedure (SP), which will be invoked online from VBA (Visual Basic Application).

We have designed this SP to access the table base as well as the DB2 tables. We have below queries as we are getting -430 or -471 while executing this SP.

1. Is it possible to have DB2 concept along with Table base concept?
2. If yes, then how the table base is invoked in online flow?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Aug 11, 2009 1:07 pm
Reply with quote

?? Table base concept? sorry, I am just a dumb old IBM programmer, not sure what you mean by 'Table base'.

-471 is rather detailed (gives a reason code). Basically your SP has some problems.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Tue Aug 11, 2009 7:09 pm
Reply with quote

Quote:
Is it possible to have DB2 concept along with Table base concept?

the issue should have been debated and planned at requirement setting and software procurement time (*)

(*) in plain words when Your employer bought/did_spend_money on the software
somebody should have already known what to do/what could be done with it
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Tue Aug 11, 2009 9:40 pm
Reply with quote

Sureet Mookherjee wrote:
We have designed this SP to access the table base as well as the DB2 tables.
I'm not very sure if I got the meaning of bold text in above quote. icon_neutral.gif
Quote:
1. Is it possible to have DB2 concept along with Table base concept?
Dick is an old(polished) programmer and 'am a new one -- but sorry I also dont' know about this"Table Base concept"?
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Tue Aug 11, 2009 9:41 pm
Reply with quote

oh, did you mean "tableBASE" -- a third-party vendor product owned and maintained by Data Kinetics Ltd.?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Invoke stored procedure via batch JCL. DB2 2
No new posts Calling COBOL DB2 program from a COBO... COBOL Programming 2
No new posts Cond parameter and Rc code of a proce... JCL & VSAM 5
This topic is locked: you cannot edit posts or make replies. Internal Autonomous Stored Procedure ... DB2 6
No new posts Stored procedure cpu utilization DB2 1
Search our Forums:

Back to Top