×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Thanks...will keep you posted....
Im sure this can be done. Just have to figure out the syntax. I would think
you can use host variables in a function (timestamp) !?
-----Original Message-----
From: egl-i-bounces@xxxxxxxxxxxx [mailto:egl-i-bounces@xxxxxxxxxxxx] On
Behalf Of Joe Pluta
Sent: Thursday, March 12, 2009 8:55 PM
To: EGL on and around the IBM i
Subject: Re: [EGL-i] sql help
Gotcha. I was just worried about the spacing in the line I pointed out.
I don't have a good answer, otherwise. When I get some time I can try
to poke at it a bit.
Joe
Joe,
I was looking as examples in the egl manual and it seems to put a colon
before the variable name. If I remove the " timestamp(cmtdate,cmttime) <=
timestamp(:datein,:timein)
" from the where clause it works fine.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
