how to execute join query in cobol programming

sahanawaj · New User Joined: 04 Dec 2007 Posts: 2 Location: Mumbai

Hi
i have written a cobol programming which is given below

EXEC SQL
SELECT C_INT_ISIN
,C_ITD_NINTRPDT
,C_ITD_RDDT
,C_INT_INSSTTS
,C_ITD_SHUTIND
,C_INT_INSTYPID
INTO :C-INT-ISIN
,:C-ITD-NINTRPDT
,:C-ITD-RDDT
,:C-INT-INSSTTS
,:C-ITD-SHUTIND
,:C-INT-INSTYPID
FROM CS_INSTRU_T , CS_INSTRUDETLS_T
WHERE .C_INT_INSTRUID = C_ITD_INSTRUID
AND C_INT_INSTRUID = :WS-ACP-INSTRUID
END-EXEC.

But during executing that program,it is giving sqlcode =00030N

Please can any body help me whats wrong with this query

Hi! This is your First post in our Forums! So please be sure to 1) Use meaningful and descriptive Topic Title 2) Try to post your query in the relevant forum category 3) Make sure your query is not already posted and solved in our forums, Use the Search facility and avoid Reposts! If you are following the above rules, delete this message and post your query here!

ulfnsc · Posted: Fri Dec 07, 2007 4:52 pm

Hi sahanawaj
-305....
Check your return code, it will tell you what output host variable
need to have a indicator variable.

rpuhlman · Posted: Fri Dec 07, 2007 5:09 pm

Move SQLCODE to a working storage field, such as

dick scherrer · Posted: Fri Dec 07, 2007 9:46 pm

Hello,

If there could be more than 1 "details" row per INSTRU row, you will need to use a CURSOR.

sahanawaj · New User Joined: 04 Dec 2007 Posts: 2 Location: Mumbai

dr_te_z · Posted: Tue Dec 11, 2007 4:37 pm

Are there any columns with NULLS allowed?