DSXchange

[quote="ruchikabareja"]Hi, Please let me know if you have any pointers to the following:- - Benefits/Disadvantages of using Linux over Unix for Datastage Server - Datastage Performance on a Linux Server v/s Unix Server - Any Issues involved with the migration of a Datastage application fro...

Beware of the gotcha on Solaris 10, you need to apply the latest software patches for the OS Kernel and other stuff for Solaris before migrating your DataStage Server. :D

[quote="asorrell"]This is a problem with some Server jobs that are created on the EE version of DataStage (version 7.5.1.a) with DB2 8.2.2 on AIX. What is happening is that we aren't getting any reject rows from the DB2 table inserts on AIX. We've also checked all of the error codes and th...

[quote="manteena"]Hi all, I am getting the following error while openning the DRS stage. J_Stage_PS_BANK_CD_TBL..DRS_SRC_PS_BANK_CD_TBL: J_Stage_PS_BANK_CD_TBL..DRS_SRC_PS_BANK_CD_TBL.DSLink1: DSP.Open GCI $DSP.Open error -100. Is any client patch that I need to install? only my client mac...

[quote="itcconsulting"]Within the designer, I am able to open all of the available plugins except the DRS plugin. When I attempt to open it the application freezes. This is the first occurance of this and I have been using the application on the same machine for 6-8 months. I have rebooted...

[quote="kcbland"]You have to make sure you have the version of 7.1 that has the 64bit capabilities for Sequential and CFF stages. I have a customer who uses RedHat and required patches to get it to work after logging GTARS with tech support. I imagine that's in the 7.5 product by now.[/quo...

[quote="Pavan_Yelugula"]hi All Can you tell me which one of two is faster the hash file look up of server or the join stage of parallel extender. Consider that i do the hash file look up on my server canvas put it in a shared container and execute on parallel extender will this make my job...

I just wondering if anybody around has done installation and development projects on a RedHat ES server. Are there issue like file limitation greater than 3GB on hash and sequential text files. Based on my experiences with Windoze environment, I usually get the famous Blue screen and dll errror mess...

I don't mind paying a certain token to support administrative cost of maintaining a website like this, but for People looking for talent or headhunter they should pay a certain fee, not to get a free ride. But [color=darkred]People[/color] who benefit from this [color=blue]freebie advice [/color]sho...

You can skin a cat with different solution, my advise use datastage built in function called compare previous row functions. [quote="Abhinav"]Hi all, I have source file with the values as follows. each row has one of its column as row no 1 2 3 3 3 4 5 I am using stage variables to capture ...

[quote="srinu_p"]Hi,

what purposes do we use stored procedures and functions in Data Stage in real time?
can we use them to load data from various source systems into staging area?

SP.[/quote]

The use of SP depends on your need and your design methodologies of DS jobs.

[quote="ksmurthys"]Hi All, I was trying to load AS/400 DD2 date(YYYY-MM-DD) to SQLSERVER Database(Datetime) i am getting datetime overfolw error eventhough i used Oconv(Iconv,"D-YMD[4,2,2]),"D-YMD[4,2,2]"). ANy help... Thanks, Ram.[/quote] Windoze EBCDIC conversion table has...

[quote="Maharaj"]Hi To load huge volume of data , kindly suggest the preferred stage 1) DB2-Load 2) DB2-Enterprise Stage (Load method) Thanx Maharaj[/quote] How big is your data in terms of rows not the native files systems?. Do not use DataStage DB2 Plug-ins and Loader , they are very slo...

[quote="willpeng"]Can anyone enlighten me on why would I want to use a DS transform instead of DS routine? Since I am calling the rountine from the transform as well? My limited understanding is that using it as just rountine will degrade performance, but anyone can tell me why? Willy[/quo...

[quote="raju711001"]I need to call a Oracle Stored Procedure that accepts input from Datastage and returns values back to the Datastage job. I have come accross lot of stuff about this in this forum and nowere it's mentioned clearly how it works. Can someone please give me a clear picture ...