two part problem here
1. It appears I can only have one sql stmt in a batch file that i
referenced on command line call to dbisql. Can this be worked around?

2. Need to pass a date parameter to the batch file. Preferable usin
a date value from another table.

sysbase 6, NT system

batch file
SELECT A.maj_grp_seq, A.obj_num, A.cat, A.name, B.business_date
B.sls_cnt, B.sls_ttl, B.rtn_cnt, B.rtn_ttl, B.dsc_ttl
FROM micros.maj_grp_def A, micros.dly_sys_maj_grp_ttl B
WHERE A.maj_grp_seq = B.maj_grp_seq;
OUTPUT to d:\wbsqs_v5\import\micros\Daily_Mjr_Grp_seq.csv
FORMAT ASCII

SELECT * FROM micros.v_R_employee_time_card;
OUTPUT to d:\wbsqs_v5\import\micros\Time_card_export.csv
FORMAT ASCII
----------------
each statement works fine as a separate batch file

need to add WHERE business_date = {date} but I don't see how to do thi
(could pass system date as a VB parameter) prefer the date from
specific table.

using vb to call shellexecute

comments would be appreciated
Thanks
R


-
PowerHamme
-----------------------------------------------------------------------
Posted via http://www.webservertalk.co
-----------------------------------------------------------------------
View this thread: http://www.webservertalk.com/message349100.htm