Re: [sqr-users] Help in running ben100

["Katrina Trescott" <katrina_trescott@excite.com>]

 Thank you david.  
What I don't understand is that the SQL works if the table name is explicitly 
stated; i.e. select emplid from ps_job.
It does not work if you define $tbname to be 'ps_job'
and use select emplid from /$tbname/
I will check with the DBA though.
Katrina Trescott


 --- On Tue 01/07, David Thorburn  wrote:From: David Thorburn [mailto: 
thorburn@conl.net]To: sqr-users@sqrug.orgDate: Tue, 7 Jan 2003 12:12:05 
-0800Subject: Re: [sqr-users] Help in running ben100Look at the expended JES 
JCL and see what DBID or OWNERID is resolved whenyour JUCL is submitted.Usually 
different PROCS are set up for each DB/ENVIRONMENT.You are probably not using 
the right PROC setup for your acceptance DBimage.Your DBA will probably be 
helpful in this case too!Regards,David----- Original Message -----From: 
"Katrina Trescott" To: Sent: Tuesday, January 07, 2003 11:55 AMSubject: 
[sqr-users] Help in running ben100> Hello, We are trying to run Ben100 in one 
environement and are getting anerror because the ownerid is not getting put in 
front of the table name ;where the table name is supplied by a substitution 
variable.  The ownerid isput in front of tables that do not use the 
substitution variable.  This SQRruns in our development environment; but not is 
our integration testingenvironment.  This is very confusing to me.  Where does 
the ownerid comefrom in when a substitution variable is used versus not.  We 
run on OS390and have DB2.Thanks,Katrina Trescott>> 
_______________________________________________> Join Excite! - 
http://www.excite.com> The most personalized portal on the Web!>> 
_______________________________________________> sqr-users mailing list> 
sqr-users@sqrug.org> 
http://www.sqrug.org/mailman/listinfo/sqr-users>_______________________________________________sqr-users
 mailing listsqr-users@sqrug.orghttp://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users