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
 

 

how to referance null indicator value

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

New User


Joined: 29 Aug 2007
Posts: 2
Location: bangalore

PostPosted: Mon Dec 31, 2007 2:54 pm    Post subject: how to referance null indicator value
Reply with quote

hi all,
i am using following query.

EXEC SQL
DECLARE ACCOUNT_CURS CURSOR FOR
SELECT A.ACCOUNT_NO
,A.BANK_NO
,A.PRODUCT_C
,A.SUBPRODUCT_C
,A.OPEN_DA
,A.DOWNLOAD_DA
,A.OD_DA
,A.OD_LIMIT_A
,A.FOLLOWUP_DA
,A.CLOSE_DA
,A.ACTUAL_CLOSE_DA
,A.END_DA
.
.skipping middle data
.
FROM DQG1.ORB00HQ.ACCOUNT A
LEFT OUTER JOIN
DQG1.ORB00HQ.AGENCY_COLLECTION BA ON
A.BANK_NO = BA.BANK_NO AND
A.ACCOUNT_NO = BA.ACCOUNT_NO AND
A.PRODUCT_C = BA.PRODUCT_C
LEFT OUTER JOIN
DQG1.ORB00HQ.PAYMENT_RCPT DA ON
A.BANK_NO = DA.BANK_NO AND
A.ACCOUNT_NO = DA.ACCOUNT_NO AND
A.PRODUCT_C = DA.PRODUCT_C
LEFT OUTER JOIN
DQG1.ORB00HQ.TRAIN AE ON
A.BANK_NO = AE.BANK_NO AND
A.ACCOUNT_NO = AE.ACCOUNT_NO AND
A.PRODUCT_C = AE.PRODUCT_C
WHERE A.STATUS_C IN ('END', 'ENP')
WITH URI

here primary key is account no....
base table is ACCOUNT table
problem is here some account no are not present in other tables so when it start writing fetch data for other three table tables it gives SAC7 error.
so what i did i compare one the null indicator value from each of these AGENCY_COLLECTION
PAYMENT_RCPT
Turntable = zero then program went fine but it did written a single record for other three tables (AGENCY_COLLECTION
PAYMENT_RCPT
TRAIN)

Can anybody can help me with this
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10244
Location: italy

PostPosted: Mon Dec 31, 2007 4:19 pm    Post subject: Reply to: how to referance null indicator value
Reply with quote

SAC7

That' s a system abend...
so apart fixing the fetch algorithm, I would also check the corrcteness of the program

SAC7 is quite a nasty abend, so I would thoroughly check with Your system support group

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IEA1H731/2.539?SHELF=EZ2MO901&DT=20000407064116&CASE=
Back to top
View user's profile Send private message
agarwalritesh11

New User


Joined: 29 Aug 2007
Posts: 2
Location: bangalore

PostPosted: Mon Dec 31, 2007 5:57 pm    Post subject:
Reply with quote

sorry error is SOC7
bymistake i have written sac7
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 VALIDATE NULL VALUE IN DB2 CASE STATE... useit DB2 5 Thu Feb 09, 2017 4:34 pm
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am
No new posts Converting NULL column into NOT NULL ... Raghu navaikulam DB2 5 Sat Aug 06, 2016 3:45 pm
No new posts Compare 2 files & write Indicator... nagendrapgupta SYNCSORT 5 Sun May 15, 2016 10:42 am
No new posts GetObjectArrayElement returns NULL Majid Hussain Java & MQSeries 2 Wed Mar 30, 2016 2:59 am


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