DSXchange

Hi All, I think we can't perform 2 actions (selecting and updating) on a table at the same time, because if the select query is trying to select a record and at the same time if it is trying to update on the same record then the table will be locked. (info known) Praveen if this problem is solved pl...

Read the source and write an output with record delimiter as comma Thanks Sai. I tried this , the output is coming as 1,2,3,4, Hi Pravin, I am looking at this thread which seems to be important and may be useful any time. Can you tell me how did you try this, did you try this with the pivot stage? ...

Hi Ray & Duke.. Thanks for the response.... Duke - Can you tell me something more about the UV stage and how can i read the log... What are the columns to specified to retrieve the log... I tried with couple of dummy columns where I can get date occurred and event ... but i am not able to retrie...

Hi.... I am trying to archive the job log after every run, i need to save the full detail log in a flat file. 8) I am able to save the status of the job and runtime but i need the whole log even if it ran with OK, Warn or Aborted. Is there any way to get the log. :idea: I am using 7.5.2 Version on W...

The parameters which we was passing are given wrong... :D

Thanks...

Hi.... I have an .exe file on my datastage windows server, My job is to trigger that exe file by passing the parameters to that file and invoking it. It ran fine when triggered manually with cmd.exe interface Coming to the datastage job, i tried with ExecDos routine as before job routine, and also t...

This topic has been resolved, actually I had an Oracle stage as a Source and in SQL tab I called the stored proc

'SELECT 'Procedure <procedure name> last ran: ' || sysdate FROM dual'

where i am not passing any parametes and taking sysdate as output and writing to file.

Hi, I have a Stored Procedure which needs to be triggered by the datastage job. The Procedure starts based on the sequence number in oracle and inserts records into table. Procedure has to trigger as the job starts and the Procedure is not having any Input Parameters. I tried with the STP stage as t...