DSXchange

Thanks Ray.

As an interim solution using the execution mode as sequential to get the count.

Hi, Basically we need to insert data into sql server table with lock enable so that no sidu operation is allowed for other users. I have tried having isolation level to serializable, using hint as TABLOCKX but when the job is under execution in DataStage, I am able to select records from front end c...

Thanks Ray. Actually we are capturing the rowcount and the link names and display the stats on a front end. Though there are records from the link, it shows as 0 (for input & output link) in the modify stage which is incorrect. Basically we are dropping few columns and capturing the reject recor...

when viewed in Director (Monitor) the status for Modify stage/link shows "Unknown", is there any settings change required?

If the execution is seq. then the stauts shows as "Finished" as expected.

when viewed in Director (Monitor) the status for Modify stage/link shows "Unknown", is there any settings change required?

If the execution is seq. then the stauts shows as "Finished" as expected.

Hi, The modify stage is used to format the rejects from odbc stage and capture the records in a flat file. After execution of the job, when looked at the monitor to view the no. of records in each link, the primary and output links for the modify stage shows as 0 though the records are present in bo...

When you have jxl.jar it is not connected viz. ODBC, directly java input stage is used in parallel job.

Thanks

Try to have the null field value=''

Also, for seq. file, input tab - field defaults - null field value can be given as=''

Thanks

Also, for seq. file, input tab - field defaults - null field value can be given as=''

Thanks

Prakash, was the problem resolved. If so please let know what was done.

Thanks

The parameters which are passed are d1 and d2 and used as shown below. select ... from ... where ... AND e.added_datetime >#d1# AND e.added_datetime < #d2# It did not work. Now I am able to run successfully, the only thing which I had missed was the quotes ie. '#d1#' and '#d2#' Craig, thanks because...

Hi, I need to pass data values (as parameter) to sql in the odbc enterprise stage. SQL works fine if the where clause is hardcoded with dates as, select ... from ... where ... and d1 > '20081010' and d2 < '20081020' Is it parameter cannot be passed to an odbc stage? I tried passing as parameter, the...

In addition to previous post, if I remember correclty the input excel needs to have only 1 sheet.

Thanks

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...