DSXchange

Thank you for your feedback. Re-indexing the projects resolved the problem

hi, We had to rebuild our server due to a failure. Fortunately, our project directory was on a different drive letter and was not impacted by the failure. Would anyone know how to rebuild your project from the project directory? We do not have any .dsx files available Please can anyone help us on th...

Hi There!

We have managed to resolve the problem by uninstalling and re-installing both server and client on the development server. Thanx to everyone for their valuable input

Thank you to everyone for their replies in this most troubled stage of my very brief datastage career (switching from MS DTS to DataStage recently I still think it is a phenomenal ETL Tool, I am just losing my confidence in it ever so slightly).... Herewith, a summary of what was done since I have l...

thanks man

Hi there! I am no expert, but suggest that you try "massaging" the data slightly. Try something like fix(trim(yourcolumn),15,2)...

Once again, thank you to everyone for the replies. I have logged a call with Sybase SA support for some technical assistance as well. Few things: a) The icons are not misbehaving (thanx Denzel for that one). It simply looks like a FTP plugin, but is not. It basically is a universal icon for when Dat...

Alternatively, you may consider a full outer join. An inner join will provide only records that match, a left join will provide all records in the left table and matching records in the right table, a right join will provide all records in the right table and matching records in the left table. A fu...

Thanks so much.

Note that on float values, if you do a direct compare on the data types, there may be problems. Not quite sure why, but even the datastage consultants here strongly advise against the use of float values within datastage.

Any specific technical reason behind this?

Hi Roy, It is not really that it is weird icons. Its more like that the icons are behaving very funny. (i.e. an ODBC bulk loader is now seen as an FTP stage, and the FTP stage is greyed out). This is happening on 3 different clients that I have tried, one with Windows XP, and 2 with Windows 2000 (no...

Yep, I can create and delete projects using administrator client. Note that I am using the omit option when logging on to the client. If you look at some of the postings, the whole cataloging problem was experienced previously, and some people advised to disable the Omit, whereas some people advised...

thanks Ken. Maynnn, this is gonna be a bumpy ride with loads of learnings...

Ken, Dude, I am really new to DSExchange and datastage in general so plze be patient... Referring back to where you mentioned that performance would be roughly the same using an Oracle ODBC stage, would the same be said in the case of SQL (would it be faster to use on a SQL ODBC stage than a generic...

Really easy once you get used to it.... Select a.Count as FIRST, b.TOTALCALC as Second from (SELECT COUNT(*) COUNT FROM RNKT0.ATTENDANCE ATTENDANCE WHERE ATTENDANCE.CUSTOMER_ID = :1 ) a, (select count(distinct(CLUB_ID)) TOTALC FROM RNKT0.ATTENDANCE ATTENDANCE WHERE ATTENDANCE.CUSTOMER_ID = :1) b

Bingo! My computer is running on XP, whereas the servers are both running (I think) on Windows 2000 server edition. When I perform the export, it is done on the server. However, when doing the import, I am running off my box. Where do I get the patch? Other funny that I have noticed which is due to ...