RE: [sqr-users] Parameter Flag

["Alexander, Steve" <Steven.Alexander@sanjoseca.gov>]

sqrw has lots of optional parameters.  One way to study them is to just run
sqrw without parameters.  You'll get a dialog box with a help button.  The
help button will take you to the help file on the command line syntax.  If
you're just trying to run a single SQL statement, why not try a database
front end like Oracle's SQLPlus?

-----Original Message-----
From: Vito Campanelli [mailto:vito.campanelli@mcgill.ca]
Sent: Thursday, February 05, 2004 8:03 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Parameter Flag


Hi Carlos,

Thanks for your reply, but I was hoping for an explanation on how do build
the command line executable. i.e. 
sqrw.exe reportname -XMB -e -o -keep  "-I;C:\log\"

Thanks
Vito

-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org] On Behalf
Of Carlos Loperena Matias
Sent: Thursday, February 05, 2004 9:27 AM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Parameter Flag

Hi Vito, I do a select with paramaters like this. 

select
h.bdry_nm,dh.special_bdry_type_cd,h.bdry_short_nm,dt.draw_id,dos_id,datename
(weekday,dtos_id),dtos_id,
dh.qty,0
from draw_hierarchy dh, hierarchy h, ##driver_table dt
where dh.structure_id = 7 
and dh.bdry_id = h.bdry_id
and dh.draw_id = (dt.draw_id)
and dh.special_bdry_type_cd <> 'RET' 
and h.bdry_short_nm in
('{Abczone}HDHD','{Abczone}HDEM','{Abczone}HDCT','{Abczone}HDML','{Abczone}S
CDL','{Abczone}SCHK','{Abczone}SCSC','{Abczone}SCBK')

Have Fun

Carlos A. Loperena Matías
El Nuevo Dia - Sistemas de Información 787-641-8000x2984
mailto:cloperena@elnuevodia.com

 -----Original Message-----
From:   sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]  On
Behalf Of Vito Campanelli
Sent:   Thursday, February 05, 2004 10:13 AM
To:     sqr-users@sqrug.org
Subject:        [sqr-users] Parameter Flag

Hi,

I am fairly new to SQR. I am having trouble trying to create the SQR
command line with parameters. The select query that I would like to
execute is as follows:

Select * from employees where id in ('1001', '1212', etc)

Can anybody help with this?

Thanks
Vito


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


The information contained in this message is confidential and is intended
for the addresses only.  If you have received this message in error or there
are any problems, please notify the sender immediately.  The unauthorized
use, disclosure, copying or alteration of this message is strictly
forbidden. 




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



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

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