DSXchange

Eric,

Thank you very much for providing the solution.

Thanks
Vineet

Sam,
The requirements are such that we have to implement this logic.I am not driving the requirements, just implementing them.

Craig,
Could you please provide some pointers on how to do it?

Thanks
Vineet Singh

Thanks Ray.

So I know how to get the first and populate 'Null' in it.
How should I really go about populating the second record with the amount from first record and so on?

How to identify the first record where the amount has to be populated as 'Null'.

Hi, I am trying to implement the following scenario which came up as part of our recent requirements. I have stated the logic below. We have a Product table which has with Product and Amount as it's attributes. Product ID Amount FX123 100 Ab234 200 XZ567 300 SD234 400 As per the logic we have to com...

Every job will have a unique process id associated with it.Please log on to the unix box and see the process id's against the User. Then you can kill the corresponding process id's.

Thanks
Vineet

Here go with the exact Warning message from the log : DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO sbc_nform_DS_db.SBCdbo.PS_TNT_GTR_MID_MM(FI_INSTRUMENT_ID, ASOF_DT, PF_SYSTEM_CODE, DEPTID, CUST_ID, PRODUCT_ID, CURRENCY_CD, BASE_CURRENCY, SRC_SYS_ID, TRANSACTION_DT, FI_COMMITMENT...

I checked that we are not violating any unique constraint.

We are trying to push data from Oracle Database to SQL Server. I have a couple of jobs. Some jobs run fine but some are behaving very weird. I am using Dynamic RDMS stage to read data from Oracle and ODBC stage to write into SQL Server. Couple of jobs run fine when Array Size is tweaked(Default is s...

Ray/Chulett,

Kill -9 should be last option to kill the job.

Ray,

This is what happened with me during one of the job executions. I resolved it by tweaking the array size. I don't know whether this will enlighten your thoughts or not .

You can maintain a backup by exporting the Datastage jobs( Entire Project or Folder wise) in .DSX format through Datastage Manager. I hope it helps.

Oconv(Iconv(ASOF_DT[1,10] ,"D-YMD[4,2,2]"),"DQ")

Could you please specify which Datastage Version you are using. The SAS plugin satge is available in Datastage Parallel edition. We don't have the option of SAS plugin in Datastage Server Edition.

I got the same issue for one of my ETL jobs. After analysis I tweaked the array size used in the target OCI stage. Just try reducing the array size. It worked for my job. I hope it helps.