DSXchange

Alexandre, Metastage 2.1 and 2.2 did not support NLS, while Metastage 2.3 - out since 18th March - does. Using NLS-enabled MetaStage and MetaBrokers you can process data in a wide-variety of languages, and display data in any character set into MetaStage fields. The MetaStage and MetaBroker interfac...

Thanks for reply, Ray. I wish I could to use and suggest MetaStage to our customers. Unfortunately all versions (2.1, 2.2) of MetaStage we have tested have problems with Russian characters and some other problems. This product is rather "raw" I think and our customer wouldnt pay for it not only doll...

Hi, When I read through document(PDF file) for UDB plug in, I should have INPDATA.DAT, CMD.CLP & ULOAD.bat files in the Directory for Data and Command Files. Is it NT directory or Unix directory? Thanks & Regards Saravanan "John Campbell" cc: Subject: RE: UDBLoad for DB2 02-Apr-2002 04:24 PM Please ...

Thanks, David Barham For the to-the-point answer, and explanations you provided. As you say it seems that some sort of user interaction is expected ... the email.exe or a "start" command work perfectly when we run them at a command prompt, but when we try to run them through the DataStage Server the...

Hi, Thanks for your email. How do i set up db2connect on the datastage server. Regards Saravanan "Hendrik Kotze" cc: Subject: RE: UDBLoad for DB2 02-Apr-2002 04:01 AM Please respond to datastage-users Sender Info: No Sender Info found in the address Book Hi You have to setup db2connect on the datast...

It certainly is, but this is an issue that you may need to resolve with your IBM support rep. The UDBLoad stage simpley invokes the UDB LOAD procedure. Once you can effect that from the OS, then the DataStage plugin will work. If you cant, then it wont. The env settings seem to depend on what kind o...

I am the UK Ascential Software person, and I offer this advice for good reason. If you want to test it out for yourself, do the following: 1. Create a routine (say F1) that simply contains the code (Ans = 1) & compile it 2. Create a transform (say T1) with an expression of 1 3. Create a Job: 3.1.1 I...

Hi We are experiencing a strange error in our programs whenever we have a unique key violation. The job aborts with the first error row (# errors set to 50) message: ORA-00001: unique constraint (STG.SYS_C0013760) violated Abnormal termination of stage ABCDSTAGE detected The job doesnt write to an e...

Spot on Ray, thanks a lot. -----Original Message----- From: Raymond Wurlod [mailto:wurlodr@au1.ibm.com] Sent: Tuesday, April 02, 2002 1:08 PM To: datastage-users@oliver.com Subject: Re: Missing data in hash file Have a look at the column properties on the link where you are reading from the hashed f...

Have a look at the column properties on the link where you are reading from the hashed file. The Position (field number) must be the same as in the stage that wrote to the hashed file, presumably 0 and 1. Its my guess that these arent properly set. Ray Wurlod Trainer, Asia-Pacific region IBM Informi...

Hello all, Im running datastage 4.1 on windows 2000. My problem is as follows: I have a job which creates a hash file with 2 columns, the key column and a data column. This works fine, I check the contents of the hash file after running the job and it contains key values and corresponding data for a...

Great... I think you made the point that is doesnt really matter. In your example, you are comparing 10 million iterations on a laptop and only got a less than 6 minute difference. This works out to roughly 70 millionths of a second per call. Intuitively, I wouldnt argue with your numbers, they seem...

A more detailed explaination, but I feel we are close .. The main input is from a sequential file with a START_DATE and END_DATE in the file. I have to use this START_DATE and END_DATE in an ODBC stage look up to select the appropriate reference record, the SQL looking something like where Client_ke...

DataStage tables are ALREADY UniVerse tables, so no conversion is required. However, they are incompletely defined (deliberately), so only the first five or so columns are visible. Some of the structures are described in header files (for example RT_CONFIG.H) in the DSINCLUDE directory; others are n...

Hi You have to setup db2connect on the datastage server to connect to the db2 database and then install the udb package -----Original Message----- From: Saravanan_Thirugnanam@singaporeair.com.sg [mailto:Saravanan_Thirugnanam@singaporeair.com.sg] Sent: 01 April 2002 05:50 To: datastage-users@oliver.c...