unzip in unix

[naren6876]

Hi,
I have written a Before/After Subroutine as below. And it is errored out.

SUBROUTINE unzip(InputArg,ErrorCode)
Command = 'unzip /TESTZIP/xyz.zip'

Call DSExecute("UNIX",Command,Output,SystemReturnCode)

If SystemReturnCode <> 0
Then
Message = "Error when executing command: " : Command
Call DSLogWarn(Message, "unzip()")
End
Else
Message = "Executed command: " : Command
Call DSLogWarn(Message, "unzip()")

End


ErrorCode = 0 ;* set this to non-zero to stop the stage/job

anyone can throw some light on this please.

Thnaks in advance.

[ArndW]

It would be very helpful if you could actually tell us what the error is. You should also include the contents of the variable Output in your error message.

[naren6876]

It would be very helpful if you could actually tell us what the error is. You should also include the contents of the variable Output in your error message. ...

It doesn't say anything. But it always logs it as warning with the message

Error when executing command: unzip /TESTZIP/xyz.zip.


why it is not unziiping the zip file.?.

Thanks

[meena]

Hi,
Can you check with "

Code: Select all

SUBROUTINE unzip(InputArg,ErrorCode)"

.In your code I do not see InputArg. I am not sure the error is because of this or for something.Post the error.

Code: Select all

SUBROUTINE unzip(InputArg,ErrorCode)
Command = 'unzip /TESTZIP/xyz.zip'

Call DSExecute("UNIX",Command,Output,SystemReturnCode)

If SystemReturnCode <> 0 
Then 
   Message = "Error when executing command: " : Command
   Call DSLogWarn(Message, "unzip()")  
End 
Else 
   Message = "Executed command: " : Command
   Call DSLogWarn(Message, "unzip()")  

End 


ErrorCode = 0      ;* set this to non-zero to stop the stage/job

[naren6876]

Hi,
Can you check with "

Code: Select all

SUBROUTINE unzip(InputArg,ErrorCode)"

.In your code I do not see InputArg. I am not sure the error is because of this or for something.Post the error.

Code: Select all

SUBROUTINE unzip(InputArg,ErrorCode)
Command = 'unzip /TESTZIP/xyz.zip'

Call DSExecute("UNIX",Command,Output,SystemReturnCode)

If SystemReturnCode <> 0 
Then 
   Message = "Error when executing command: " : Command
   Call DSLogWarn(Message, "unzip()")  
End 
Else 
   Message = "Executed command: " : Command
   Call DSLogWarn(Message, "unzip()")  

End 


ErrorCode = 0      ;* set this to non-zero to stop the stage/job

do we need to have InputArg in the code.?

Thanks,

[kris007]

As Arnd suggested, add the Output variable to your error message like this

Code: Select all

Message = "Error when executing command: " : Command : Output

and then see what exactly is causing the error. It will be easier to debug that way.

[naren6876]

As Arnd suggested, add the Output variable to your error message like this

Code: Select all

Message = "Error when executing command: " : Command : Output

and then see what exactly is causing the error. It will be easier to debug that way.

Hi.
when i use the option 'o' it ran ok.
unzip -o /TESTZIP/xyz.zip

But i cant see the file in the folder.
the Output variable has the value

Archive: /TESTZIP/xyz.zip
inflating: xyz.txt

any clues about this.

Thanks in advance.

[ArndW]

DataStage jobs shell out with a current attach point / working directory of the project that the job runs in. Check there for the output file.

[ArndW]

DataStage jobs shell out with a current attach point / working directory of the project that the job runs in. Check there for the output file.

[naren6876]

DataStage jobs shell out with a current attach point / working directory of the project that the job runs in. Check there for the output file. ...

Hi,

How can i change the directory in the routine. so that it can place the file where the zip file is.

Thanks in advance.

[ray.wurlod]

Is there another option for unzip to specify the target location?

If not, change the command to

Code: Select all

cd pathname && unzip -o /TESTZIP/xyz.zip 

[naren6876]

Is there another option for unzip to specify the target location?

If not, change the command to

Code: Select all

cd pathname && unzip -o /TESTZIP/xyz.zip 

...

yes. I have other location to store the unzipped files.How can i do that?.

How can i give morethan one parameter to Before/After subroutine?.
Because my InputArg contains the Complete path including zip file name.

Thnaks in advance.

[ray.wurlod]

You can have as much as you like in InputArg. Put some kind of delimiter between each piece, and use the Field() function in your subroutine to parse them out.
For example, the Input Values field might contain #SourcePath#|#TargetPath#

Code: Select all

SourcePath = Field(InputArg, "|", 1, 1)
TargetPath = Field(InputArg, "|", 2, 1)