RE: Resultset has junk value when called from java

Hi
I just changed my SQL statement, before changing i use
to get the data in local variable in RPG subroutine
and then in my sql do variable substitution, 
instead of that i modified my sql and added a left
join to get the data in sql rather then getting it in
local variable and then substiuting in sql statement


ashish

--- Andrew Papada <PapadaA@xxxxxxxxxxxxxxx> wrote:

> Just curious, what was it that you changed in the
> SQL statement?  Are
> you using a callable statement?  I've done a lot of
> work where I connect
> to an AS/400 for data so I may be able to help you
> with this.  
> 
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Ashish Kulkarni
> Sent: Wednesday, July 20, 2005 2:06 PM
> To: Java Programming on and around the iSeries /
> AS400
> Subject: RE: Resultset has junk value when called
> from java
> 
> No
> I did not had time stamp, i was able to solve the
> problem by changing the sql statment
> 
> very weird 
> 
> Ashish
> 
> --- albartell <albartell@xxxxxxxxx> wrote:
> 
> > Do you happen to have timestamps in the result
> set? 
> > 
> > 
> > Aaron Bartell 
> > 
> > -----Original Message-----
> > From:
> > java400-l-bounces+albartell=gmail.com@xxxxxxxxxxxx
> >
>
[mailto:java400-l-bounces+albartell=gmail.com@xxxxxxxxxxxx]
> > On Behalf Of
> > Ashish Kulkarni
> > Sent: Wednesday, July 20, 2005 9:15 AM
> > To: java400-l@xxxxxxxxxxxx
> > Subject: Resultset has junk value when called from
> > java
> > 
> > Hi
> > I have a stored procedure written in SQLRPGLE,
> There
> > is a java program which
> > calls this stored procedure  to get data, I am
> > facing a very weird problem,
> > when i call this stored procedure from java
> running
> > on windows, it works
> > just fine i get good data, use (AS400JDBCDriver)
> but
> > when i call this stored
> > procedure with java running on AS400 (using native
> > driver) i get junk in
> > only one field from the stored procedure
> > 
> > how do i start to resolve this issue
> > 
> > Ashish
> >  
> > 
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam
> > protection around
> > http://mail.yahoo.com
> > --
> > This is the Java Programming on and around the
> > iSeries / AS400 (JAVA400-L)
> > mailing list To post a message email:
> > JAVA400-L@xxxxxxxxxxxx To subscribe,
> > unsubscribe, or change list options,
> > visit:
> >
> http://lists.midrange.com/mailman/listinfo/java400-l
> > or email: JAVA400-L-request@xxxxxxxxxxxx Before
> > posting, please take a
> > moment to review the archives at
> > http://archive.midrange.com/java400-l.
> > 
> > -- 
> > This is the Java Programming on and around the
> > iSeries / AS400 (JAVA400-L) mailing list
> > To post a message email: JAVA400-L@xxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit:
> >
> http://lists.midrange.com/mailman/listinfo/java400-l
> > or email: JAVA400-L-request@xxxxxxxxxxxx
> > Before posting, please take a moment to review the
> > archives
> > at http://archive.midrange.com/java400-l.
> > 
> > 
> 
> 
> 
>               
> ____________________________________________________
> Start your day with Yahoo! - make it your home page 
> http://www.yahoo.com/r/hs 
>  
> -- 
> This is the Java Programming on and around the
> iSeries / AS400
> (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 
> -- 
> This is the Java Programming on and around the
> iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
> http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/java400-l.
> 
> 



                
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs