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
 

 

about host and indicator variables in db2

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

New User


Joined: 31 May 2005
Posts: 5
Location: hyd

PostPosted: Wed Jun 01, 2005 7:28 pm    Post subject: about host and indicator variables in db2
Reply with quote

about host and indicator variables in db2
i req more information.
Back to top
View user's profile Send private message

sudheer648

New User


Joined: 23 May 2005
Posts: 97
Location: Chennai

PostPosted: Thu Jun 02, 2005 11:02 am    Post subject: Re: about host and indicator variables in db2
Reply with quote

Hi mkiranmai,

1.Host Variables are nothing but the collecting working storage collections of the data fetched from the tables in database.We use DCLGEN for Host Variable Language specific data type defintions of the database fields.

2.Null Indicator Variables are there to handle situation where we get some null data instead of data if such case how to handle is done thru this by using the value of the Null Indiacor values 0.-1.-2.

Tell me What else you want on this.

Hope this would help.
Back to top
View user's profile Send private message
jkbytes

Active User


Joined: 19 Feb 2005
Posts: 141
Location: South Africa

PostPosted: Thu Jun 02, 2005 2:22 pm    Post subject: Re: about host and indicator variables in db2
Reply with quote

Hi,

in the following code iam trying to retrieve the employee details in to some cobol structure called dclempanj which is called as the host variable structure.

Code:
EXEC SQL                                             
          SELECT EMPID,EFNAME,ELNAME,EMPDOB,EMPSAL,EMPDEPT
           INTO :DCLEMPANJ       
           FROM EMPANJ           
           WHERE EMPID = 'A0001'
      END-EXEC.                 



Code:
01  DCLEMPANJ.                                                   
      10 EMPID                PIC X(5).                           
      10 EFNAME               PIC X(15).                           
      10 ELNAME               PIC X(15).                           
      10 EMPDOB               PIC X(10).                           
      10 EMPSAL               PIC S9(5)V9(2) USAGE COMP-3.         
      10 EMPDEPT              PIC X(5).   


where this host structure can be created by means of dclgen.
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 Protection Exception while move 0 to ... Kevin Vaz CICS 10 Tue Oct 18, 2016 4:19 pm
No new posts Is it possible to pass variables of s... Csongor CLIST & REXX 2 Fri Jun 10, 2016 7:33 pm
No new posts PC to Host for unicode file Tom Steiner TSO/ISPF 5 Mon May 16, 2016 10:38 pm
No new posts Compare 2 files & write Indicator... nagendrapgupta SYNCSORT 5 Sun May 15, 2016 10:42 am
No new posts TWS 'global' or 'local' variables Steve Coalbran IBM Tools 2 Thu Mar 17, 2016 7:40 pm


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