[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Call system
- Subject: [sqr-users] Call system
- From: brahm a <brahm2006@yahoo.com>
- Date: Fri, 26 Aug 2005 06:41:12 -0700 (PDT)
- Delivery-date: Fri, 26 Aug 2005 08:42:12 -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=y6oMtwIVgcbqM3t/84IIqN2fTHbeqC6qjPWcoC1m4oNG5qhuGKFsb92v5i5hm1ThuEq94k67/IQ9ebWB5ItcObCxHtE0Iq2O4keafbkXZwaz8pr8Xzba2yN805IjthtPqmexdztm4vsvqho2EpVLQE+2cmk50IyRk51I59PvAxc=;
- 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
---------------------------------
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