DSXchange

Hi, To read a excel file from DataStage you can use the jxl.jar (you need to download) and the class used is ExcelRead in it in Stage -> Properties: 1. Java additional classpath - /<path>/jxl.jar 2. Transformer class name - ExcelRead 3. User's custom properties is to be as, File=<path>/<filename> Sh...

Hi, I am also facing Oracle (Enterprise stage) connectivity issues in DataStage 8.0.1. OS is Redhat Linux 4 and Oracle client is installed in 32 bit and Oracle database is on 64 bit Solaris. As mentioned I have also created the link ln -s $ORACLE_HOME/lib/libclntsh.so.10.1 $ORACLE_HOME/lib/libclntsh...

Thanks all, I have to go back to the service provider.

Friends, By using Oracle enterprise stage as input and read method as user defined query, I get the following error. main_program: Fatal Error: getRealTable: missing name [orautils.C:4330] The Oracle EE stage works fine if read method is table only. The design is, <ora> -> <seq. file> The following ...

Hi samala, and if you can prevent the loading of Excel-Files: DO IT. Excel is such a good and flexible calculation tool, that you need a 100 % dicipline from your users. If you only have 99.9999999999999999 % you are lost, errors will occur and don't blame DataStage for that, it is the excel nature...

Hi,

For me the input source is an excel file. How can I read that xls file in a job?

Can anyone please help?

Thanks

Hi,

Can anybody help me to FTP and flat file available in Unix server to mainframe as PS file in Parallel extender.

How to FTP the file?

Thanks for your time.

Thanks all for your help and time.

Now I used stage variable in transformer to start from -6 and continue in increasing order.

Thanks,
Satish

Hi All, How to add a column with increasing -ve values? Eg. given below. I have a flat file (input) with rows like, 12345,'check',100,1,1 23235,'testing',250,5,7 for which I require (output) like this, -6,12345,'check',100,1,1 -7,23235,'testing',250,5,7 etc. However the first column should go increa...