Thanks all.  I've got it...

DUH!!

Thanks

I have used both Cognos Decisionstream and DTS to access the iSeries and create datamarts.  Using scripting and the datapump you can do just about anything you need to do...

That fixed it,

Thanks very much.

I am familiar with lookups.  However, I need to customize the SQL for parameters that the ODBC driver will not accept as drivers.  I cannot get this to work.  I...

I need a second connection to read a different table than that being read as the input to the transformation.

Got it --

Thanks very much.

Thanks for the reply.  Yes both tables are in the same database.

I haven't ever built sql statements to accomplish this, can you supply an example?

Thanks again

Thanks - using the cmd approach works for the JAVA as well.  I actually ended up using the file system object to do the delete in order to have some...

I believe that the only way is to create an activx transformation.  Select only the output column.

Then in the code assign the output column to the value of the...

There is more than one debugger available depending upon your OS.  In A

THank you - I sure missed that.

I found that I could modify the lengths with a Dynamic properties task.

Thanks

Thanks to all for the responses.  It turns out that I had a dumb error, I had a typo in the lookup name.  The code as posted works fine.

That is great. 

Thanks very much.