DSXchange

Hi Ray, As per Vinod the project is corrupted after importing to V7 from V6. Then there is a good Chance that V6 Import is Good. One other thing is say you have project X and it is been courrupted. ( At present client place smtimes the Jobs are not getting compiled & we can not open the Jobs in ...

If you have Backup of the project Just delete the project and and Re-import the Project fresh. In my past project when we had this problem we have deleted the Project and imported it again. It worked ( We did it in v6)
It might work for you

I ahve seen this problem at many clients ( Which is really not problem ) When you are Exporting the Jobs why don't you Export Executebles also with your Jobs there is Option you need to Check when you are exporting the Jobs By doing this you Don't need to Complie any Jobs or Routines when you have i...

There is One more simple Mechanisam for this check in your DataStage Director under Jobs Menu see if Cleanup Resources is Enabled ( If not enabled then you can't do. This can enabled in Adminstrator) if it is Eanabled click CleanUp Resources. Job Resources Window opens On the Top part you find your ...

Hi Steve
If it always if you date should previous day then I sugget you to convert your input date using Iconv as it will convert you date to internal format ( Integer Value ) you substract one from this and and do a Oconv in the Date format you would like to


Hope this will help

Thank you

Hi Guys, How can i use Oracle Sequences in Datastage jobs???? I am new to datastage. I would appreciate your help. Thanks Narasa Hi Narasa, You can either use the Oracle Sequence ( Sql Command ) when seleting the Data or Loading the Data Into Target tables. In both the cases you have use User Defin...

Can some one help VERY URGENT I'm trying to creat a report using REPORT ASSISTANT in Data Stage Manager By using this feature you can create a report with all the JOB names. We need to compare the JOBS are in sync on both production and development.I have used this feature in version 6 for Server Jo...

Hi, I am reading date values from Excel file(.csv) data in the mm/dd/yyyy,i used Sqquential file stage to read the data and i have to write this date into UDB DB2.here IConv and Oconv are not working as iam using Parallel jobs. I used Varchar data type in Sequential file stage. I used StringToDate ...

I have done this in my last project I need ed to send the REJECT FILE as an attachment to the user, The approach I have taken is created a script (IN UNIX) and append the file to the body of the message and send the email to the user Hope this might help but If your file is too large it might be not...