View previous topic :: View next topic
|
Author |
Message |
megha.bargaje
New User
Joined: 01 Aug 2006 Posts: 3 Location: pune
|
|
|
|
wat is indicator variable????
WARNING: TITLE EDITED |
|
Back to top |
|
|
sri_mf
Active User
Joined: 31 Aug 2006 Posts: 218 Location: India
|
|
|
|
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 |
|
|
ssenthil_kumar19 Currently Banned New User
Joined: 02 May 2006 Posts: 2
|
|
|
|
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 |
|
|
|