Re: Qualified names...

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.