DSXchange

If suppose, the source data has character coming in instead of a numeric

Another easier way to reject a column based on whether it contains numerics only is

Hi Sai, Hi Guys, Based on Customer type i would like to update or insert records in to a sqlserver database table. I created Transform with 2 links one for update and another for Insert I am getting database locked error. It works fine for Informix database. Please help me out how to solve this prob...

Hi Logic, Here is an answer to your question from one of the previous post by Michael Hester "It's actually 2^32 or 1 in 4,294,967,296 and that is for every row. It does not mean that an incorrect CRC will be generated if you process 4294967296 rows of data, rather each row has a 1 in 429496729...

Hi NaveenD, To the best of my knowledge. Sending an email simultaneously after you reject a record is not possible. It would have to be done in a two step process. 1) Write all the records which don't meet your criteria to the Reject Report 2) After the job finishes, use a Notification Activity in t...

Hi Sai, Yes, I certainly agree that it is not the most efficient way to do it, but was just trying to see if it was theoritically possible. From the discussion we had, I can conclude that it is indeed possible to do it that way, but not very efficient. Thanks a lot for sharing your inputs on this is...

Hi Sai,

We can store the list of keys that are identified as duplicate keys in a file. Then use it as a reference to either pass the entire row (key+data) (assuming that using stage variables to pass only one row in case its a duplicate row) to the output row or not.

Hi Sai,

Cant we use the count function in Aggregator stage and based on the criteria that count > 1 along with stage variables, eliminate duplicates?. This might not be the most efficient way to do it, but theoritically it should work, right ?

Hi NaveenD,

Try giving the IP address of your mail server in the SMTP field.

Hi NaveenD,

I am glad that worked out for you. Cool thing :D

Hi NaveenD,

Did you try the %ERRORLEVEL% return code that I mentioned earlier in the same post?. If you tried, can you please tell me what was the result of it?.

Hi NaveenD, Try using this @ECHO OFF IF ERRORLEVEL 1 SET ERRORLEV=1 IF ERRORLEVEL 2 SET ERRORLEV=2 IF ERRORLEVEL 3 SET ERRORLEV=3 ECHO %ERRORLEV% or simply for display ECHO %ERRORLEVEL% you need to modify it based on your requirement I am not sure how well this works, but this might work for you. Gi...

Hi NaveenD,

I was referring to $? as the parameter that returns the return code in UNIX. I am not sure of the WINDOWS equivalent. Maybe the Gurus can help us both in this matter.

Hi NaveenD,

Yes, it returns the return code to the calling batch script. In the batch script you can capture this return code using $?
You might also want to refer to this thread viewtopic.php?t=94175

Hi NaveenD, I believe that the jobstatus return code is 1 for success and 2 for finished with warnings etc. When you remove -jobstatus option from your dsjob command, I think its returning the return code of the dsjob command execution and not the actual jobstatus, in which success is 0 and failure ...

Hi,

Check the datatype for the DATE_DT column in the DB2 Table. Sometimes, though its called a DATE column, it is of timestamp format.