DSXchange

You can do that by multiple DB2 API stages too. Set the warn limit to 1 and the transaction size to 0. This way even with a single warning, the job will abort and the data will be rolled back.
or you can use the ODBC enterprise stage with transaction grouping.

You can check for files which are 7 days old and delete them. You can put this functionality as part of your unix script, if you have one. Clear out the log files regularly.

Technically speaking it shouldnt make much of a difference. But yes for large amount of records you might see that little difference add up and sum up. I havent really played around with it so cant give you a definate answer. Maybe our gurus can provide some insight. Actuallly if you think about it,...

I dont think it will make a considerable amount of difference. Its just that stage varaibles get executed first, so the @TRUE or @FALSE will be decided before the row comes in.

You cannot. Only the site moderator can do that. Unless if you can delete it and post it again in the proper forum.

IF you target database is UDB too then just pass it as it is because DB2 accepts date in internal format. You dont need to explicity do any conversion to it.

What is your database? I know in SQLServer you can use something like

Your inserted value is of length 12. The column is defined as char(30), so the database adds spaces to honor the length of the column. Thats why you are not able to select without using the 'like' operand.

In the filter command of the sequential file stage put the command


Or run a before job subroutine (Execsh) and combine the two files


Access the merged file in your sequential file stage for further manipulations.

I did something similar a while back. Check out thispost.

Ha Ha Ha. Good one Ken. Was just messing with ya

Are we invited

Dont change the delimiter if the file is delimited as a pipe, That reaquires a lot of work. Change the quote character to ". Dont put 000. See what happens.

I am not exactly sure. I do not have access to datastage at the moment. But it looked as if it was possible by row merger. I have never used that stage personally, just played around with it once.

Whats the delimiter you are specifiying for the file. The data must be containing the delimiter thats why you are getting this kind of warning. Whats the quote character that you have specified?