DSXchange

or just click on DataStage Help on the designer, go to index and type Mod, it will show up.

Actually, OOPS , i just checked. Thats not the correct syntax,
its Mod(In.link, 3) =0, So basically now my code would look like

No, your slightly off on the 'Warning-conditional'

Ok-Conditional - > For Finished Without Warnings
Warning-Conditional -> For Finished with warnings

Two stage variables, Var and cond should get this done.

Only Finished - OK.
FOr Finished with warnings, there is another trigger.

Even then its pretty ok. Do all the process, right before you want to do the "NOT EQUAL Lookup", load it into a temp table and then run a sql query and then continue.

Great piece of advice from Craig. If i were you i would start looking at the erraneous row.

Or you could just run that at the database level.
Out of curiosity, if you know something like this will be more robust at the database level, then why not go with that approach???
Dont tell me the source is a flat file, if so, then it can be loaded into a temp table.

You will not get 44444444 because once Arg1 is assigned to "idexecrec.EXEC_TELEPHONE " in the $DEFINE TESTING portion, you are reassighning it after the $ENDIF statement. Here test this idexecrec.EXEC_TELEPHONE = Arg1 idexecrec.LOC_TELEPHONE = Arg2 * Change to $UNDEFINE when done testing $DEFINE TES...

How about doing it at the database level. Something like

His code didnt work for you because its checking for "NULL" (the literal NULL) as Arg1. That was only for testing purposes. You were to provide NULL as Arg1.

If it gave 896 then thats the size of just the column names. 896 bytes of data. Keep in mind that its not just column names, but also double quotes and delimiters. Add data to the file and then test my routine. Then delete data and only keep the column names and then test my routine. It should work....

NOTE: where 807 is the length of the column headings. Mroethan that number means there is data in the file and mail will be trigegred. I am afraid you are wrong. readseq will only return the first line which will be column names and no matter how large the file is, that size will remain constant, u...

Does that character exist no matter how many times you execute it?
What i am trying to say is, if that character takes up 1 byte then instead of checking for 807, you should check for 808. But thorough testing is needed.

Here, use this idexecrec.EXEC_TELEPHONE = Trim(Arg1) idexecrec.LOC_TELEPHONE = Trim(Arg2) iLen=len(idexecrec.EXEC_TELEPHONE) If iLen = 0 Then idexecrec.EXEC_TELEPHONE = @NULL If (isNull(idexecrec.EXEC_TELEPHONE)=0) Then Ans=idexecrec.EXEC_TELEPHONE[1,16] End E...