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

Inserting data to a table from subprogram


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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
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: 677
Location: NJ

PostPosted: Tue Nov 29, 2005 2:17 pm
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
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: 677
Location: NJ

PostPosted: Wed Nov 30, 2005 11:35 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Store the data for fixed length COBOL Programming 1
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
Search our Forums:

Back to Top