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

[yamuna_pandiyan@freddiemac.com]

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