DSXchange

I am using simple select like, SELECT 'SARASWATI' A FROM DUAL. Through server Job I am getting 'SARASWATI' after doing a View Data. Through Parallel Job, I am getting this error: "No rows were returned from the View Data server command. Would you like to view the command's output?" Even if...

Hi ALL,

I am not able to connect Oracle 11g through Datastage 7.5 PX Jobs, though I am able to do so using Server Jobs.

Please let me know if any settings need to be changed due to this.

I am not able to view data through the Oracle Enterprise Stage when I am doing so.

regards,
Saraswati

Hi, I have newly installed Datastage 8.1, imported the jobs from previous ds version 7.5. Most of the jobs ran OK. But i job showing an error, log just says "Unable to insert a record into the table. [oraUpsert.C:1851]". nothing more more is there in the log through which i can identify th...

Hi, We have just installed Datastage 8.1 version in new server. After installation we have imported the projects (server jobs mostly as of now) from current datastage 7.5 to new 8.1. When we tried to compile one jobs we recieve the following error. "stage type object ORAOCI8 not found". Pr...

The issue got resolve after adding the ser ip address in hosts file in the local system where client is installed.

Hi I have tried uninstall both Datastage 7.5 and 8.1 and reinstalling Datastage 8.1 only. BUT unfortunately now i started getting some DLL error stating "This application failed to start because DsEow.dll was not found. Re-Installing the application may fix this problem". I tried installin...

Are you using the same hostname and port that you specified during the install? Is port 2809 open through your firewall(s)? Mike Yes, all the ports are enabled. Is this because I have both Datastage 7.5 and Datastage 8.1 client insatll in my system? Probably port 2809 has been blocked by Datasateg ...

Hi,

I am trying to login using datastage dsadm user id. Before login i have given the access suite component (Datastage and Quality stage admin and user) access to this user through information server console. But still I get error.

Thanks

Hi, I have newly installed the IBM information server. After installation and configuration, whne I am trying to login into datastage client getting the following error. "Failed to authenticate the current user against the selected Domain You are attempting to connect to server [xxxxxxxx]. This...

Does the file contain just the date, or is there other information also in the file? There is a very recent Webinar (at www.dsxchange.net) on the very topic of processing data in files from job sequences. The file contains only the date. can u pls brief me how it can be done with user variable acti...

Hi,

Can anyone pls let me know how to extract the date value stored in the sequential file which is to be used as the parameter for the next job? Can it be achievable with routine and user variable activiy in the sequence job? If so can u pls brief on the routine?

Thanks
Saraswati

I have copied the first record to the last position.It is still aborting , being unable to extract the last record. The project has moved to a new Unix box recently and this is the first run , so no prior info is available in the new box.Both the logs are same until the termination happens. Can this...

Error Log:Abnormal termination of stage invEMEAInventorySnapshotStep2..sellable_xform detected sellable_xform is a transformer reading from a seq file having n record. Whenever the job is started it is aborting after reading n-1 records.I do not find anything unusual with the last record in the seq ...

yes. you are correct

env | grep NLS return nothing

If I run the dsenv file at DSHOME

couldn't set locale correctly
couldn't set locale correctly