I am trying to compare the same file that exists in two distinct environments on AS400. The file may or may not be the same, that is the purpose of my program. I have created an SQL statement that preforms the task. However when i try to impletment this statement in a program i am having problems. In my program i take 2 values entered by the user, the two environments that i want to do the file comparison between.
In my Declare cursor, i have a valid 'SELECT', but the 'FROM' part of my statement is going trouble, i cannot include the user entered environment here, it seems it has to be hard-coded.
Can someone please give me a possible solution to this or to somewhere on the net with an example how to do this.
September 14, 2005 6:49 AM
September 26, 2005 8:14 PM