DSXchange

Hi All.

I am running a parallel job with the stages as below:

SeqFileIn -> Xfrm -> SeqFileOut

I want to preserve the order of records as per the source file. Our APT_Config_File is having two nodes.

is there a way i can maintain the order?

Any pointers how do i mount?

Hi ALL. I am trying to access a file from remote server using seq file stage. The remote location is a shared folder and dsadm user has been granted access to the drive. i can access the shared drive through putty using dsadm creds, but not able to access it from my job, i tried to hard code //ip/pa...

I agree to what you are saying, it was just one of those tests we stumbled upon.

I am gonna suggest to remove the length completely and then constrain it in the constraint defined.

Thanks a lot!!

That is because the length has been defined as per data contracts with source and target applications.

The testing team has raised this as a risk as the values are truncated in case longer strings are passed. Hence trying to find a workaround.

Its getting truncated at the input itself.

So is there a way i can handle this??

I cannot increase the length of the field. it is 20 on both sides(input and output).

Will the data be truncated at the input sequential file stage itself?? or it is truncated in the transformer stage?

Hi All. I have defined a constraint for one of the columns STR, which is varchar of length 20. Output Link Name : linkl1 Constraint : Len(lnk_payload_in.STR) <=20 I have set another output link linkl2 , in which i have checked the box otherwise/log. Output Link Name: linkl2 Constraint : Otherwise/Lo...

Hello All.

I am writing records into SQL Server DB from a file. How can i achieve the transaction control?

For me, even if a single record in the payload file fails, the entire transaction needs to be rolled back.

Is there a way i can achieve this??

Ok got your point.

Does it also display the same behavior with the number of records?

So i am creating a file with 10 records comma separated, i am passing 12 records, it does not fail, just truncates the record..

I thought DS has strict validation rules.

I have a column(varchar) of length 20, if i pass a string of 25 characters, it trims the record but it lets it pass through with a warning.

How do i reject the record, if the length is greater than specified? Is there a global setting or do i need to apply a check field by field??

Hi All. Will DataStage not throw an error if a columns is set to Nullable = no is passed with a blank value?? I have set the Columns to Nullable = No in the column properties for both In and Out seq file. On passing a blank value in one of the columns, it does not fail the record. What i expected wa...

Hi All. We have a requirement to read the incoming files from a folder. This folder is not local to DataStage server, but resides on the source application system server ( on a Windows server). DataStage is running on a Linux server. I want to know if i can access the server from a sequence job?? An...

Yes.

Hi All. We have a requirement where we need to write a common Audit component, This will capture the details about the interface run, like start time, end time, status, some other operational data etc. The operational data is to be written to a Message Queue in the form of XML message and the data i...