SQL Question

[Kim Moorman]

Can you send a query to two different file locations on the STAR Server? I want the file to go to isn’t normal spot at /hbo/tmp but also want it to go to /hbo/sql/email so that I can email it out. Can this be done in the same query or will I have to have two copies to accomplish this? Thanks.

 

Kim Moorman, CMRP

Lead Financial Analyst

Tift Regional Medical Center

Tifton, GA 31793

Phone (229) 353-7786 Fax (229) 353-6204

For more information, visit us at www.tiftregional.com

 

The information transmitted in this e-mail and in any replies and forwards are for the sole use of the above individual(s) or entities and may contain proprietary, privileged and/or highly confidential information. Any unauthorized dissemination, review, distribution or copying of these communications is strictly prohibited. If this e-mail has been transmitted to you in error, please notify and return the original message to the sender immediately at the above listed address. Thank you for your cooperation.

 

---

This e-mail and any files transmitted with it may contain PRIVILEDGED or CONFIDENTIAL information and may be read or used only by the intended recipient. If you are not the intended recipient of the e-mail or any of its attachments, please be advised that you have received this e-mail in error and that use, dissemination, distribution, forwarding, printing, or copying of this e-mail or any attached files is strictly prohibited. If you have received this e-mail in error, please immediately purge it and all attachments and notify the sender by reply e-mail.

[Rouppas, Dorothy]

See if your unix administrator can write a script to copy it from one place to the other.

 

 

 

Dorothy A. Rouppas 

University of Toledo Medical Center 

Clinical Informatics – Systems Analyst II
(  Telephone: 419.383.3564

- Dorothy...@utoledo.edu

P Please consider the environment before printing this e-mail

--
You received this message because you are subscribed to the Google Groups "hisnet" group.
To post to this group, send email to his...@googlegroups.com.
To unsubscribe from this group, send email to hisnet+un...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/hisnet?hl=en.

[Sally D. Hanks]

You can set the query to run to /hbo/tmp   and then access the query again, comment out the file name and add a new file name and set it to run to /hbo/sql/email (or vice versa).  Just be careful that the one for sql email runs at a different time or it may miss being sent out from sql email.

--SET FILE = ‘/hbo/tmp/filename.txt’

SET FILE = ‘/hbo/sql/email/filename.txt’

 

From: his...@googlegroups.com [mailto:his...@googlegroups.com] On Behalf Of Kim Moorman
Sent: Thursday, February 09, 2012 7:51 AM
To: HISNET LISTSERV (HIS...@googlegroups.com)
Subject: SQL Question

 

Can you send a query to two different file locations on the STAR Server? I want the file to go to isn’t normal spot at /hbo/tmp but also want it to go to /hbo/sql/email so that I can email it out. Can this be done in the same query or will I have to have two copies to accomplish this? Thanks.

--

[lwin...@mbhs.org]

Well, sort of.
Create a recurring batch job with two RUN statements.
Run statement number one would execute the query that sends the file to the /hbo/tmp directory
Run statement number two would execute the query that sends the file to the /hbo/sql/email directory

RUN        QB_SENDTO_TMP,
RUN        QB_SENDTO_EMAIL

be absolutely certain to have a comma after the first run statement !!

Now you have the file(s) in two different directories.

--

You received this message because you are subscribed to the Google Groups "hisnet" group.
To post to this group, send email to his...@googlegroups.com.
To unsubscribe from this group, send email to hisnet+un...@googlegroups.com.
For more options, visit this group at

http://groups.google.com/group/hisnet?hl=en.

[Sally D. Hanks]

That’s even better.