Need to call a file in Server routine

[rapaka89]

Hi all

I have a file in UNIX server which I want to call it in server routine

Steps I have implemented -

Called a script in routine which will create a file in a specifed location.

I need to call the file in routine so that I can read it and process further

Can you help me out with this

[arunkumarmm]

What are you trying to do? Why cant you read the file in the job and pass it on to the routine?

[ray.wurlod]

Code: Select all

Call DSExecute("SH", "pathname_of_script", OutputOfCommand, ExitStatusOfCommand)

[greggknight]

The file and path are passed in the file is read and the value returned.
Just a simple one that reads a file with one column and one row.

Code: Select all

Function(FileName)
      **FileName = Trim(FilePath):Trim(Company):"_":Trim(TableName):".SKEY.Stat"
  

      Call DSLogInfo("FileName:":FileName, "Msg")



            OPENSEQ FileName TO FILE2 Then
               ValidOpen = @TRUE
              
               READSEQ vLineRaw FROM FILE2
                  ON ERROR
                     CLOSE FILE2
                     ErrorCode = 1
                     Done = @TRUE
                  End Then
                     
                     vLine = vLineRaw
                     FileStatus = vLine
                     Call DSLogInfo(vLine, "Msg")
                  End Else
                     Done = @TRUE
                  End
               CLOSESEQ FILE2
               Call DSLogInfo("Files Closed", "Msg")
           
               Ans=FileStatus
      END