DSXchange

That works. I defined this kind of columns as VarChar and manipulated the data within transformer basing on whether I have '+' sign or '-' sign.

Good Luck,

Aruna.

I can give an answer for one of your questions.

You can monitor the Column Analysis jobs in Director Client in ANALYZERPROJECT.

Somewhere the schema became incompatible with data. Make sure your output schema has all the columns you are trying to map. Just a manual comparison of data with fields in the output column should help you. Because usually formatting arrays is simple with CFF stage. Usually it is the Comp fields map...

As you are working on version 8, you can use Complex Flat File Stage to read VSAM data from Mainframe. There should be couple of posts ( I created one of those ) that explain how to do this. If you have federation server you can directly connect to VSAM files from DataStage. Otherwise you have to co...

May be you already got this resolved but just in case... yes you can connect to Mainframe DB2 tables by using ODBC connection.

For fixing the security mechanism error please try adding 'SecurityMechanism=1' in your .odbc.ini file. We had same issue which was ressolved after adding this to odbc.ini file. [IADB] QEWSD=39695 Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMdb222.so Description=DataDirect DB2 Wire Pr...

The conversion function should not have hyphens as your data doesn't have it.

StringToDate(ln_TTS_DelvyDate_in.pu_date,"%dd%mm%yy")

should work.

I am not sure whether it is a good idea or not ... but if I want to suppress a warning I will right click on the warning in the job log and select add rule to message handler option and supress it from there.

I am not sure whether it is a good idea or not ... but if I want to suppress a warning I will right click on the warning in the job log and select add rule to message handler option and supress it from there.

Good Luck with getting Netezza Enterprise stage working. That is a challenge as we don't seem to find too many people with Netezza / DataStage experience.

Good Luck with getting Netezza Enterprise stage working. That is a challenge as we don't seem to find too many people with Netezza / DataStage experience.

Check and see what kind of errors you are getting in iashandler.log. You can find these logs in '/usr/WebSphere/AppServer/profiles/default' directory. Also you can check for any errors in Client directory 'C:\IBM\InformationServer\Clients\ISC'. Either of these logs should tell you what is the exact ...

Yes. The column analysis jobs do tend to run for several hours depending on the volume of data and number of fields. But instead of killing your job, you can check the status of the column analysis jobs on Director by selecting 'ANALYZERPROJECT' project. By checking the status of column analysis job...

I don't think getting a reply for this post should be the sole reason for you to become premium member as there are several other benefits you can derive being a premium member. But here is what I think you may be missing. You need to have a soft link odbc.ini in your $DSHOME that points to .odbc.in...

Check whether you ran out of space in repository.