DSXchange

Hi Chullet,

Do you mean sequential file stage will handle more than 1 file in a single job run?

craig

It is before "_" .

Hi All,

I need to pick two 0r more than two files for which file name starts with similar word say file 1 name : HFDC_0101.csv,HDFC_08082012.csv.

Can we able to process these two files in a single job run and load into the target table?

Hi Ray,

I need to pick the all the character before '-' in the string.

Hi All,

How to extract substring "settle" in the string XXX_Settle" using datastage functions?

Thanks for your valuable suggesions. You have provided the 3 variables wrt IBM Datastage 8.x perspective. But my question pertain to Datastage 7.5....for which paths will differ ... I am not looking for Java tution from you :) I am looking for an Java API which will be used as part of Batch Script.

Dear James,

There will be no ASB_NODE concept as part of Server version in datastage 7.5.

In such case ,what will the Java Home value with out ASB NODE HOME as in set JAVA_HOME=%ASB_NODE_HOME%\apps\jre.

Hi James, what are all the options will be there as part of %_JAVACMD% and what are the libraries needed to decrypt ascii files in windows. also do we have to pass the file name to the javacmd so that it trigger java class to decrypt the particular file. if it is the case how can pass the filename. ...

I am looking for a technical guidance not anything else

as you are experts ,you can help us...but you are not doing so...so bad

actually i cannot install the dukes code in my client network.
I need to do all the work for Datastage job parameters ,File parameters ,job status,job log,File Log all this information using Job Control and routines .

Your help is appreciated here.

Request you to help me.

Dear James

Server is on windows..so need to use batch script for this rather than shell script.

Can you please suggest any batch script where we can call java function..

Dear Chullet,

I am unable to see the contennts as premium memebership expired.

Please could you share me the code for the routines...

Hi Arndw/chullet


Can you please help me here in writing the routine.

Hi , First thing is i need to trigger the java class which is on datatsage server so that the decryption process will start using java class and encrypted file will be decrypted. Also this has to be done using the batch script in server jobs but not the parallel jobs. Can any one suggest me on this.

Dear All, I need to get the below datastage log information when ever i run the datastage job and store into oracle table. Job Name,Start Time,End Time,BatchNo,Message Type,Message detail information . I am new to Routines and please suggest the routine which will return the above information pertai...