DSXchange

I have used the following procedures to clear log files. I am using DataStage V8.0.1. - Logon on to the administrator client for the domain - Select the Projects tab - Select the project containing the log file - Select the command button - In the command window; enter the following command - 'CLEA...

Hi all,

I need help on the following,

Where the job logs getting stored in UNIX server and how to clear the logs via UNIX server instead of using Datastage director/clear log?

Thanks in Advance.

Regards,
Sathish Bhojan

Hi any one can you help me that i need to update a record in sequential file.

Ex:

existing record : 1 aa
new record from source is 1 bb

Now i need to update existing record(1 aa) should be change as (1 bb).

Thanks in advance..

Hi ray,

Any other functions to achive this quit easier than what u gave before?

ray.wurlod wrote:

Code: Select all

If Left(InLink.TheString,1) = "0" Then Right(InLink.TheString,6) Else InLink.TheString

What is to happen if the first character is non-zero? You did not includ ...

Thaks ray.wurlod..What you have written is correct.If its non zero means can move same as the source.

Hi to all,

I have a data with 7 characters.i need to remove 1st character if it is 0.

Ex:

0123456 ---> 123456
0012345 ---> 012345

Could you please suggest me some tips?

Thanks kduke.. I have 6 months of experience in Datastage..I would like to do a certification in datastage.Can i able to do? There are a lot of posters whose primary language is not English. Keep asking questions. Keep trying to improve and we will gladly help fill in the gaps in your English as wel...

Hi,

Thanks for your information. Sorry for used the non standard words.Sorry again.

Can you say what are all the certifications there regarding datastage?

ray.wurlod wrote:There is no certification presently available for Server Edition.

Nor is there any planned, last we heard, though never say never. ...

Hi friends,

I am working in Datastage server jobs,i have 6 months exp.Can any one elp me regarding where to apply and how to apply?Thanks in advance.

What r all the different situation we need to use join,merge and lookup?

Could any one tell me the efficiency of join,megre and lookup in parallel jobs.