DSXchange

Just a change that both sign should be '}' identical to the one in the values provided by you.

Also I very much doubt that the values you provided can be considered as an exhaustive list. So more investigation is required.

Stick the following into a routine and call it wherever needed ******* SignField = Arg1[1, 1] RestField = Arg1[ 2, len(Arg1) - 1] ValueField = Field(RestField, '{', 1) : '0' Field(RestField, '}', 2) If SignField = '+' Then Ans = ValueField Else Ans = -1 * ValueField ******** Before proceeding can yo...

By the principle, a lookup in DataStage returns only one row to the main stream. I assume it is the last record of the 'record set of multiple records'. Hence if you have an 'Order By' so that the last record retrieved for that query appears at the bottom, you may be able to achieve your desired res...

You can go to 'Control Panel -> Services' and check whether you have 3 services (named something like unirpcd, uvconfig and uv) mentioned to be started. If not, try starting them.

Note - you can still do the 'release' from DataStage manager.

In older versions of DataStage, you had the option to 'Release' new jobs by which the design of new jobs is not selected. You can try to 'export' only the runtime components from the 'development' project to the 'UAT' project so that the users will not have the 'design' feature. On the humour side, ...

Did you try using MetaRecon. It does a 'source system analysis' and produces simple DataStage jobs to replicate what is accepted by the analyst.

In that case, can you take a full export of the project and perform a 'cleanup' of this project from DataStage Administrator.

The export of datastage can be compared to an archive of Oracle. It is designed and developed by the engineering team who developed the product. Also this changes with the version, components installed in the project, option selected while export etc. Hence to replicate this will be identical to mak...

You should be able to use '?' or ':1' to substitute the incoming link value in the shared container.

Try creating a job with the link within the job and then convert the part of job into a shared container.

I think the simplest solution can be to include a dummy table replica of your ES into the source system and populate this before starting any other job.

Once this is done, all your jobs can use this for referencing in SQL.

Was there a change in the Unix group to which the users are allocated? Can you log into Unix as the corresponding user and try to create a file and directory under the corresponding project folder?

Did you move the project to a different structure or use a different user name to work this DataStage?

Can it be that the surrogate key fn + inrownum gave this problem. Eg. Surr Key In Row Num Total 101 1 102 102 2 103 103 3 104 099 4 103 104 5 109 So please check the logic by passing these rows from the source back through the surrogate key transform.