DSXchange

Adding to the above, when I checked the director to clean up the resources, I could not find any process locking that particular datastage job.

Thanks a lot for your reply :)

Hi All,

How can we implement SFTPing a file from Unix to Windows server, in a parallel job.

Thanks in advance for your help..

HI, My question was how to convert a column from vbarchar to Bigint in datastage. Actually the issue is resolved now.It is getting implicitly convereted. The issue was that the incoming data was not being recognised as NULL. So we handled to recognise it as BLANK and the output is populated fine. Th...

HI, I have a datastage job which reads a file, and then some trnsformations are applied, and then loads into another csv file. Oneof the transformations is as below. Col2=If IsNull(Col1) then SetNull() Else (Col1) Here both Col1 and Col2 are nullable. Col1 is of 'Varchar' datatype and Col2 is 'BigIn...

Hi, I have a sequencer (s1) calling the job activity J1. If the job J1 fails it invokes another sequence SS2. SS2 has a job to capture the error details for audit, and then a routine to fail the calling sequence S1 when the Sequencer S1 was run, J1 failed and SS2 was invoked. Then SS2 failed due aft...

Hi ArndW,

After resetting, I got the below message.

Resetting stage <transformer stagename>
Finished Resetting stage <transformer stagename>

The column is already declared like that to accomdate fractional milliseconds

The start loop is having list loop with a parameter. That parameter is comma separated. So the parameter will look like p1,p2,p3. Output of the start loop is connected to a restartable sequence. The sequence has one job activity and a routine activity. The output of the sequence has 2 links, one to ...

Even I am having list loop with parameters:( Loop will be executed as many times as the number of parameters provided.

My outer sequence has start loop, inner sequence and End loop. The inner sequence contains one job activity (which extracts data from one oracle table and writes into a sequential file) and one routine (which runs job by accepting parameters)

I am passing the parameters comma seperated from the start loop, like p1,p2,p3

Also the inner sequence execution action is "Reset if required,then rerun"

I am using the datastage 8.1 version. The outer sequence will fail, when the inner sequence fails. The inner sequence has a job and a routine.So the inner sequence and the outer sequences are on "aborted/restartable" state after the job run, and checkpoints are enabled for both. But still ...

Hello everyone, I tried running a sequence inside one list loop with 3 parameters. Also restartability was implemented in the sequence level by adding checkpoint. The job ran and completed for the first 2 parameters and failed for the third one. When it was restarted, datastage gave a warning messag...

Dear ArndW,

Thanks a lot for your reply. But I am not able to view the solution as I don't have premium membership..