DSXchange

Try to set the stage variable properties.

Try this:

If
StringToDate(DSLink3.Date,"%dd/%mm/%yyyy")[1,2] = '**' then 0 else 1

Maveric wrote:Use an If Then Else statement. if valid Then () Else default value. Something like that.

I have used the funnel stage to append the reccords, As its just to see the reccords , I have taken the sequntial file ( to read the rejected records ) having one column with size 9999999 and varchar type. Hi, The Format for both the files is not same. one is a reject link file from a sequential fil...

Sorry u need CCYYMMDD So Use this Way trim(SRC_DATE)['/',3,1]:Str("0", 2-Len(trim(SRC_DATE)['/',2,1])) : trim(SRC_DATE)['/',2,1]:Str("0", 2-Len(trim(SRC_DATE)['/',1,1])) : trim(SRC_DATE)['/',1,1] Use this way Str("0", 2-Len(trim(SRC_DATE)['/',1,1])) : trim(SRC_DATE)['/'...

Use this way Str("0", 2-Len(trim(SRC_DATE)['/',1,1])) : trim(SRC_DATE)['/',1,1]:Str("0", 2-Len(trim(SRC_DATE)['/',2,1])) : trim(SRC_DATE)['/',2,1]:Str("0", 2-Len(trim(SRC_DATE)['/',3,1])) : trim(SRC_DATE)['/',3,1] Here SRC_DATE is the date field from source cheers You c...

What is the source file used ? is that a csv file ? Please check if u have given the right delimiter for reccord and field. Hi all, Iam new to IBM Information Server.I just created 1 job containg one source a.d one target sequential file and 1 transformer. So when i run the job the target file is ge...

Hi,

The Format for both the files is not same.

one is a reject link file from a sequential file and the second is from transformer n the third is the rejected reccords from table.

Hi,

Once i got this problem Jobs got hanged up in RUN stage..

And that happened when i deleted the table and then left it without giving the commit command.

when i gave the commit command it worked fine.

Thanku

Hi, I have a source file which reads a csv file followed by a transformer and then oracle_enterprise table. I have put up a reject file from both source and from transformer; At source i have kept a reject link(this file collect the records which are short of commas) , and at transformer the records...

Hi Scorpion,

Thanks a lot its working now....

scorpion wrote:Hi Shivaranjani,

Try this may be it solves ur problem:

If IsNull(INP_1.Value) Then ""else(If Trim(INP_1.Value) =1 0r Trim(INP_1.Value) ='' then 0 else 1)


Cheers,

Hi,

Please let me know how to disable "operator combination"

thanku.

Actually i have put up a check for a field comming from source which is nullable: The transformer uses stagevariable as If NUM((NullToEmpty(INP_1.Value))) = 1 or NullToEmpty(INP_1.Value) = '' then 0 else 1 if this not used it do not give any warning if used it gives warning; and the source value INP...

Hi,

As the warning still persists,

the job is aborting if the number of warnings is greater than 50

Please suggest how can i remove this warning.

Please suggest how to remove this warning; Here is the derivation for value column: before:if NUM(Trim((INP_1.Value))) = 1 or trim((INP_1.Value)) = '' Then 0 else 1 AND Now: if NUM(Trim(NULLTOEMPTY(INP_1.Value))) = 1 or trim(NULLTOEMPTY(INP_1.Value)) = '' Then 0 else 1 The records are not getting dr...

Here is the derivation for value column: before:if NUM(Trim((INP_1.Value))) = 1 or trim((INP_1.Value)) = '' Then 0 else 1 AND Now: if NUM(Trim(NULLTOEMPTY(INP_1.Value))) = 1 or trim(NULLTOEMPTY(INP_1.Value)) = '' Then 0 else 1 The records are not getting dropped but still the warning is there saying...