DSXchange

One of the Px jobs fails reporting a fatal error : Parallel job reports failure (code -99). When do we get this error and what are the possible reasons? The job reads from a DB2, DB2 lookups and outputs to DB2.

Hi all, Thanks for your response. I tried with OPTIONS(DIRECT=FALSE,PARALLEL=TRUE) and OPTIONS(DIRECT=FALSE,PARALLEL=FALSE) as well. nothing worked out. I even tried with the Index rebuild/maintainence options, but no luck. I'm still getting the same error. Any help on this regard is greatly appreci...

Hi all, We have a Parallel job designed which takes data from a SEQ file & puts into ORACLE table. I used Write option as "LOAD" and "TRUNCATE". but it failed giving me the below error: main_program: Internal Error: (0):util/pathutils.C: 403: Unable to determine current worki...

first of all, is it possible to move Datastage Server installation folders from one machine to another? i think we need to install the Server again in the new UNIX machine. please correct me if i'm wrong.

Regards,
Dinesh

you may need to look into the free space available @ ORACLE end as well. because, if there is no free space available in DB side, then we might end up getting this error

Thanks & Regards,
Dinesh

sreekanth kutumbaka wrote:There is only one version in my Client machine , so when i connected to multi client manager by default it is showing installed version.

Hi all,

any luck on the above issue??? please help me out in solving this issue.

There is only one version in my Client machine , so when i connected to multi client manager by default it is showing installed version.

Hi..... Greeting to everyone. We are facing the below issue in Websphere 8.1 version. We are trying to connect to datastage designer from client machine but we are getting the following error. All required ports are open from client machine but still we are facing the same error. Is there any soluti...

The Information Server crashes while trying to login. Following is the Error log which we get:- Failed to authenticate the current user against the selected Domain CORBA MARSHAL 0x4942f89a No; nested exception is: org.omg.CORBA.MARSHAL: Trace from server: 1198777258 at host mx.mediaqa.nbcuni.ge.com...

By using MCP function you can remove BOX character , Following is the convert function . Function to Convert :Convert(".", "", Oconv(InLink.TheString, "MCP")) Note : But don't use this function to convert amount (i.e 2500.00). for the amount data use database level filt...

Hi , I am reading data from Oracle table and the table contains the CLOB data type information.As per the requirement I have to store that data in the HASH file. For reading this CLOB data in Datastage we are using the following function DBMS_LOB.SUBSTR(<COLUMN_NMAE>, 4000,1) and the Datatype as VAR...

Hi, Thanks for you reply. Our requirement is to pass those parameter (#PS_START_DT#,#PS_END_DT#) dynamically by reading from the database during run time. ------------------------------------------------------------------------------------ SELECT FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELD5 FROM F0005 ...

Hi, I facing performance problem while extracting the data from DB2/400 using datastage ODBC connection. ----- Enviorment -- ------------- Source System JD Edwards (ERP APPLICATION) OS: AS/400 DB: DB2/400 ---------------------------------------------- Target Database: Oracle 9i ---------------------...

I'm trying to assess Ascertain DataStage's ability to connect to JD Edwards and extract data. As I have no background with Ascertain, I'd appreciate if someone can share what they know about the same.

i want to design a mapping for corrency conversion based on a date. the following are the inputs. Note: assume TOdays doller rate Rs 47. Date| From currency| tocurrency| amount to be converted 2006/07/10| Rupee Rs| US $ | 1000 here my issue is how to convert indian rupee to US $ and $ is varying eve...