DSXchange

i am using folder stage to read files from load directory . My files are fixed width length file .I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) . but in my job its taking only first rows of file.Please help me what i need to define so that it w...

Sequential File stage. Method 1: File Pattern of * Method 2: Filter command of something like type * Method 3: Filter command to run script that outputs contents of all fil ... Thanks, in Sequential File stage. Method 1: File Pattern of * Method ..---- if i will go for this metod can we get file na...

Hi, Do we have any stage in DS parallel job,which can read all file from one directory ( example load ). My requirement is to read all files from directory ,files are fix width length files .I have to pick all files using one job then in intermediate stage i have one refrance table ( which has field...

Have you checked the permissions of the file / directory to which you're trying to write? In my job i am using folder stage to read files from load directory and in output i am using sequential file. My job is like folderstage-> transformer -> sequenti file stage. i am facing above message and job ...

Hi mj jobs get abborted. below is the error message.Please help. DataStage Job 24 Phantom 8148 Program "DSD.DIROpen": Line 107, WRITE attempt on read-only file. Program "DSD.DIROpen": Line 107, WRITE failure. Attempting to Cleanup after ABORT was raised in stage FolderStage..Fold...

If the files are of different format, how do you propose to process them all (parse them) in the same job? You are correct that you can read them using a single VarChar column, but what happens after ... yah it will give problem because in my job i will have to do header and trailer validation,whic...

Normal answer would be the Folder stage, but first tell us how you propose to process multiple files with different metadata in a single job. That answer will help drive the proper solution. ... . Let me explain my requirement. Sheduler will pick multiple files from different server (which may be o...

In my project i have senario like i have to pick all file from DS directory to job.
Sppose in load directory i have 4 files which may be of different formate ,i have to pick all files to my job,Please advice me how to do this?

ArndW wrote:Do all your files have the same format? ...

Yah all files are comma seprated file.

Hi ,
I have a requirement to pick all files fron load directory to datastage job.
How i will do that ?
Please help me .

i am using xml input stage ,job is working properly,but i am not able to get any record at oupt side of xml stage .
Please advice.

Is it possible to use loop mechanism inside parallel job.
Please advice me ,in which stage i can use a for loop .

Sainath.Srinivasan wrote:What have you tried so far ? ...

Hi,

i have to create one job,which will store file from take file from one server and store it in other server .
Please advice me how i can do this.

suppose i need file from another network, so in datstage job where i will define ftp name ,location so that it connect to that particular network.
Please advice

hi,

Is there any stage is there in datastage by which we can retrive record/file/table from other server.
Please advice .
Thanks