DSXchange

Hi Kumar,

I had killed the process ID using cleanup resources, even though I cant able to retrieve it.

Hi, While I am working with datastage jobs, suddenly datastage connection is broken. so I have to close the datastage window. While I am trying to reopen the job, it shows someone is using the job. I have even killed the processID, but I can't open it. Is there any way to recover those jobs. Thanks ...

Hi, I want to insert a value incrementally for every run in transformer, so that version of every run is maintained. I cant use @rownum since it increment for every row. I should not use database sequence, since it cannot be rollbacked. Any way using stage variables or any solution? Thanks Vinod

Hi,

I have created a subroutine which has to be executed inside the batch script. Any solution.

Thanks

vinod

Kumar, Using Union we can do this i.e if the column name is similar. Since I am joining with differnent metadata, which ever metadata is mismatching, I will mention them as empty string providing common alias name. for eg: table a name deptno sal table b name deptname select name, deptno,to_char(sal...

Thanks. I am working with datastage server jobs, I can't use merge stage in server since I have to mention different key name for the same column. Is it possible in unix ? Somehow I have done this using Set Operators in SQL.. I didn't prefer lookup becoz, there is no relation between these tables th...

Hi,

Is it possible in Datastage to merge files with different metadata having common key columns?

Thanks

Vinod

Hi,

I want to truncate a number in transformer of datatype
Decimal(18,9) to Decimal(10,6).

Thanks

Vinod

I have done Reindexing, but it remains the same. Whenever I am trying to open the project it says the particular job not exists.

Vinod

Hi, I can't save the job when I am trying to save it and the window getting closed. It throws the error as mentioned below. Error calling subroutine: DSR_RECORD (Action=2); check DataStage is set up correctly in project BaseldevLOAD (Subroutine failed to complete successfully (30107)) Moreover I can...

n00b here too @INROWNUM looks like the trick, but perhaps you could pair it with @OUTROWNUM I'd build a job like this.. In transformer, add a constraint. The constraint would be something like: @INROWNUM > 1 and @INROWNUM <> @OUTROWNUM If the constraint evaluates to true, the output link should hav...

Hi, I need to transfer sequenctial file from unix platform to windows. Job: sequential file stage -> FTP Stage. Which is right or wrong??? For FTP Stage, what are all the properties i need to set?? Server Name: ???? User: PWD: Remote Path: File Name: Tell me with example, specifically what will be t...

Hi DSGurus,

How to pass parameters for running a job in unix (dsjob -run <<project name>> <<name job name>>)

let say the parameters were located in a table

Thanks

vinod

Use CLEAR STATUS option

Hi,

Is it possiable to connect to the oracle database and run squl script using routines available in datastage?

Advance Thanks.

Regards,
Vinodhraj