DSXchange

Hi Transaction size is set to 30000 Gopal "Rick R. Schirm" To: Subject: RE: Array Size in DataStage 03/21/2002 12:40 PM Please respond to datastage-use rs What commit level are you currently set at? Rick Schirm -----Original Message----- From: gxganes@regence.com [mailto:gxganes@regence.com] Sent: T...

What commit level are you currently set at? Rick Schirm -----Original Message----- From: gxganes@regence.com [mailto:gxganes@regence.com] Sent: Thursday, March 21, 2002 2:30 PM To: datastage-users@oliver.com Subject: Array Size in Datastage Hi All Yesterday I ran into a peculiar problem with an part...

Hi All Yesterday I ran into a peculiar problem with an particular job that loads a staging table in Oracle ( the table has 120 columns.) The job was abnormally terminating with a generic error Abnormal termination detected.. I tried reducing the number of columns in the target stage to 113 columns (...

Hello World, Im working on a project to load a new data warehouse in MS Sql Server. The problem Im encountering is this.... We have Foreign Key constraints on tables in SQL Server. In some cases, when a record fails the insert due to a Foreign Key constraint, how can I report that that particular re...

Hi, Hong Its first time I am trying to insert data into SQL Server table, some cols datatype of this table are nvarchar, the others are integer. While running DataStage job, I got the error message: DSD.BCIPut call to SQLExecute failed. SQLSTATE=S1000, DBMS.CODE=2 [Ardent][SQL Client][ODBC][MERANT][...

This is not something DataStage is doing. It is almost certainly a setting in your ODBC driver for Ingres. Whether or not the ODBC driver configuration setup for this particular driver allows it to be changed you will have to discover for yourself, but please let us know the outcome. Ray Wurlod Trai...

Mark, Ive designed a job to reproduce your error and I got the following runtime error (in Designer, the Test Connections works fine): EstraggoSQLSvr2000..MSOLEDB0: OLE DB provider error HRESULT=0x80040e09. The problem was user permissions on the table. Hope this will help you Riccardo ----- Origina...

Hello, We are using the ODBC stage to read data from an Ingres database. The default setting on the database is to lock the rows/tables when we try to read the data. We want to know if there is any way to avoid locking of rows/tables through ODBC stage while reading the data. The Datastage version i...

Hi Ricardo, Im using MDAC 2.6 on the server. Mark Ewart-Phipps Data Warehouse Analyst Afrox Healthcare Information Management Tel: (011) 723-2723 Fax: (011) 450-3535 Mobile: 083-380-2335 ********************************************************************* This footnote confirms that this e-mail mes...

In DataStage 4.2 there is no built-in mechanism for sending email. However, it is a really simple task. First, you must build your mail document (you can use BASIC, or even something as simple as multiple echo statements executed through DSExecute). Then you construct a command to send the mail, and...

Doug, The maxuprc for our servers is 29995 and even after we reduced our use of dsjob it still occurs but only on a dsjob -jobinfo command. Peter -----Original Message----- From: Hall, Doug [mailto:Doug.Hall@anheuser-busch.com] Sent: Wednesday, 6 March 2002 3:06 AM To: datastage-users@oliver.com Sub...

yes DataStage 5.1 has email notifications within the job sequencer. basically it means that on an event, such as a job failure or successful run, an email can be sent. Andrew Webb Principal Presales Consultant Ascential Software Ascential Shatters Data Integration Benchmark Record m www.ascentialsof...

i had to write my own as well i here ds5.1 may have it built in -----Original Message----- From: Pritsas, Loukas [mailto:lpritsas@kpmg.gr] Sent: Tuesday, March 19, 2002 11:50 AM To: datastage-users@oliver.com Subject: How to send an e-mail / mail message through DataStage I am using [DS 4.2.1] this ...

I am using [DS 4.2.1] this version does not have a built-in mail feature. Therefore, I have to use a routine / sub-routine in VB to send e-messages / e-mail to administrative users when certain events occur. Has anybody ever used that ? Can I find a ready-made routine to do this ? Is there any other...

You may need to check the maximum number of processes / user. On AIX use "lsattr -El sys0" to check the value of maxuproc for the system. I also use "ps -ef | grep uv | grep USER_ID | wc -l ", where USER_ID is the ID for your DS jobs. This gives me a count of the processes. fyi, Doug -----Original M...