Can we use a file present on desktop and by giving the path of it in the sequential file stage of DataStage, can we use it? Or only Unix specified path is used? Give me some reasons for it.
The DataStage sequential file stage takes any path of the server where the DataStage engine is installed. So if your engine is installed on Windows it will be Windows style paths - for engines on Unix it will be Unix style paths.
So if your file is not on the same server as te engine you have to transfer it first, use some FTP functionality or map a network drive (ie. SAMBA).