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

How to Solve -927 SQLCODE in a cobol-DB2 program


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

New User


Joined: 09 Jul 2009
Posts: 2
Location: Bangalore

PostPosted: Thu Jul 09, 2009 9:52 am
Reply with quote

Hi,

I am getting -927 SQL code when I am trying to update a DB2 table.
When I did a QW on the SQLcode,It says a proper connection has not been established.
Please suggest.

Regards,
Rups
Back to top
View user's profile Send private message
radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 435
Location: chennai, India

PostPosted: Thu Jul 09, 2009 10:11 am
Reply with quote

Pls check your link edit listing and run-time JCL. DB2 application programs should be invoked under the RUN subcommand of the DSN command processor in tso.

Try using NODYNAM option in compilation, if you are currently using DYNAM.

Hope this helps.
Back to top
View user's profile Send private message
radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 435
Location: chennai, India

PostPosted: Thu Jul 09, 2009 10:14 am
Reply with quote

how the program was invoked? Is it batch of foreground?
check for messages whether it shows that they should run under DSN interface. --- DSN RUN PROGRAM() in SYSTIN and EXEC pgm shud be IKJEFT01.

Hope this helps.
Back to top
View user's profile Send private message
rupsb01

New User


Joined: 09 Jul 2009
Posts: 2
Location: Bangalore

PostPosted: Thu Jul 09, 2009 1:37 pm
Reply with quote

Thanx a zillion radhakrishnan it worked!!!!!!!!!
I had not used IKJEFT icon_redface.gif
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 Replace each space in cobol string wi... COBOL Programming 3
No new posts Using API Gateway from CICS program CICS 0
No new posts COBOL -Linkage Section-Case Sensitive COBOL Programming 1
No new posts COBOL ZOS Web Enablement Toolkit HTTP... COBOL Programming 0
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
Search our Forums:

Back to Top