×
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.
Hi...
Thanks for the reply. Was out sick and did not have access to email...
Here's the sql statement before the call to the procedure...
"SELECT CEITM , CESER , CESTC , CESDT , CEHED FROM OHILIVFILE.convrpf WHERE CENROV = 2 and CEITM in ('MT2000') and CESTC = 'L' and CESDT between 1090801 and 1090831 order by ceitm, ceser"
I had originally built the sql statement as shown above (with the dot notation). When looking at the job log, I find this message:
Qualified object name CONVRPF not valid.
I also changed the dot with a forward slash and got the same error.
Any help would be greatly appreciated. I verified that the object does exist in library OHILIVFILE.
Thank you,
Antonio Mira
Application Developer - Mid-Ohio Division
Time Warner Cable
1015 Olentangy River Road - 2nd Floor
Columbus, OH 43212
http://www.timewarnercable.com
phone: 614 827 7949
-----Original Message-----
From: systemidotnet-bounces@xxxxxxxxxxxx [mailto:systemidotnet-bounces@xxxxxxxxxxxx] On Behalf Of Mike
Sent: Thursday, September 10, 2009 9:28 AM
To: .net use with the System i
Subject: Re: [SystemiDotNet] Qualified names...
Could you send the SQL statement? Perhaps that would help.
midrange.com
