Simple SQLJ program ....

[Raquel]

A very simple piece of SQLJ:

try
{
#sql [sqlj4context] sqlj4_iterator = {SELECT PHONENO FROM
DB2ADM.EMPLOYEE WHERE WORKDEPT = 'D11'};

while(sqlj4_iterator.next())
{
System.out.println(sqlj4_iterator.phoneno());
if (sqlj4_iterator.phoneno() == "2890")
{
System.out.println("YES!!");
}
}
sqlj4_iterator.close();
#sql [sqlj4context] {COMMIT};
sqlj4context.close();
} catch (SQLException sqlexcp)

The output generated is:

6423
4510
3782
2890
1682
2986
4501
0942
0672

Why is "YES" not produced in the output when phone no. 2890 appears in
the output? PHONENO is defined as CHAR(4) in the table.

TIA
Raquel.

[Rhino]

"Raquel" <ra****************@yahoo.com> wrote in message
news:9a**************************@posting.google.c om...

A very simple piece of SQLJ:

try
{
#sql [sqlj4context] sqlj4_iterator = {SELECT PHONENO FROM
DB2ADM.EMPLOYEE WHERE WORKDEPT = 'D11'};

while(sqlj4_iterator.next())
{
System.out.println(sqlj4_iterator.phoneno());
if (sqlj4_iterator.phoneno() == "2890")
{
System.out.println("YES!!");
}
}
sqlj4_iterator.close();
#sql [sqlj4context] {COMMIT};
sqlj4context.close();
} catch (SQLException sqlexcp)

The output generated is:

6423
4510
3782
2890
1682
2986
4501
0942
0672

Why is "YES" not produced in the output when phone no. 2890 appears in
the output? PHONENO is defined as CHAR(4) in the table.

Stored Procedures run in a background process so they cannot do screen
writes. If you want to get diagnostics of this kind, you will have to write
them to a file. You don't need anything fancy; a simple flat file written to
your file system is all you need.

Rhino

[Raquel]

Hi Rhino, this is not a stored procdure. A simple SQLJ program. As I
mentioned in the original mail, all the phone nos. are correctly
getting displayed on the screen....then why not 'YES' !!!

Thanks.
Raquel.

[Rhino]

"Raquel" <ra****************@yahoo.com> wrote in message
news:9a**************************@posting.google.c om...

Hi Rhino, this is not a stored procdure. A simple SQLJ program. As I
mentioned in the original mail, all the phone nos. are correctly
getting displayed on the screen....then why not 'YES' !!!

Oops, sorry, I just assumed it was a stored procedure because of the stored
procedures problems you had earlier.

Your problem this time is your use of the '==' operator. The correct way to
tell if a String is equal to a given value is the equals() method of the
String class. Instead of this:

if (sqlj4_iterator.phoneno() == "2890")

you should have:

if (sqlj4_iterator.phoneno().equals("2890"))

The '==' operator is fine for numbers that are stored in Java primitives
like short, int, long, float, and double but it is NOT appropriate for
Strings. Make the change I suggested and your problem should go away.

Rhino

[Raquel]

Very correct Rhino. That indeed was the problem.

Thanks
Raquel.