DSXchange

The reason is the internal behaviour of the DataStage engine (UniVerse), which by default rounds at the fourth decimal place when an arithmetic result is used in a string context (such as during I/O). This behaviour can be changed in BASIC code by using the PRECISION m declaration, where m is the de...

Are all the column names spelled exactly correctly? (In particular should S701_ZGP_PROCES be S701_ZGP_PROCESS and CAPITL be CAPITAL?). Sometimes MS Access wants (single) quotes around the parameter markers, at other times it seems not to. I have had weird problems with differences between Access 97 ...

Hi all, i have a problem with Datastage 4.1 NT. While im trying to import metadata from oracle an error occurs: Error - OCI_SUCCESS_WITH_INFO. This error occurs also when i try to use the viewdata utility on OCI8 Plug-in. I have the same problem with Datastage 4.0 on SUN but in this case it only hap...

Can someone see something here that would be causing this error? Im loading from teh SAP plugin into a MDB. All the fields are described as "Nullable". Thanks, dave S701Extract.PickGoodRecords.BreederStatsUploadODBC: DSD.BCIPut call to SQLExecute failed. SQL statement:INSERT INTO `BreederStatsUpload...

Hi to the reader! I have problem loading data in a Oracle table field. The value from the source field of a text file contain a number, with 19 digits and I divide it by 100000000 before load it in a Decimal Oracle Table field with Length 19 and Scale 8. Executing this process I found in the Output ...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 To both the u2-users and the datastage-users list: Folks, Every once in a while I feel it necessary to remind everyone what the lists are not. Specifically, the lists are NOT a replacement for IBM/Informix and Ascential Software Tech Support. Now, over t...

The user who installs DataStage server (assuming that UniVerse is not already on the system) is granted DBA privilege. No other user is automatically granted any database or table privileges. No other user becomes a valid SQL user until CONNECT privilege has been granted. Granting of CONNECT privile...

Hi all, I am fairly new to universe database. Do we have role or groups in universe database to group sql users? I have a job that has a universe stage(the uv table has an undate action of clear the table, then insert rows. This works fine. But when a different user tries to run this job.It fails. L...

Hi Anthony, Thanks a lot. It works! Regards, Melvin ----- Original Message ----- From: Anthony Corrente Date: Monday, July 2, 2001 6:56 pm Subject: Re: Access Universe shell > Hi Melvin, > > No problem. The error simply means that uv failed to load the > DataStage plugin library... this is because y...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 In my haste to try to correct the situation, I accidentally sent the "you have been unsubscribed" message to the list, not the originating address. Please disregard. Nobody has been unsubscribed other than the offending address. Monday seems to be starti...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ok. That should take care of it. I was also contacted by someone at the domain apologizing to all of us for the problem. You may see a few more of these come in until the queues around the world get drained, so please bear with it. At this point, unsubsc...

Mark Detwiler wrote:

> Can someone put a stop to this!!!

Until someone does, I just put a filter to dump any messages from her address directly into Trash...

Dan

Your address has been sending "Out of Office" (aka "Vacation") notices to the list server for datastage-users@oliver.com. Because of this, you have been removed from the list. Please have your postmaster configure your Out of Office routine to recognize the "Mailing-List:" header on incoming message...

I changed my mail to automatically Send her messages (her name in TO ) to my DELETE Folder. Thank You, Patricia Desiano Anheuser-Busch, Inc. MSG - BudNET Data Warehouse 314-577-7558 -----Original Message----- From: Mark Detwiler [mailto:mark@msdetwiler.com] Sent: Monday, July 02, 2001 3:56 AM To: da...

Please unsubscribe me from the list

"Theresa M. Petner" wrote:

> I will be out of the office starting 07/02/2001 and will not return
> until 07/06/2001.