DSXchange

Thanks Ray, The trigger from SQ2 is a custom trigger as below (Finished OK or Finished with Warnings). CodeRefresh.$JobStatus = 1 or CodeRefresh.$JobStatus = 2 The email was not triggered which is correct as this trigger was not satisfied , But the job shows finished even though this trigger conditi...

Hi all, I have sequence job where am using an "all" sequencer condition to check the status of 2 sequencers and send out a notification that the job completed. SQ1 completes successfully and SQ2 is aborted. I have a info on the director that says and I assume its because the trigger from t...

Hi all,

I used the IsValidDate() instead of IsNotNull() and that resolved the issue.

Thanks All.

Hi All, Am using a derivation as show below for a TIMESTAMP field and getting the error bInvalidDateTime has value 1 because the Field164 is empty in some instance and the job is trying to insert a ' ' to the TIMESTAMP and aborts If IsNotNull(LNK_READ.Field164) Then StringtoTimeStamp((Trim(LNK_READ....

Thanks all,

I changed the return code to a 1 and It resolved the issue.

Hi All, Am using a before and after routine to execute a PL/SQL block that updates the job log information to a oracle table. Is there a way to abort the job incase the before or after sub routine fails , as my job runs even when the before routine fails. Am using the ExecSH routine to call the PL/S...

Thanks Ray,

I will try to filter it before the Pivot stage and update that column via another process.

Hi all, Am using a vertical pivot , but a new requirement is not working and am not sure on the change. Initially Data was available as shown below and I was able to do the veritcal pivot as Value_1, Value_2, Value_3 ID SEQ_ID VALUE 1 | 1 | A 1 | 2 | B 1 | 3 | C 2 | 1 | X 2 | 2 | Y but now they have...

Thanks Mike , This resolved the issue (\\\\)

Hi All, I have a job that needs to send out a notification with the location of the file in the Email body. The job runs fine and sends the notification but if specifies only a single '\' rather than '\\' as mentioned in the body. I tried to have the same in double quotes but still it sends out only...

Hi all, Am trying to extract data from a Sybase DB and getting the below mentioned error DSTAGE-SYBOC-0023`:`Sybase Open Client error: ct_fetch(): user api layer: internal common library error: The bind of result set item 23 resulted in truncation. DSTAGE-SYBOC-0023`:`Sybase Open Client error: ct_fe...

Hi Craig,

I tried using conventional load with the option set to 'No' and it either aborted (NULL Constraint) or sent these records to the reject file when I rejected the SQL constraint violation records .

But when I changed it to 'Yes' it loaded the data.

Hi Criag -
Just to update , I just ran the job via conventional insert and it worked fine.

So it works for both bulk and conventional insert.

Hi Craig,

It was a bulk load

Thanks Kashyap,

That resolved the issue.