DSXchange

Hi all,

If I want to execute multiple commands on the Before or the After job routines, for example if I want to execute 2 commands in the before job routine like 'delete a file from a directory' and also cat 2 or 3 files to make a single file, how can I do this.

thanks guyz

3 jobs, the one that creats header, should be a 'overwrite' of the file, means new and the one that extracts data from table will be second in the sequence which appends and then the third one that writes the trailer will be the last in the sequence that should also append

sorry guyz, i got it

somehow I was confused for a second and posted this even though i did this before, memory blank i guess.

How to see this in the DS Adminstrator?

I am off the designer and then logged in again, now I don't have this problem.

I was executing some samplejobs to see the data quality, the input file has just one row and I am writing this to a output file. The job is well compiled and run, but after I checked the result, I clicked on the Job parameters and I get the pop-up as 'Unable to create the Stage editor object', why d...

Can I establish the connection bwtween Ms Access and DataStage directly using the DSN, user name and password to the database?

What are the constraints/limitations to this approach?

I end up in more confusion

I have a column of lenth 10 which could possible have leading zeroes.

How can I supress the leading zeros. I worked this out by checked byte by byte accross the 10 bytes, but us there is a masking function that I can use?

Thanks for the help

We are running DS 7.0 on AIX and I have a situation to conenct to a Microsoft Access database on a Windows server.

Please tell me how I can achieve this.