Re: [sqr-users] Call SYSTEM command in SQR

[yamuna_pandiyan@freddiemac.com]

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