× 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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.