[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Please help me.I need to submit to production-callsystem
- Subject: [sqr-users] Please help me.I need to submit to production-callsystem
- From: brahm a <brahm2006@yahoo.com>
- Date: Fri, 26 Aug 2005 08:49:49 -0700 (PDT)
- Delivery-date: Fri, 26 Aug 2005 10:50:49 -0500
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding;b=BSRBDd+g8iksMQTmFtSG+1Auw7wVd6bNmGdeRkEfsbP0nZKVHMELS5VDjKA4gvW41hCtGrvXxodCYzPpg0nNzZURTGysCiYB84QAn+IONACjn/Q8BgM1njsyC2nsxxo4BMcQaZRoEYW6oru4M2hKWNV0K+7dm4ZuDvU1VirsbWg=;
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi ,
This is Brahm.I am working on sqr.It is working in command prompt and sqrw.
It is posted result in
\\PEOPLESVR2\HR8801\USER\REPORTS\COMMON\ACFTRM_RESULT.TXT'.
But when i am running on online(Process Scheduler).It is showing the Runstatus
is 'success' and Distribution Status is 'posted' and It showing the #STATUS1 =0.
Butit does not posted result in \\PEOPLESVR2\HR8801
\USER\REPORTS\COMMON\ACFTRM_RESULT.TXT'.
I wrote below code.I am using sql server database.Here OSQL is query
analyzer.Please help me any one.
LET $COMSPEC=GETENV('COMSPEC')
LET $COMMAND1 = $COMSPEC || ' /C OSQL -U sa -P sa -D CP3 -i
\\PEOPLESVR2\HR8801\SQR\ACFTRM.SQL -o
\\PEOPLESVR2\HR8801\USER\REPORTS\COMMON\ACFTRM_RESULT.TXT'
CALL SYSTEM USING $COMMAND1 #STATUS1
SHOW 'THIS IS STATUS OF COMMAN ONE: ' #STATUS1
Thanks
Regards
Brahm
---------------------------------
Start your day with Yahoo! - make it your home page
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users