Hi
Can i know how to access the zip (.gz) files which are in remote unix server into windows client and unzip as well as rename to .txt file ,the same using DS
Please help me regrarding this?
importing .gz file from unix server and unzip
Moderators: chulett, rschirm, roy
Hi DSGuru,
The current process is they are accessing the .gz file which is in remote unxi server using FTP tool and moving to our local directory in windows.
But now we need to automate it using Datastage i.e we need to access and unzip after import using datastage.
I dont have idea about shell as you mentined me to use shell.
Can you plesae help me how can i do this using datastage
The current process is they are accessing the .gz file which is in remote unxi server using FTP tool and moving to our local directory in windows.
But now we need to automate it using Datastage i.e we need to access and unzip after import using datastage.
I dont have idea about shell as you mentined me to use shell.
Can you plesae help me how can i do this using datastage
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Control the FTP separately from DataStage, or from an Execute Command activity in a job sequence, or from a before-job subroutine. Use a Filter command in a Sequential File stage to execute your unzip utility; the Sequential File stage will read stdout from the filter command if one is specified.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
No, the FTP stage cannot handle compressed or zip or binary (etc) files. It does a metadata driven record by record transfer rather than just streaming bytes, which means text files only.
"I need to implement this using datastage only"
I don't understand restrictions on using scripts or the O/S for some aspects of your work. No tool can do everything and it's perfectly OK to leverage shell scripts / batch files or external tools where appropriate. And this is one of those appropriate times.
Your DataStage job can run / monitor said shell script without issue.
"I need to implement this using datastage only"
I don't understand restrictions on using scripts or the O/S for some aspects of your work. No tool can do everything and it's perfectly OK to leverage shell scripts / batch files or external tools where appropriate. And this is one of those appropriate times.
Your DataStage job can run / monitor said shell script without issue.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Sort of - but I wouldn't recommend doing it that way. If you "fake" the metadata in the FTP stage to be one (binary) column and pipe the incoming binary stream into a unzip program it will work (I have done that before) but that would normally not be a good approach. I think I used that solution in a case where the network connection was stable but very slow and it would have taken hours for the FTP to complete; by using the FTP stage in DataStage as mentioned above I was able to process the data as it came in instead of having to wait for all of it to arrive. Unless you have a similar scenario I would say that the answer to the ftp and gzipped file is "no"DSRajesh wrote:...Can we import the .gz files which are in remote unix server using FTP satge in datastage...