DSXchange

The solution given by Senthilmp can be used in parallel jobs too. I have a similar parallel job.

Did you checked with IBM as to how to install 64 bit and what are the steps for proper install ? I got a very good support from IBM and they guided me before the install to get proper downloads and fixpacks and during the install whenever I had any issues. So far my experience on 64 bit SuSe Linux i...

I am trying to find the link statistics from a particular link in a Job. I am using a parallel routine to get the link statistics but getting the following error : Update_Audit: Failed to load the library "V0S128_RXDWW06L_RouTest_Update_Audit.so"; either the directory containing the librar...

Hi Dana, I was using Date and not Timestamp but I am sure you can use the same logic for Timestamp too. In a prior transformer stage I used AsInteger(Convert("-","", DateToString(Date,"%yyyy-%mm-%dd"))) to convert Date to integer and after the Aggregator stage reconvert...

This is what I did for getting Maximun date in an Aggregator Stage :

Converted the date to an Integer.

Used Maximum Value Output Column option.

Converted the Integer back to date.

Regards,

Aruna.

Did you tried inserting a transformer stage in between CFF and Oracle stages to manipulate the fields with Spaces ?

If the Mainframe file has spaces in a field it is not a null value unless you define it so.

Are you sure you have spaces in the mainframe file and not Low Values ?

You can use a single job if you have Federation Server.

Other option is FTP the Mainframe file through JCL to unix server and use Complex Flat File Stage to read this file.

I am currently using option 2 for my jobs as we don't have Federation Server.

Good Luck,

Aruna.

You can use a single job if you have Federation Server.

Other option is FTP the Mainframe file through JCL to unix server and use Complex Flat File Stage to read this file.

I am currently using option 2 for my jobs as we don't have Federation Server.

Good Luck,

Aruna.

After installing DB2 and WAS 64 bit with patches and fixpacks did you installed 32 bit packages in Linux box ? I am giving the list of packages just in case... Package Name: glibc-2.4-31.2 xorg-x11-libs-6.9.0-50.14 libstdc++-4.1.0-28.4 libstdc++-devel-4.1.0-28.4 compat-libstdc++-5.0.7-22.2 Other tha...

Did you tried connecting to Netezza through example ? Try connecting using example script within /opt/IBM/InformationServer/Server/branded_odbc. Last time I got this error I didn't had a soft link to .odbc.ini in $DSHOME. For example: ls -l odbc.ini lrwxrwxrwx 1 dsadm dsadm 11 Jun 8 2006 odbc.ini ->...

What exactly is the trouble you are having during install ?

Regards,

Aruna.

Hi Keith, We installed version 8.0.1 on SuSe Linux 32 bit and currently finishing the development. As per Production standards we are in the process of migrating to 64 bit version and having some issues during the install and migration process. Is there anything special you did to compile the jobs p...

Have you checked to see whether your job has Runtime column propagation enabled. I had the same issue that got resolved after I disabled the RCP.

Good Luck,

Aruna.

Did you tried using combination of substring and Concatenation and arrive at your own conversion logic ?

Hi ArndW,

I am not sure whether Biswajit got this issue resolved. But, I got the exact same error and your suggestion worked.

Thanks,

Aruna.