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
 
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: 215
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 Moving a COMP-3 Variable to a Numeric... ajayachander COBOL Programming 1 Thu Dec 14, 2017 5:46 pm
No new posts Move from Comp3 variable to Edited Va... Revathy.nair0485 COBOL Programming 7 Fri Nov 03, 2017 3:30 pm
This topic is locked: you cannot edit posts or make replies. Can a alphanumeric data be moved to a... nico_neoz COBOL Programming 10 Mon Oct 30, 2017 8:28 am
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

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