DSXchange

Thanks David, It was quite of trivial issue of our starting testing jobs at the same time as the db schema was being laid out. Once the tables were partitioned and indexed, load is beautifully fast. Regds, Vivek Pandey Consultant - Business Intelligence Sonata Software Ltd. Bangalore - India > -----...

What operating system are you running on? The original name is 42 characters, the truncated name is 41 characters. 41 characters is the maximum length that a UniVerse type 1 file keys can be. The problem can be alleviated by changing all the RT_BPnn files from Type 1 to Type 19. The best way to do t...

Yes, Phil, we have DataStage 4.1.1 (same version of OCI plug-in) working fine on Windows 2000 with Oracle 8.1.7 on the same server. What are your symptoms or error messages? David Barham Information Technology Consultant InformAtect Pty Ltd Brisbane, Australia e-mail: david@barham.hm -----Original M...

We have DS 4.1 and Oracle 8.1.7 installed on the same box (Windows 2000), I am having problems getting the OCI stage to work, which I believe, is because it is valid for 8.1.6. Has anyone got this working, and if so how?

Phil.

Thanks, Ray, I look at it and see if this is the issue. Regards, W. David Daugherty Pilgrims Pride Corporation (903) 855-4397 Voice (903) 855-4133 Fax -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: Thursday, July 05, 2001 5:45 PM To: datastage-users@oliver.com Sub...

Hello. When Im trying to validate a job, it gives me the following error: Abnormal termination of stage VGUpdateBenefits.tfBenefits_NoRejects detected DataStage Job 673 Phantom 428 File name "JOB.1446630359.DT.1224152041.V0S101.IDENT1" too long. Truncated to "JOB.1446630359.DT.1224152041.V0S101.IDEN...

Hello,

use for the LookupTable an ODBC-Stage and set in the Transformer for the Lookup the Link Property "Refernce link with mult row result set"

regards

Udo

Hi all, I have the following problem with merging a file and a table: -File Description: (number, duration) 1|1000 1|1100 2|2000 -Table Description: (number, type) 1|A1 1|A2 1|A3 2|B1 I use a Sequential File, a Transformer, and an Oraci8, and in the transfomer i join by number, and the result is: 1|...

Hi! I use a delete statement in an ODBC stage with user-defined SQL. The job compilation and validation are OK. At runtime I get this error: TEST2LoadVehEvntDts.VehHist_To_VehEvntDtsInsOrUpd.In_VehEvntDtsIns: DSD.BCIPut call to SQLExecute failed. SQL statement:DELETE FROM WRK.T_VEHICLE_EVNT_DTS WHER...

Thanks Ray, David, about the problem with Datastage 4.1 on NT4.0, ive found a solution working together with DBA Oracle. (Was a oracle user problem) Thanks again Regars, Riccardo Tani Staff Consultant Direzione Industria e Servizi Datamat, Enabling Your Future Rome, Italy e-mail: rtani@datamat.it --...

Dont blindly believe the claimed rows per second in monitor. They dont take into account the startup time for the stage. If for example, if your Oracle input involves a query (for example a sort or group by) that must do significant processing before returning the first row, DataStage does not consi...

Hi all, I have a datawarehouse on Oracle 8.1.6 (on Digital Unix) which im loading using Ardent Datastage 4.1 on NT Server 4.0 I do this using the ORAOCI8 Plugin of DS. So my target is always the ORAOCI8 stage. Now heres the problem. If my source too is Oracle ( the same db or any other db, again usi...

Is it just one particular table that you have a problem with, or all tables?

If just one or a few, can you post the table create script? (So I can recreate it and play with it.)

SQL_SUCCESS_WITH_INFO means that the operation has succeeded but some information has been attached to the result set (for example a message about possible loss of precision). Try using an ODBC connection to import the metadata. You can view the data as part of the importation process. This will get...

Its your choice. You can grant appropriate privileges, you can use a hashed file stage (which does not use SQL and therefore mainly bypasses these checks, unless you have already granted table privileges), or you could modify the underlying BASIC code (using an AUTHORIZATION statement) so that it al...