Getting SQL code 100

dilpreet · New User Joined: 18 Mar 2008 Posts: 34 Location: INDIA

SELECT COURSE_PACKAGE_ID
INTO :COURSE-PACKAGE-MASTER-TABLE.COURSE-PACKAGE-ID
FROM COURSE_PACKAGE_MASTER
WHERE COURSE_PACKAGE_ID = 'AXIOM11'
AND COURSE_PACKAGE_EXPIRATION_DATE IS NOT NULL
AND (COURSE_PACKAGE_EXPIRATION_DATE = :CURRENT-DATE-IN
OR COURSE_PACKAGE_EXPIRATION_DATE < :CURRENT-DATE-IN)

I am executing this query in SPUFI where it returns a row successfully with SQLCODE = 0
The same query when run in cobolDB2 program gives sqlcode = 100

Field declaration in Table is
COURSE_PACKAGE_ID VARCHAR X(20)
COURSE_PACKAGE_EXPIRATION_DATE nullable date field

Please suggest your views

Bill Woodger · Posted: Tue Mar 12, 2013 2:04 pm

Have your researches uncovered what a "100" means?

chandan.inst · Posted: Tue Mar 12, 2013 2:07 pm

Check population of your host variables in CObol program..

Just Put some display statements to check if your query getting correct values as input to the query

Regards,
Chandan

dilpreet · New User Joined: 18 Mar 2008 Posts: 34 Location: INDIA

I have debugged the program and values are populating correctly.Is there anything that Nullable date field cannot be compared . I may be missing something here

chandan.inst · Posted: Tue Mar 12, 2013 2:58 pm

Can you please provide your spufi details as well as debugging snapshot?
So that we will also get clear idea how is it working at spufi and Cobol

dilpreet · New User Joined: 18 Mar 2008 Posts: 34 Location: INDIA

Can anyone confirm the date field that is defined as NULLABLE COLUMN as YES . Can this field be used in where clause for comparing with dates.

chandan.inst · Posted: Tue Mar 12, 2013 3:44 pm

If Host variable populated correctly then Yes..