[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
- Subject: [sqr-users] Please help me.I need to submit to production
- From: brahm a <brahm2006@yahoo.com>
- Date: Fri, 26 Aug 2005 06:42:17 -0700 (PDT)
- Delivery-date: Fri, 26 Aug 2005 08:45:31 -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=uof8gHMZdn2IgklzzRo0m1MPxdPcBM+rZMtQtRcErVfLBkA7Yq9MVoLTa0PpseWIvJOxiywZNrk4tPhT0AsYh7uqXZif7wrBZu9g0EMQeJuxkHpAmWrqQjzKBnsZoKCqkQeSDDSNX8MTDQxLclFJeLjS9uvxXU2OZXa3v9xHQxk=;
- 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 web(Process Scheduler). I got the problem like it does not posted
result in \\PEOPLESVR2\HR8801\USER\REPORTS\COMMON\ACFTRM_RESULT.TXT'. I wrote
below code.I am using sql server database . 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
---------------------------------
Yahoo! Mail
Stay connected, organized, and protected. Take the tour
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users