Re: [U2] Run SQL statement through shell script?

2009-12-11 Thread Jeff Butera 
I think it's a CASE problem - you have "!!Start" which doesn't match 
"!!start" - just a guess.

On Thu, 2009-12-10 at 20:58 -0800, Dattatraya wrote:
> Dear All
> 
> How to run sql statement through shell? I am trying following way but no
> success.
> 
> /unidata/udt << !!Start
> SET LINESIZE 290;
> SET HEADING OFF;
> SET SPACE 2;
> SET PAGES 0;
> 
> como on studentinfo;
> 
> SELECT ID,LNAME,FNAME from STUDENT;
> como off;
> exit
> !!start
> 
> Regards
> Dattatraya


-- 
Jeff Butera, Ph.D.
Manager of ERP Systems, IT
Hampshire College
jbut...@hampshire.edu
413-559-5556

"Maybe they're slow because they didn't 
  get enough sleep last night."
 Catherine Butera

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

[U2] Run SQL statement through shell script?

2009-12-10 Thread Dattatraya 

Dear All

How to run sql statement through shell? I am trying following way but no
success.

/unidata/udt << !!Start
SET LINESIZE 290;
SET HEADING OFF;
SET SPACE 2;
SET PAGES 0;

como on studentinfo;

SELECT ID,LNAME,FNAME from STUDENT;
como off;
exit
!!start

Regards
Dattatraya
-- 
View this message in context: 
http://old.nabble.com/Run-SQL-statement-through-shell-script--tp26738809p26738809.html
Sent from the U2 - Users mailing list archive at Nabble.com.

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users