DSXchange

Jennifer, Check out the FTP Data Port and FTP Data Connection Mode properties on the Outputs - Properties tabs. See the help relating to these. Ive experienced similar problems before and had to set one/both of these to achieve the result. Hope this helps. John Campbell Ascential Software -----Origi...

Hi all, I have a job like this _______ ______ ______ | | | | | | | Seq |--------->| TRX |--------------->| OCI | |______| |______| (1) |______| (2) _____ | | | Seq | |_____| I have a BCI routine that perform an insert into an ORACLE table (via ODBC) when an ORACLE REJECT (in link 1) is obtained. The...

platform : AIX 4.3 database : Oracle8.1.7 datastage: 4.3.2 due my project factors must use ODBC connect with Oracle, thus taste config in 1.$ODBC_HOME/odbc.ini such as: [oracle8] Drivers=/datastage/uv/branded_odbc/lib/VMor715.so ... ServerNames=TPASAIX-->oracle net service name ...-->userID ...-->pa...

We had similar problem before. When we updt datastage 3.6 to 4.1, also server from NT4.0 to MS2000, Our jobs related to FTP stage became unstable, often aborted at FTP stage. After finally ask Asential, we were told a temp fixing on this, under the property tab of FTP stage, change NUMBER OF TELNET ...

Hi All, I recently modified the default read-cache size of the Hash files through the administrator (tunables tab) to 10 MB from 128 MB. Now after this the hash files are always getting read cached (10 MB) even when the read cache is disabled for a hash file stage. Now this is not what I expected. H...

Hello All, I am executing a job through job control. THe job that was executing through the control job encountered an error. The error message encountered is LifeMasterJob.JobControl (fatal error from DSWaitForJob): Job control fatal error (-99) (DSGetJobInfo) Failed to open RT_CONFIG106 file. (DSW...

Sounds like something MetaStage would be able to do. ----- Original Message ----- From: "Robert Takkunen" To: Sent: Friday, May 10, 2002 2:51 PM Subject: How to find information on extracting process > Has anyone found a way to extract information on transformations of a field > so that the logic co...

Hi Ernie, im refferring to Job Control API that allows programmers to create and modify DataStage jobs without using the Designer. Thanks Riccardo ----- Original Message ----- From: To: Sent: Friday, March 08, 2002 7:13 PM Subject: RE: Job Control API > Hi Riccardo... > > Which API are you referring...

A dynamic array is a structure entirely within the DataStage BASIC environment. It can not be used to connect to a database by any means. I suspect you have not used the correct terminology. (I see from your address that you are in Taiwan, and probably English is not your first language.) What is it...

Hi All, I am coding a datastage dynamic array, which connects Oracle 8i. Can I use OCI 8 connection instead of ODBC, cos I am failed to get ODBC work on my AIX 4.3 machine. Thanks a lot. Best Regards, Spark ----------------------------------------------------------------- < ??? Yahoo!?? > www.yahoo....

Hi David, Yes that clears it up, thanks for your help. Cheers, Simon V -----Original Message----- From: David Barham [mailto:David.Barham@Anglocoal.com.au] Sent: Monday, March 11, 2002 1:31 PM To: datastage-users@oliver.com Subject: RE: limiting source selection by MAX value of target Simon, your or...

Hi David, Source database is Sybase 11.5 accessed by ODBC stage, target SQL Server 2000 also ODBC. You wrote... For example, if you are using ODBC to access the source system, you could read one row from the target (select max(created_date) from target_table) and use this to lookup the source system...

Simon, your original message stated: "get the MAX created date from the target table, and use that as selection criteria on the source table" I was assuming that your source table had a date that you could use for this selection. Was this an incorrect assumption? If you do have a date field on your ...

Simon, To answer your question, I still need to know what sort of databases you are using for data sources. If your data source is accessed via ODBC, then I provided an example. This will also work for reading UniVerse tables. There are also options which involve passing the date from one job to ano...

Thanks David, Thats very helpful indeed, and I will certainly develop a control table system as you recommend, but at the moment, I am still puzzled as to how I actually use the date I get from my select statement from the target database as a lookup. I have created a test job which gets me the crea...