DSXchange

Adjusting DataStage heap space may allow you to sort larger files.

The configuration is complete. Jobs running ok:

Tips:

a) Define dssaphome in dsenv
b) Copy both librfc.a and librfccm.o to the Dsengine/lib
c) Stop and Start datastage engine.
d) Use RFC ping available in RFC download from SAP to check connectivity between datastage and SAP.

Hi kcbland,

I added and t1.dt_id > 1721424 to the select clause but while viewing the data it gives message data source in empty.

Thanks
Prakash

Thanks kcbland for the suggestion but I am unable to run the query with t1.dt_id > 1721424 as the table contains more than 3.5 billion records and the Teradata box throws me out with insufficient spool space error. If I could get the equivalent Julian date for '2004-07-31' and '2005-07-31' then I ca...

I am getting the following error while extracting data from Teradata. Srvc_Lvl_Prod__Srvc_vi_Add__Prod_Rltnsh_Ref,0: Invalid date value in setOutputFieldAsDate() for field '5' in output dataset '0'. Date cannot be later than 9999-12-31 or earlier than 0001-01-03. Julian days value = 1721047. The job...

Hi Friends, Is there anyone who could kindly enlighten me between the basic differences between File Sets, Data Sets and a normal Sequential file? I was extracting some data into sequential files and the job failed with error message file full. I replace the sequential file by a file set but the job...

Thanks Bcarlson for your hint I changed the SQL to user defined SQL and used the following SQL code SELECT Ownsp_Cd, CIDN, Cstr_First_Nm, Cstr_Last_Nm, Src_Sys_Nm, (CASE WHEN Cstr_Dt_Of_Bth = '0001-01-01' THEN NULL ELSE Cstr_Dt_Of_Bth END) As Cstr_Dt_Of_Bth FROM rtwpr_tdw_vm.lu_cstr It worked ok and...

Contacted for Support and following were the responses from Ascential. Sent: Wednesday, 06 July 2005 3:49 AM To: Soumya, Prakash Subject: RE: Case No - 438605*AUA Hi Prakash Sorry for the incorrect information but I've just been told that SAS 9.1 support will be added in our next major release sched...

Checked the Job Monitor log but there are no recent entries in the log.

There are no messages to state JobMonApp is not running.

Any idea what the folowing phantom error is ? I am using Datastage 7.5 EE on Linux. Contents of phantom output file => DataStage Job 298 Phantom 10819 writeSocket() returned 39 Program "DSD.OshMonitor": Line 322, Variable "finished" previously undefined. Zero used. writeSocket() ...

Thanks Ray.

I have problem with both Server and Parallel jobs.

Apart from the above four steps is there any further steps I am missing ?

Thanks Ray.

I have problem with both Server and Parallel jobs.

Apart from the above four steps is there any further steps I am missing ?

We are configuring Datastage v7.5 EE on RH Linux for Oracle 9i. I have taken the following steps to configure. 1) Updated uvodbc.config available in the project library with the following codes. <Ruttora> DBMSTYPE = ODBC 2) Removed all the comments from odbc.ini available in branded_odbc and added t...

We are configuring Datastage v7.5 EE on RH Linux for Oracle 9i. I have taken the following steps to configure. 1) Updated uvodbc.config available in the project library with the following codes. <Ruttora> DBMSTYPE = ODBC 2) Removed all the comments from odbc.ini available in branded_odbc and added t...

This is the error we get when trying to export a file to a SAS dataset (we are running under Linux). If anyone can let us know what the problem is it would be much appreciated.

"APT_SAS_Export: Error when checking composite operator: sasdataset diskpool is not currently defined."