[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] Call SYSTEM command in SQR
- Subject: Re: [sqr-users] Call SYSTEM command in SQR
- From: yamuna_pandiyan@freddiemac.com
- Date: Mon, 4 Apr 2005 15:16:01 -0400
- Delivery-date: Mon, 04 Apr 2005 14:16:44 -0500
- In-reply-to: <s251584e.096@FCC7.frederick.edu>
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Thanks Jamie,
It works.
Yamuna
918-5127
"Jamie Harris"
<JHarris@frederic
k.edu> To
sqr-users@sqrug.org
Sent by : cc
sqr-users-bounces+yamuna_pan
diyan=freddiemac.com@sqrug.o Subject
rg Re: [sqr-users] Call SYSTEM
command in SQR
04/04/2005 03:07
PM
Please respond to
"This list is
for discussion
about the SQR
database
reporting
language from
Hyperion
Solutions."
<sqr-users@sqrug
.org>
Hello,
> $CMD = 'cd' ||$DataDirectory
> $cmd = 'ls -lt SAMPLE.DAT >' || $DataDirectory
||
> $file_list
> call system using $syscmd #unix_status
>
It looks to me like the above would not even try to execute the 'cd'
command, since there is no 'call system' between the first and second
lines (which each assign $CMD to something). SQR variable names are not
case-sensitive. I also see that in the call system command, it's using
$syscmd - I don't know where that gets set, but it's not going to
contain the cd or ls commands above.
If 'cd' won't work in the program, you could try this:
let $cmd = 'ls -lt ' $DataDirectory || '/SAMPLE.DAT >' ||
$DataDirectory || > $file_list
call system using $cmd #unix_status
There's no need to actually move to $DataDirectory if all you need is a
listing of the sample.dat files within.
Hope this helps!
-----------------------------------------------------
James Harris
Junior Systems Programmer/Analyst
Information Technology Division
Frederick Community College
-----------------------------------------------------
>>> yamuna_pandiyan@freddiemac.com 4/4/2005 2:12:32 PM >>>
Yes there is a space in the cmd line , that was a typo in the below
email,
it should be - $CMD = 'cd' || ' ' || $DataDirectory
Thanks,
Yamuna
918-5127
"Prasanna Menta"
<pmenta@umuc.edu>
To
Sent by : "This list is for discussion
about
sqr-users-bounces+yamuna_pan the SQR database reporting
language
diyan=freddiemac.com@sqrug.o from Hyperion Solutions."
rg <sqr-users@sqrug.org>
cc
04/04/2005 02:06
Subject
PM Re: [sqr-users] Call SYSTEM
command in SQR
Please respond to
"This list is
for discussion
about the SQR
database
reporting
language from
Hyperion
Solutions."
<sqr-users@sqrug
.org>
You have to know the structure of your unix file directory - Also you
need a space between cd and $datadirectory
$CMD = 'cd' || ' '|| $DataDirectory
yamuna_pandiyan@freddiemac.com wrote:
>
> The following command works fine or the directory from where the SQR
> program runs - '/shared/main/prog/sqr'. This command does not look
for
the
> file in a different directory, i.e the data file resides in the data
> directory - ' /shared/main/files/data/'. This is true if the command
is
> used with or without the predefined prefix variable.
>
> Example, I copied the data file from the above data directory to the
SQR
> directory and ran the program.The latest SAMPLE.DAT file name was
written
> into the filename defined in the '$file_list' variable.
>
> I did the cd command, $SqrDirectory = '/shared/main/prog/sqr'
> $DataDirectory = '/shared/main/files/data/'
>
> $CMD = 'cd' ||$DataDirectory
> $cmd = 'ls -lt SAMPLE.DAT >' || $DataDirectory
||
> $file_list
> call system using $syscmd #unix_status
>
> I get the error - SAMPLE.DAT: No such file or directory
>
> But the above command works fine if I copy the SAMPLE.DAT file into
the
SQR
> directory and use the following code,
>
> $cmd = 'ls -lt SAMPLE.DAT >' || ' ' || $file_list
> call system using $syscmd #unix_status
>
> Could you help me how to use the 'cd' command with 'ls' command or
how to
> make the program to look for the data file in the data directory...?
>
> Thanks,
> Yamuna
>
>
> "Dattatraya
> Shetty"
> <datta_shetty@yah
To
> oo.com> "This list is for discussion
about
> the SQR database reporting
language
> Sent by : from Hyperion Solutions."
> sqr-users-bounces+yamuna_pan <sqr-users@sqrug.org>
> diyan=freddiemac.com@sqrug.o
cc
> rg
>
Subject
> Re: [sqr-users] Call SYSTEM
> 03/31/2005 01:25 command in SQR
> PM
>
>
> Please respond to
> "This list is
> for discussion
> about the SQR
> database
> reporting
> language from
> Hyperion
> Solutions."
> <sqr-users@sqrug
> .org>
>
>
>
> This fix is simple change the command to below
> let $syscmd = 'ls -lts SAMPLE.DAT >' || $file_list
> call system using $syscmd #unix_status
> if #unix_status != 0
> stop quiet
> end-if
>
> No need to Add the fileprefix to ls command. Its a Unix command and
if
> you add fileprefix to it the OS will try and execute the ls command
> from the path in fileprefix which is wrong because the ls command is
> not stored there. its some where in /usr/bin:
> if you need to give the path then log into unix and issue the
following
> command
>
> $> whence ls
> see the path displayed and use that.
>
> HTH
> Datta.
>
> --- yamuna_pandiyan@freddiemac.com wrote:
>
> >
> > Hi Datta,
> >
> > The sqr program resides in the ' /shared/main/prog/sqr'
directory.
> > The
> > data file is created in the ' /shared/main/files/data/' directory.
> > The <FILEPREFIX} is defined in the SQC which sets the
environments.
> > There
> > is nothing wrong in the {FILEPREFIX} variable, since it woks fine
> > with all
> > other programs.
> >
> > But I am not able to debug, since I have limited knowledge on the
> > Call
> > System commands. When the below program is executed, the
> > Latestfile.dat is
> > created in the directory ' /shared/main/files/data/'.
> >
> > The error that is generated when executing the program is 'sh:
> > /shared/main/files/data/ls : not found' if I use the below
command.
> > if I remove the {FILEPREFIX} from the command line, the following
> > error is
> > generated - '/shared/main/files/data/ : cannot execute'
> >
> > Thanks,
> > Yamuna
> > 918-5127
> >
> >
> >
> >
> > "Dattatraya
> >
> > Shetty"
> >
> > <datta_shetty@yah
> > To
> > oo.com> "This list is for
discussion
> > about
> > the SQR database reporting
> > language
> > Sent by : from Hyperion Solutions."
> >
> > sqr-users-bounces+yamuna_pan <sqr-users@sqrug.org>
> >
> > diyan=freddiemac.com@sqrug.o
> > cc
> > rg
> >
> >
> > Subject
> > Re: [sqr-users] Call SYSTEM
> >
> > 03/30/2005 04:14 command in SQR
> >
> > PM
> >
> >
> >
> >
> >
> > Please respond to
> >
> > "This list is
> >
> > for discussion
> >
> > about the SQR
> >
> > database
> >
> > reporting
> >
> > language from
> >
> > Hyperion
> >
> > Solutions."
> >
> > <sqr-users@sqrug
> >
> > .org>
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > Hi Yamuna,
> > The Second part of the Problem is that FILEPREFIX may be an
> > environment
> > variable not defined?
> >
> > In the fist part the $ is missing for an environment variable.
> >
> > It would help if you let us know what is the excat command you are
> > typing
> > in at the command
> > prompt.
> >
> > e.g
> >
> > $> ls -tls FMUBSOPT.DAT* > ${FILEPREFIX}Latestfile.dat
> > is this what you are typing ?
> >
> > The fact that you are getting a file called Latestfile.dat tells
me
> > that
> > the FILEPREFIX is not defined or you are not keying it correctly
what
> > is it
> > ?
> >
> > HTH
> > Datta.
> >
> >
> >
> > yamuna_pandiyan@freddiemac.com wrote:
> > I am using a program which needs to compare the current data with
the
> > previous data file. the data files are created with date and time
> > stamp.
> > This program runs once a week, and has to compare the previous
weeks
> > data
> > file to monitor the data changes.
> >
> > I am using the following command on the Unix box to sort the most
> > recent
> > file
> >
> > let $file_list = '{FILEPREFIX}Latestfile.dat'
> >
> > let $syscmd = '{FILEPREFIX}' || 'ls -lts SAMPLE.DAT >' ||
$file_list
> > call system using $syscmd #unix_status
> > if #unix_status != 0
> > stop quiet
> > end-if
> >
> > The Latestfile.dat file is created in the data directory mentioned
> > under
> > {FILEPREFIX}. But the file is empty. I would like to send the
result
> > of the
> > command
> > ls -lts SAMPLE.DAT* to the above file.
> > when I execute the above program in the unix server , I ge the
> > following
> > error - {FILEPREFIX} : cannot execute, but a blank file in the
name
> > of
> > Latestfile.dat is created.
> >
> > any help in greatly appreciated.
> >
> > Thanks,
> > Yamuna
> > 918-5127
> >
> >
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> >
> >
> > ---------------------------------
> > Do you Yahoo!?
> > Yahoo! Sports - Sign up for Fantasy Baseball.
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> >
> >
> >
> >
> > _______________________________________________
> > sqr-users mailing list
> > sqr-users@sqrug.org
> > http://www.sqrug.org/mailman/listinfo/sqr-users
> >
>
> __________________________________
> Do you Yahoo!?
> Yahoo! Personals - Better first dates. More second dates.
> http://personals.yahoo.com
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users