RE: QRY variable

[Al Barsa <barsa@xxxxxxxxxxxxxxxxxxx>]

I have used DBU in the past, and I remember that there was a way to do
this.  Why don't you call PRODATA for support?

Al

Al Barsa, Jr.
Barsa Consulting Group, LLC

400>390

"i" comes before "p", "x" and "z"
e gads

Our system's had more names than Elizabeth Taylor!

914-251-1234
914-251-9406 fax

http://www.barsaconsulting.com
http://www.taatool.com
http://www.as400connection.com



                                                                           
             "Chaudhary,                                                   
             Sachin \(GE                                                   
             Equipment                                                  To 
             Services,                 "Midrange Systems Technical         
             Consultant\)"             Discussion"                         
             <sachin.chaudhary         <midrange-l@xxxxxxxxxxxx>           
             @ge.com>                                                   cc 
             Sent by:                  replysachin@xxxxxxxxxxx             
             midrange-l-bounce                                     Subject 
             s@xxxxxxxxxxxx            RE: QRY variable                    
                                                                           
                                                                           
             12/22/2004 04:36                                              
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




I am using DBU to update data in AS400.
By default it takes input for Alphanumeric characters in upper case. How
can we update/add data in lower case?

-----Original Message-----
From: midrange-l-bounces+sachin.chaudhary=ge.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+sachin.chaudhary=ge.com@xxxxxxxxxxxx]On
Behalf Of Steve Landess
Sent: Wednesday, December 22, 2004 3:18 PM
To: Midrange Systems Technical Discussion
Cc: jdraper@xxxxxxxxxxxxx
Subject: Re: QRY variable


> Jerry Draper wrote:
> Subject: QRY variable
> I have a *QRYDFN that is run using the Robot scheduler system.  A record
> selection parameter (fiscal period) must be changed once a month.  Is
there an
> easy way to do this programatically?

Jerry-
You can pass a variable to AS/400 Query in similar fashion to that used
in Query Management.

See http://faq.midrange.com/data/cache/106.html

Steve Landess
Austin, Texas
(512) 423-0935
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.