Re: SQL help needed

I'm stumped by something a programmer brought up to me a little bit ago.
(5pm on Friday, just what I needed!)

I have an SQL statement that is coded as:

DATEG>=(left(cast(current_date as varchar(10)),4)

That statement works fine when I run the SQL statement using the iNav run
SQL function.

When I try to run the same statement using RUNSQLSTM I get the following
which fails:

DATEG>=(left(Cast(Translate(Concat(Substring(Cast(CURRENT_DATE AS
VarChar(10) CCSID37),1,4)

For some reason RUNSQLSTM thinks it needs to translate CURRENT_DATE to
CCSID 37 and inserts the appropriate code.

I am very far from being an SQL expert so can someone point me in the
right direction?

Respectfully,
Kendall Kinnear
System Analyst
Standard Motor Products, Inc.
Work: 972-316-8169
Mobile: 940-293-7541

________________________________
Please consider the environment before printing this email.

The content of this e-mail (including any attached files) is confidential
and may be privileged and protected by law. It is intended solely for the
purpose of the person to whom it is addressed. If you are not the intended
recipient of this message, please notify the sender immediately and delete
the message (inclusive of any attached files). In addition, if you are not
the intended recipient of this message, any disclosure, copying,
distribution or taking any action in reliance of the contents of this email
is strictly prohibited.
--
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.