DSXchange

sb_akarmarkar wrote:Look like empty string... Try to add Trim(ColumnName) <> ''...

Thanks,
Anupam

but this is a compliation error rite?

aakashahuja wrote:Whats the actual error that you are getting?

theres no error attached wiith the compliation codes.
but the problem is in the substring in the second if clause. - If i/p_column1 = "A" Then IF IsNotNull((ip_column2)[1,7]) THEN
ip_column2[1,7] ELSE SetNull() Else SetNull()

Thanks for ur reply!

I tried it, its still not working! the same error.

sb_akarmarkar wrote:Try now

If i/p_column1 = "A" AND Not(IsNull(ip_column2)) THEN
ip_column2[1,7] ELSE @NULL


Thnaks,
Anupam

I use this derivation in the transformer stage : If i/p_column1 = "A" Then IF IsNotNull((ip_column2)[1,7]) THEN ip_column2[1,7] ELSE SetNull() Else SetNull() The above is absolutely wrong. It can be a 'If Then Else' statement and cannot be a 'If Then If Then Else Else' statement. I mean, ...

I use this derivation in the transformer stage , i am getting the compliation error: If i/p_column1 = "A" Then IF IsNotNull((ip_column2)[1,7]) THEN ip_column2[1,7] ELSE SetNull() Else SetNull() when i used If i/p_column1 = "A" Then ip_column2[1,7] ELSE SetNull() it worked with ou...

hi,
I want to know how 0s are left padded to a string.
i used this function - padstring(sting,"0",10) but it does a right padding.

I tried with -10 for a left pad, even then it is not working... can anyone help me on this?

thanks for ur reply. i understnd that a new i/p column value will be outputted only if the constraint is specified for that. my doubt is, if there is some new i/p column value coming in , for eg., V for some 20 records, will datastage read those records are not. my concern is - in any case, the data...

Hi, I have a job in which i read a source file which has about 100 records and this is passed to a transformer.in the transformer, based on the i/p column value the row has to be moved to the appropriate datasets. In the above job, i give two constraints on the transformer stage, if i/p column =a, d...

i have given two links from transformer. constraint for link1- inputcolumn=1,no abort constraint for link2- inputcolumn<>1,abort after 1 row but as soon as i trigger the job, one record for each link is loaded and the job abortes with fatal error - Job aborting due to row limit being reached on outp...

can u pls explain me this in detail ... becos i used this option, and as soon as 1 record is loaded, in the link the job is aborted .. fatal error is "Job aborting due to row limit being reached on output link". actually even when the condition is true, the job gets aborted You can set thi...

Hi, I want to know is there anyway i can abort a job based on the input value... for eg .. if coulmn1<>a, i want the process to be aborted. is there any function which i can use in transformer stage? also i want a message to be displayed, the description for the abortion process - like "column1...

thanks for ur reply.Actually the expected number of records are loaded into the xml file, and so no warnings or fatal error had occurred, but these records are not wriiten into the file i specify on the options tab of the xml output stage.

Hi all

I am using the xml ouput stage in which i am writing the output to a file by specifying its path.but the file is not created in the specified path..

can any one throw some light on y the file is not created?

is there any stage which drops / keeps columns based on a condition?

eg.,
column1 =1, drop input column ...
or isnull(i/p column), drop it

like this?

We can use the modify stage for keep/drop columns, but i want to know is that possible to do the same based on some condtion ...

Hi all, I am creating a job, in which i am using a sequential file as target file. My requirement is that the structure of the file, i mean the no. of the columns columns should change dynamically, based on a single value from the input.. for eg., if this is the i/p : 100,A1,234567 120,B1,123456789,...