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
 

 

Inserting data to a table from subprogram

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

New User


Joined: 23 May 2005
Posts: 19

PostPosted: Mon Nov 28, 2005 3:52 pm    Post subject: Inserting data to a table from subprogram
Reply with quote

hi all

i got a main pgm where iam creating a table and after that i am calling statically subprogram where iam inserting the value for that table .what are the changes that i should make in precompiler and bind. pl explain the process. thank u
Back to top
View user's profile Send private message

sbalajibe

New User


Joined: 15 Aug 2005
Posts: 62

PostPosted: Mon Nov 28, 2005 5:21 pm    Post subject:
Reply with quote

Hi sunish,

in this case both the program has to be precompiled and binded as both the programs contain SQl statements
then u have to link edit

please correct me if i am wrong
Back to top
View user's profile Send private message
sunish

New User


Joined: 23 May 2005
Posts: 19

PostPosted: Mon Nov 28, 2005 7:28 pm    Post subject: Re: db2 - subprogram
Reply with quote

thank u . thus we first precompiler subpgm then bind sub pgm and precompile of mian pgm and bind main pgm. where will we give the lked.syslib of the sub pgm when we precompile the main pgm
Back to top
View user's profile Send private message
sunish

New User


Joined: 23 May 2005
Posts: 19

PostPosted: Tue Nov 29, 2005 9:48 am    Post subject: Re: Inserting data to a table from subprogram
Reply with quote

hi tell me how to do it . when i precompile the main pgm it is giving cannot include the subpgm. help me
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Tue Nov 29, 2005 2:17 pm    Post subject: Subprogram
Reply with quote

hi frnd,
Quote:
when i precompile the main pgm it is giving cannot include the subpgm?

so check whether u had choosen the binding and the precompilation of the subprogram is No Error.. and have u used any parameter passing in the linkage section then check that u had made it clear or not? and one more thing is check that whether u had used the call statement in properly?

plz check these above posibilities and let me know...
Back to top
View user's profile Send private message
sunish

New User


Joined: 23 May 2005
Posts: 19

PostPosted: Wed Nov 30, 2005 11:30 am    Post subject: Re: Inserting data to a table from subprogram
Reply with quote

hi

i checked i did precompilation for subpgm where iam inserting the values for the table which i cerated in the main pgm it is fine , aft that i did bind for subpgm it is giving abend s322.

i am not passing any values to subpgm. and i am calling it statically.
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Wed Nov 30, 2005 11:35 am    Post subject: subprogram data
Reply with quote

Hi frnd,
so the cause of the error is
Quote:
'when CPU time assigned to the job, job step or procedure has been exceeded'



and ur JOB OR STEP TIME EXCEEDED THE SPECIFIED LIMIT PROGRAM IS IN A LOOP INSUFFICIENT TIME PARAMETER ON JOB OR EXEC CARD

so these are the two posibilities.. check it out...

if not then plz send the code.. i think it will be the final way...
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 Data replication from multiple Db2 ta... kishpra DB2 1 Mon Mar 27, 2017 9:58 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts Overriding PS data in rexx Shaheen Shaik CLIST & REXX 8 Fri Mar 03, 2017 5:08 pm


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