MVSFORUMS.com

suma · Beginner Joined: 23 Jan 2006 Posts: 65 Topics: 29

Hi all,

I have query as shown below....

SELECT COUNT (*)
FROM TABLE1
WHERE COL1 = '123';

Does anybody know what will be SQLCODE for this query if COUNT = 3.
And when SQLCODE will be 0 for the above query...

Thanks
Suma

Nic Clouston · Posted: Fri Apr 13, 2007 6:52 am Post subject:

Is that using Spufi or in a program?
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

suma · Beginner Joined: 23 Jan 2006 Posts: 65 Topics: 29

I am using it in a COBOL program.....In SPUFI I am getting SQLCODE as 100

Nic Clouston · Posted: Fri Apr 13, 2007 6:54 am Post subject:

yes - in spufi you will get +100 but in your program you SHOULD get 000
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

Mickeyd · Beginner Joined: 02 Jan 2003 Posts: 27 Topics: 0

In COBOL for the count you will get a zero, you have to check the count field
in order to determine if you have any data that matched your count query.