DSXchange

Difference between Hashfile and Sequential File

Hi ,

I have a records like HYD_MSC14_VTTF1988.data but i need only HYD_MSC14 portion whereas _VTTF1988.data portion is same for all records .

Kindly help me

This records are not fixed length and all records are different and USG12320090403145343 records are fixed with NES2_Erc string [ Only applicable for this records ] . I am given you another records like USG10420090515091147HYD_MSS3_VTTF9741.data . Kindly help me . Do you have all the source records ...

Hi ,

I have a source records like
USG12320090403145343NES2_Erc_VTTF2972.data but i need only
NES2_Erc portion . so kindly help me

hi, I have a source records which are not fixed length.I am giving some examples as mentioned below : 1. 0012345 2. 072945 3. 001239567 4. 1234576 5. 0007992345 But i need only those records except 0 [ removing all 0 from the preciding position ] means output will be like as follows . 1. 12345 2. 72...

Hi ,

I have a record like
1/14/2009 1:09:50 PM and 1/14/2009 1:09:50 AM and i am getting this record from the source level.so i want to convert this record like as below mentioned

2009-01-14 13:09:50 [ 1/14/2009 1:09:50 PM ]
2009-01-14 1:09:50

Kindly help me .

Hi ,

As far your requirement , you have to select client instance name in the db2 enterprise stage as well as other require properties . Same thing you have to implement in the other db2 enterprise stage but client instance name should be different as you mentioned .

Hi , I have found below mentioned error while i was trying to connect to the database through DB2 Enterprise stage in the parallel jobs . Error Details are given below : =================== ##E TNDB 000000 13:56:06(012) <DIM_ACC_PRICE_PLAN_WLESS_3> Error Idx = 1; DB2 Driver Embedded SQL message: SQL...

Hi, We have four Datastage Server installed on AIX platform. In all the servers RPC daemons are dying automatically at a very regular interval. Though there is no particular frequency at which this is happening but daemons are getting down at 10 days interval approximately. This is for your informat...

Hi Friend , Would like to inform you that , we are using DB2 9.1.9 version and DataStage 7.5 for our project . Befor it was DB2 8.4 version and DB2 Instance Name like : db2inst1 but right now we have changed that Client Instance Name like : db2inst4 in our Development Server for Datastage and DB2 le...

Hi, I ran a job earlier it work fine. Now I ran the same job but it got struck. It locked the DB2 table as well as job. This is my key job based on which all other jobs are dependents. Can any body tell me how can I Kill it. I want to kill it. But I didn't get the proper PID for this. Can you tell ...

Hi.. Thank you very much for your solution. But am confused, how can we do left outer join using transformer stage?? Do we need to check for Isnull c ... .. Hi Friends , With reference to your concern , For left/Right Outer Join is not possible through Transformation Stage because this stage is act...

PX is usually quite graceful in how it degrades from using memory to disk. Could you post your exact error - it is likely that you ran out of disk space and not memory. ... . The exact error is given below and do the needful from your end . ----------------------------------------------------------...

Hi Friends, Regarding Heap memory size issue while Datastage jobs got aborted due to as their having not enough haep memory size for propagate those large amount of records from one datasets to another datasets/filesets and their having two lookup table through which we can get particular data as pe...

The error message is /home1/dsadm/Ascential/DataStage/PXEngine/etc/standalone.sh: not found. Please verify that this file exists and is executable. ... Hi Friend , As far your concerned , I will suggest you that kindly cross check the Database Installation Directory and verify and executed DB node ...