DSXchange

Use the Str function for the derivation of the output column as -

Str("0", 8 - Len(inputcolumn)) : inputcolumn

As mentioned by Phil, quitting the client and reconnecting should resolve the issue but also make sure that you are not running out of memory on the box.

See the special configuration advice for Windows 2008 and 64 Bit systems - The DataStage job stages are 32 bit on both Windows 32 bit and Windows 64 bit installations. Consequently, all client libraries needed for connectivity (for example Oracle client support) must be 32 bit.

Hope this helps!

Here is the URL for the end of support dates DataStage 7.5.1A - April 30, 2012 Announcement letter: http://www-01.ibm.com/software/data/integration/service-news/end- of-service-2012-04.html DataStage 7.5.2 and 7.5.3 - April 30, 2013 Announcement letter: http://www- 01.ibm.com/common/ssi/ShowDoc.jsp?...

Thanks Ray.

Yes I did try to connect through Unidata stage and get the following error.

DB_NJS_LOG_Ext_Fr_Unidata..DB_NJS_LOG.DB_NJS_LOG_Ext: ds_udtopen() Unable to execute file SELECT - 30105 - UDT error

DB_NJS_LOG_Ext_Fr_Unidata..DB_NJS_LOG.DB_NJS_LOG_Ext: DSD.UDTOpen GCI $DS.UDTOpen error 24.

We are using datastage v7.5.2 Server edition on Windows 2000. Currently, our source database is Unidata6.0 and target is Oracle 9i. We are in process of refreshing our infrastructure. As a first step, we will be upgrading the source system as follows Current Environment New Environment Hardware M80 ...