DSXchange

It looks fine - as a regular expression - to me. Perhaps the Filter stage has an undocumented limit on the length of the regular expression. You ought to ask your support provider. Meanwhile can someone else with access to parallel jobs try to reproduce Peter's issue?

I don't think the Enterprise stage can set ODBC transaction isolation levels. Certainly in Read mode it can not; and I don't believe it's possible using SQL either. "Read uncommitted" is an ODBC convention, at least originally. Ask your DBA if there's any setting you can make, and if there is you mi...

You need to diagnose more deeply. Put a Peek stage on each link, the better to see what's happening at each phase in the processing.

1. In Director, No.

2. Invoke the job every Sunday then check to see whether the day number is less than or equal to 7 before proceeding.

It's initially a syntax issue. Identifier names (table names, column names) are case sensitive. Eff_Start_Dt and EFF_START_DT are not the same. The error message generated should have given you a clue to this. It's secondarily a syntax issue. You are providing two parameter markers to test against t...

You are using the same job handle for all jobs! Unless you wait for job J1 to finish before attempting to start job J2, job J2 can not successfully be attached. Try using an array of job handles. Or create a job sequence, and inspect the code generated by compiling that, to learn one method of worki...

This is happening in DB2, not in DataStage. Find out what DB2 error code -668 means. Address this issue in your production environment.

In particular find out whether any other process is accessing the table while your DataStage job that generates these errors is running.

Try disabling your firewall for the duration. It may be that one of the requisite ports - particularly 31538 - is blocked. Anti-virus software can also interfere with the installation, since none of it knows about the DataStage services, and may be attempting to block them. I recently upgraded to th...

Export only exports the design time components, skipping any locked ones. Components are locked if they are being edited in a client. It is also possible that jobs are locked if they are being monitored or open in log view in Director. If none of these conditions obtains, you can safely do a full ex...

"GlobalParams_jpEXTRACTDATE.prm" is not part of DataStage "out of the box". The naming convention suggests that it is one of Kim's.

It is possible, but will become a nightmare to maintain. What you want to do can only be achieved manually - that is, it is you who must generate the numbers and dates. I'm not sure that you can use Version Control to promote under these conditions - it's used to move objects with the same name into...

Can the Administrator client connect to the project?

Can you invoke dssh in a project on the server?

What is the meaning of "BALCKHOLE" in datastage "BALCKHOLE" is not a word, in DataStage nor anywhere else. "BLACK HOLE" (two words) has been discussed above. It's domain is astronomy; it is only used metaphorically elsewhere. The only black hole in DataStage, in my opinion, is the uncritical accept...

Yes it's possible, but it must be done correctly. The post to which narasimha referred will help you to assess what that means.