Updating Command Table from Development to Production Database

[mintman]

Hello ,
I have a question. I wrote a Command and I have been pullin up data from that Command table.
But now I will repointing Command from Devlopment to Production. Can this be done, I know this can be donr if we use table instead of this command statement. So any other way to work this out, I dont want to redesign the whole report using tables again. Thanks for your time.

M

 

[synapsevampire]

Just edit the command and fully qualify.

-k

 

[mintman]

SELECT ILLOCN00.ILLBCD, AVG(ILLOCN00.ILMAXV) AS AvgMaxVol, AVG(ILLOCN00.ILACTV) AS AvgACTVol, AVG(ILLOCN00.ILDPIV) AS AvgDPIVol
FROM { oj { oj WMDIBSF05.ILLOCN00 ILLOCN00 LEFT OUTER JOIN
WMDIBSF05.IDCASE00 IDCASE00 ON ILLOCN00.ILZONE = IDCASE00.IDZONE AND ILLOCN00.ILAISL = IDCASE00.IDAISL AND


This is my command, now my production library will be
WMDIPSF)% instead of WMDIBSF)%, can do the same process I do for tables to re point the database even for Command table.?
Thanks.