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
 

 

What is indicator variable

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
megha.bargaje

New User


Joined: 01 Aug 2006
Posts: 3
Location: pune

PostPosted: Thu Aug 31, 2006 5:43 pm    Post subject: What is indicator variable
Reply with quote

wat is indicator variable????

WARNING: TITLE EDITED
Back to top
View user's profile Send private message

sri_mf

Active User


Joined: 31 Aug 2006
Posts: 216
Location: India

PostPosted: Fri Sep 01, 2006 2:20 pm    Post subject: Re: What is indicator variable
Reply with quote

megha.bargaje wrote:
wat is indicator variable????

WARNING: TITLE EDITED



hi megagha,

is ur question abt null indicator if so

Null indicator is used to specify whether the value in a db2 column is null or not

Null indicator = 0 not null
-1 null value
-2 trunctated(not sure of this)


correct me if i m wrong
Back to top
View user's profile Send private message
ssenthil_kumar19
Currently Banned

New User


Joined: 02 May 2006
Posts: 2

PostPosted: Fri Sep 01, 2006 2:58 pm    Post subject: Re: What is indicator variable
Reply with quote

IDENTIFICATION DIVISION.
PROGRAM-ID. INDICAT.
DATA DIVISION.
WORKING-STORAGE SECTION.
01 A PIC S9(4) SIGN LEADING SEPARATE.
EXEC SQL
INCLUDE SENTHIL
END-EXEC.
EXEC SQL
INCLUDE SQLCA
END-EXEC.
PROCEDURE DIVISION.
EXEC SQL
SELECT *
INTO :DCLSENTHIL :INDSTRUC
FROM SENTHIL
WHERE FIRSTNAME = 'SENTHIL'
END-EXEC.
IF INDSTRUC(3) < 0
MOVE INDSTRUC(3) TO A.
DISPLAY A.
STOP RUN.

NOTE:

SENTHIL----> TABLE NAME
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Writing on to GSAM variable length rohanthengal JCL & VSAM 6 Fri Mar 03, 2017 7:46 pm
No new posts Count Trailing Spaces in variable str... Virendra Shambharkar SYNCSORT 10 Thu Feb 02, 2017 12:23 pm


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