Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

Vulcans never bluff. -- Spock, "The Doomsday Machine", stardate 4202.1


computers / comp.sys.ibm.as400.misc / Re: how can convert string to numeric with Query/400

SubjectAuthor
o Re: how can convert string to numeric with Query/400Tom Black

1
Re: how can convert string to numeric with Query/400

<18a416bf-d934-40a5-a95d-3e752dc63854n@googlegroups.com>

 copy mid

https://www.novabbs.com/computers/article-flat.php?id=18&group=comp.sys.ibm.as400.misc#18

 copy link   Newsgroups: comp.sys.ibm.as400.misc
X-Received: by 2002:ac8:411d:: with SMTP id q29mr21647684qtl.46.1633455625464;
Tue, 05 Oct 2021 10:40:25 -0700 (PDT)
X-Received: by 2002:a37:43c6:: with SMTP id q189mr15925855qka.315.1633455625202;
Tue, 05 Oct 2021 10:40:25 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!news.misty.com!border2.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.sys.ibm.as400.misc
Date: Tue, 5 Oct 2021 10:40:25 -0700 (PDT)
In-Reply-To: <k56urs$s3h$1@speranza.aioe.org>
Injection-Info: google-groups.googlegroups.com; posting-host=50.237.52.250; posting-account=1UGAOgoAAABiRU6WsXseUc3MF0cBz3dQ
NNTP-Posting-Host: 50.237.52.250
References: <37bd6347@news.marun.edu.tr> <37bdb3fc@199.186.16.51>
<0e900ec9-7308-488d-9fbb-b10ea6f66a89@googlegroups.com> <k56urs$s3h$1@speranza.aioe.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <18a416bf-d934-40a5-a95d-3e752dc63854n@googlegroups.com>
Subject: Re: how can convert string to numeric with Query/400
From: tjblac...@gmail.com (Tom Black)
Injection-Date: Tue, 05 Oct 2021 17:40:25 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Lines: 57
 by: Tom Black - Tue, 5 Oct 2021 17:40 UTC

On Thursday, October 11, 2012 at 12:15:43 PM UTC-5, CRPence wrote:
> On 25 Sep 2012 08:58, tun...@gmail.com wrote:
> >> On Friday, August 20, 1999 3:00:00 AM UTC-4, Kevin Buckley wrote:
> >>> There is a way to do it
> >>> <<SNIP daft but functional though limited conversion ref\xmp>>
> >>>
> >> Ufuk Ă–zdemir<uf...@singer.com.tr> wrote in message
> >>
> >> How can convert string to numeric with Query/400?
> >> I want to convert string value to numeric value is it possible
> >> with query/400 like DIGITS operator or other is it possible
> >
> > This is not an answer for the question, but I wanted to share my
> > comment on this. How can IBM become a worldwide leader while not
> > providing such a simple conversion function to its users? It is a
> > piece of toy for even the most simple development tools since 20-30
> > years ago. Isn't it strange for you too? IBM never deserved to be a
> > world leader with its software solutions. Very primitive tools.
> > Excuse me IBM, I am earning my life thanks to my AS/400 skills but,
> > you should make this job easier for your customers.
> The NewsServer I use never had the original message nor the 20-Aug
> reply, so I will reply to this message.
>
> Not strange to me at all. The Query/400 was designed to replace the
> Query/36; a carryover until various SQL tooling could replace the simple
> report writer and mail\merge features provided by the Query/400. The QM
> Query facility [STRQM CL command] is tooling for SQL [including query
> reporting] that can replace most usages of the Query/400. Use of the
> Query/400 tooling had long been deprecated; at least since the
> availability of QMQRY for which RTVQMQRY and STRQMQRY CL commands [both
> with ALWQRYDFN(*ONLY), and the ANZQRY CL command] were made available
> over 20 years ago to assist a transition to locally stored [not
> client-based; e.g. via ODBC] SQL queries. A *QMQRY object could be
> created to perform the request the OP expressed as desired effect.
>
> However note that an SQL VIEW has long been able to effect the
> requested conversion [asked of in the original message], and the
> Query/400 query definition has always been able reference [to query] an
> SQL VIEW as a Query Input Database File (QRYFILE parameter). The
> database file would be named either on the RUNQRY or on the "Specify
> file selections" of the WRKQRY command [or its equivalent, QRYRUN or QRY
> in the S/36EE]. Depending on the requirements, the expression to define
> the VIEW column [or QM query report column] might be as simple as using
> the DECIMAL cast function:
> DECIMAL(string_fld, 10, 2)
>
> --
> Regards, Chuck
> That's a ton of work and shouldn't be necessary for quick development, miss you man.
> Tom Black

1
server_pubkey.txt

rocksolid light 0.9.7
clearnet tor