DSXchange

Hi Brad. I received the email you sent to me directly. I tried to reply, but our mail server could not resolve the IP address and gave up. If I get a chance, I will try from home tonight. Cheers David ************************************************************************* This e-mail and any files...

The first thing I would do is monitor the virtual memory usage while the job is running. It could be a simple as running out of virtual memory (ie increase the size of your page file) NT is supposed to, but does not always log a message in the system event log when it runs low on virtual memory. How...

(First time posting) We are doing what looks like a fairly simple extract from Unidata on an HP to an Oracle database on NT. On the NT server, we are getting the following Event Detail (Event ID 1004) several times per hour: "UniVerse error: Unhandled Exception raised at address 0x78001799: Acc...

Thanks to all of you for your information about VB plugins and also your suggestions on how to handle the front end FTPing.

Scott

Brad The true use of stored procedures within DataStage ODBC stage is to extract data from an ODBC Source or to pass a row of data to a stored procedure to be processed. So when used as an extract DS expects a result set to be returned. When used as a target it expects the stored procedure to proces...

I notice in the documentation that when using an ODBC stage to call a stored procedure (in our case a call to Oracle running on a DEC Alpha), that the ODBC stage does not get/receive anything back from the remote machine. Were in DS 3.1.1r3 on an NT Server, BTW. I understand there is an option to re...

Hi David, Are the files youre looking for to FTP to your server on a mainframe or another server? Heres the approach we take: Files on the mainframe: As part of the mainframe jobstream, update a separate control file each day with a timestamp and record counts. The file is always there and our DS jo...

Yes, these options were running through my mind too. I have a number of jobs which copy files (using DOS utilities) in the job control prior to them being used as input stages. One problem I have is that if the files dont exist, then I copy in a previously prepared "empty" file so that the...

As of today there is no such thing as a VB plug-in. The only supported language available for plug-in stage types is C. A manual is available from Informix called the "C Plug-In Stage Interface". (Its Ardent part number was 76-1007-DS3.6.) If nothing else, this manual might convince you th...

>>> ray.wurlod@informix.com 07/24/2000 6:42:47 PM >>> 1. There is a problem here, in that you simply are not comparing apples with apples. DataStage is an identical product on all platforms except at the very lowest level (invisible to you) that interfaces with the operating system. However, you can...

1. There is a problem here, in that you simply are not comparing apples with apples. DataStage is an identical product on all platforms except at the very lowest level (invisible to you) that interfaces with the operating system. However, you can get much greater capacity UNIX systems than Windows N...

Hello, I am new to Datastage and also new to this list. Hopefully I am not asking a repeatedly hashed out question. I tried to check by looking for archives but did not find any. I have two main questions I was hoping to get some answers on from all of you: 1. Has anyone run both the UNIX and NT ver...

Hello. Is there any experience out there regarding accessing a JD Edwards Oracle database? Help regarding tools, subroutines and general knowledge would be helpful. Regards Robert F. Woods Robert F. Woods Beam Reach Consulting, Inc. 303 306-2355 2351 S. Truckee Way 303 306-2356 Fax Aurora, CO 80013 ...

Please remove me from your list. Thanks _______________________________________________ Michael C. Ryan Senior Trainer Consultant Mike.Ryan@Informix.com www.informix.com Sydney Australia Informix Software > -----Original Message----- > From: grogers@randmcnally.com [SMTP:grogers@randmcnally.com] > S...

This is a topic for an orphaned message.