Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
UNDEFINED or UNUSABLE HOST VARIABLE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
parag manilal chheda

New User


Joined: 02 Oct 2008
Posts: 2
Location: mumbai

PostPosted: Thu Oct 02, 2008 1:17 pm    Post subject: UNDEFINED or UNUSABLE HOST VARIABLE
Reply with quote

hi

i m getting the error DSNH3121 SAYING "UNDEFINED OR UNUSABLE HOST VARIABLE".

THE VARIABLE NAMES AND THE DATA TYPES ARE SAME IN THE PROGRAM & DECLGEN FILE.

CAN ANYBODY TELL WHAT IS THE PROBLEM.

THANKYOU.
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


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

PostPosted: Thu Oct 02, 2008 1:31 pm    Post subject:
Reply with quote

look at your precompiler listing.
If the copybook that contains the host variables has been expanded (via an SQL INCLUDE),
and you can find them in the listing,
  1. you have either bad host variable definitions- data types are non-compatible
  2. you did not use the :HOST-VAR syntax. that is colon - : - host variable reference
Back to top
View user's profile Send private message
parag manilal chheda

New User


Joined: 02 Oct 2008
Posts: 2
Location: mumbai

PostPosted: Thu Oct 02, 2008 1:43 pm    Post subject:
Reply with quote

I haven't used the copybook, & the data types are also compatible.
The error coming is " An EXEC SQL INCLUDE stmt was found but SQL compiler was not in effect"
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 Oct 02, 2008 8:15 pm    Post subject:
Reply with quote

Hello,

You need to check with you dba or whoever supports the standard compile/link jcl. It sounds like you may be using the wrong jcl and they can tell you which jcl you should use.

When you post error information, you should post more completely and make sure you include the message id that came with the message text.
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 -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Moving values to a variable of copybo... Vignesh Sid COBOL Programming 6 Wed Sep 06, 2017 1:04 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Move from Comp3 variable to Edited Va... sreekusr COBOL Programming 8 Thu Aug 10, 2017 4:20 pm
No new posts Can I traverse a STEM variable? chong.zhou CLIST & REXX 5 Wed May 31, 2017 3:54 pm
No new posts Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us