DSXchange

We require some processing after a job has executed. Currently we are using server routines (BASIC) for this purpose. Is it possible to use parallel routines as Before/After Job routines:?: We went through the documentation, and tried parallel routines in transformer, both as function and as "B...

Hi All, I am writing after job routine . I need function which gets the line of the search string, I want to take first part of the line(here i can use Field). Delimiter in the line is /. Is there any alternate to UNIX `grep` in Datastage Basic Or is there any other logic to do the same. Also can i ...

Thre was no problem with compilation, In compilation it has to say that the .o file is not generated but it is saying while executing or vaidating Job.

Reagrds,
Madhu

Thanks Very Much. The .o file was not generated because of complitaion problem which was not noticed by datastage compilation, When a revisited the transformer stage TrimB(StringToDecimal(<Field Name>)) was creating the problem. After changing this to StringToDecimal(TrimB(<Field Name>)) the .o fiel...

Hi ALL, The problem is : In Oracle table the datatype of one field is Timestamp which is not interprted by Datastage Timestamp. The error is as below. main_program: Internal Error: (colDesc):orautils.C: 1714: getColDesc failed. Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are ...

Rajeev,

I got the reason, Could you explain me the steps to execute osh.

Regards,
Madhu

Hi ALL, I am also facing Problem with Timestamp. The problem is : In Oracle table the datatype of one field is Timestamp which is not interprted by Datastage Timestamp. The error is as below. main_program: Internal Error: (colDesc):orautils.C: 1714: getColDesc failed. Traceback: Could not obtain sta...

One more observation is the file found in the server is not matching with file in the error log.

Error Log File Name:V0S134_IWH_Expense_Details1_TRN_Handle_Null.o

File Name in Server :V0S134_IWH_Expense_Details1_TRN_Handle_Null.trx.osh


Regards,
Madhu

When i Checked in the server I found that File. But Other jobs with same transfomer stage is running fine, This was also running fine, After doing some changes in the job, I got this error. Now I took the old job and did the same changes, only change i did'nt do was link name change. Now job is work...

Hi All, I am getting the below error,when running the job......... TRN_Handle_Null:-Is a transformation stage in the job. TRN_Handle_Null: Failed to load the library "V0S134_IWH_Expense_Details1_TRN_Handle_Null.o"; either the directory containing the library file is not on the library sear...

Hi All, I am getting the below error,when running the job......... TRN_Handle_Null:-Is a transformation stage in the job. TRN_Handle_Null: Failed to load the library "V0S134_IWH_Expense_Details1_TRN_Handle_Null.o"; either the directory containing the library file is not on the library sear...

THANKS FOR THE REPLIES:-

But the problem is we want the reject link for the insertion.


Oracle Enterprise (Load/Truncate) and Dynamic RDBMS Will not provide the reject link.

How do I achieve truncate - insert and still have the reject link for the insert operation.

Hi ..I need to truncate the records from a table and then insert records coming from a source table. To do this am using 2 separate oracle stages - one for "delete all rows" and another one for upsert(insert and dummy update). But the problem is the records are getting deleted and inserted...

Thanks You Very Much Craig,

After Posting I observed in the job same thing and I corrected It.

Regards,
Madhu

Hi All, I am getting below error while running the job, can anyone say what is reason for the message:- main_program: Data set, file set, or file "ORCL_Tgt_Quote:LNK_Rej_Quote.v": Non-pipe (or non-virtual data set) with .v in its name Data set, file set, or file "TRN_Handle_Null:LNK_D...