DSXchange

Sure,

Move the old (production) projects to the correct directory on DataStage

is a step that shouldn't be done, assuming you did an OS-level move.
What you need to do is export the project contents and then import that into the new (and empty) projects.

These are always the form of emails. Most cellular telephone systems will send a text message to the phone if an email is sent to {number}@{PhoneSystemDomain}.

"Don't Worry, Be Happy" Tessy - in the past I have used the send email facility in DataStage to make these alerts appear, and I have an externally triggered script that uses the "dsjob" command to see the last runtime of a job. If the dsjob doesn't complete, or the last runtime is older than the ra...

Configuring ODBC connectivity in Windows is much simpler than in UNIX.
The Version Control tool did not make it into 8.0.1, but should be available soon.

I assumed that the powers-that-be would monitor this forum so I didn't send any emails or the like.

With just a 1 byte difference my guess would be line terminators in UNIX - they probably were not specified in the file format.

I cannot do that, since you haven't explained what you want handled, and how. In the column attributes you can specify a default value for a column, and that can be set to NULL on a column that can contain nulls. There will be no nulls in your source file, so you have to know which values you are re...

Vilasini - I now give up.
You won't post what you have tried and what the results are when things don't work.
I gave you a transform stage derivation that will work (since I tested it), but you seem to prefer to ignore minor matters like that so I wish you luck in getting this solved.

Almost every single thread I've looked at this week has double and some even have triple duplicate posts. The problem is getting worse. About 1/4 of all my posts have been timing out as well.

I would create a column with the appropriate null handling then write it to a dataset, then view the dataset schema to get the correct syntax.

OK, it seems that your header and footer lines have different column metadata from the data stream. What do these lines contain? If they are simple, i.e "This is a Header" and "This is a Footer", then you can do this without extra stages using the output sequential file stage "filter".

Vilasini - unless you answer the question you won't get any answers!

ICONV/ICONV don't exist in EE/PX jobs, but you posted the question in this forum so that is why nkreddy_3 asked what kind of job you have.

<sigh> vilasani, what happened when you tried TimeStampToString?

Your problem is access rights, so you need to determine if the error is on reading or writing - what file is it? Once you know that, login to the system and find out the access rights to that file, you will find that they are insufficient for what that userid is trying to do.

Moderator - please remove this duplicate thread, the original is found here.