RE: Embedded SQL problem

Dwight,

If you want to retain SearchValue as a fixed length character field length
35, and you want to "like" with a value that is less than this in
significant characters, eg 10-1015%, then SearchValue should contain:
10-1015%%%%%%%%%%%%%%%%%%%%%%%%%%%%
(a total of 28 trailing percentage symbols)

HTH,

Kevin Wright.

> -----Original Message-----
> From: dslessman@nationalelectrical.com
> [mailto:dslessman@nationalelectrical.com]
> Sent: Tuesday, 6 March 2001 14:08
> To: RPG400-L@midrange.com
> Subject: RE: Embedded SQL problem
> 
> 
> 
> Kevin,
> 
> I thought character fields would need single quotes around them.
> 
> SearchValue is defined as a fixed length character field 
> (length of 35).
> 
> Do I need additional percentage symbols?
> 
> Thanks,
> 
> Dwight
> 
> 
>                                                               
>                                                     
>                     Kevin Wright                              
>                                                     
>                     <Kevin.Wright@lan        To:     
> RPG400-L@midrange.com                                        
>                     sa.com.au>               cc:              
>                                                     
>                     Sent by:                 Subject:     RE: 
> Embedded SQL problem                                
>                     owner-rpg400-l@mi                         
>                                                     
>                     drange.com                                
>                                                     
>                                                               
>                                                     
>                                                               
>                                                     
>                     03/05/2001 07:08                          
>                                                     
>                     PM                                        
>                                                     
>                     Please respond to                         
>                                                     
>                     RPG400-L                                  
>                                                     
>                                                               
>                                                     
>                                                               
>                                                     
> 
> 
> 
> 1) SearchValue does not need the quotes wrapping it, to the best of my
> knowledge
> 2) How is SearchValue defined? If it is fixed length, either make it
> variable length or add trailing percentage symbols beyond the 
> "significant
> characters".
> 
> HTH,
> 
> Kevin Wright
> 
> > -----Original Message-----
> > From: dslessman@nationalelectrical.com
> > [mailto:dslessman@nationalelectrical.com]
> > Sent: Tuesday, 6 March 2001 9:05
> > To: RPG400-L@midrange.com
> > Subject: Embedded SQL problem
> >
> >
> > I am having the following problem in an RPGLE program.  I
> > cannot get the
> > system to properly perform the selection using the "Like"
> > keyword and a
> > variable.
> >
> > Here is some sample code that works:
> > C/Exec Sql
> > C+  Declare GetAltNam Cursor For
> > C+    Select ITEMCBS,
> > C+           THCKCBS,
> > C+           WDTHCBS,
> > C+           LNGTCBS,
> > C+           GRADCBS
> > C+      From ALTNAM,
> > C+           BRSHSPC
> > C+      Where ITEMCBS = ITEMAN And
> > C+            NAMEAN Like '10-1015%'
> > C+      Order By ITEMCBS
> > C/End-Exec
> >
> > This search works great.
> >
> > Obviously I do not want to hardcode the search criteria.
> > When I add the
> > following, the application should return the same information
> > as above but
> > it does not.
> > C                   Eval      SearchValue = '10-1015%'
> > C                   Eval      SearchValueH = SearchValue
> > C                   Eval      SearchValue = '''' +
> > %Trim(SearchValueH)+
> > C                             ''''
> >  *  Declare cursors.
> > C/Exec Sql
> > C+  Declare GetAltNam Cursor For
> > C+    Select ITEMCBS,
> > C+           THCKCBS,
> > C+           WDTHCBS,
> > C+           LNGTCBS,
> > C+           GRADCBS
> > C+      From ALTNAM,
> > C+           BRSHSPC
> > C+      Where ITEMCBS = ITEMAN And
> > C+            NAMEAN Like :SearchValue
> > C+      Order By ITEMCBS
> > C/End-Exec
> >
> > I added a variable (I will later pass this as a parameter).
> > I put code in
> > to place single quotes around the search value.  Nothing is
> > returned in the
> > result and I receive no error messages.
> >
> > Does someone see the mistake I am making?
> >
> > Thanks in advance for your help,
> >
> > Dwight Slessman
> >
> > ps.  We are at V4R5 with database group PTF 4 on.
> >
> >
> > +---
> > | This is the RPG/400 Mailing List!
> > | To submit a new message, send your mail to RPG400-L@midrange.com.
> > | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> > | To unsubscribe from this list send email to
> > RPG400-L-UNSUB@midrange.com.
> > | Questions should be directed to the list owner/operator:
> > david@midrange.com
> > +---
> >
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
> 
> 
> 
> 
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to 
> RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: 
> david@midrange.com
> +---
> 
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---