DSXchange

I have found this thread particularly valuable and informative (thank you to all the knowledgeable contributors). It does however raise some (obvious?) questions as to tuning the actual usage of such hash-files eg: 1) What (if any) effect do different creation parameters have on performance during r...

Use iconv to change the date to an internal date, add the number of days to the integer value, and then use oconv to manipulate it back to a date string. Something like the following. Lets say that you wanted to add 5 days to a date. CharDate = "20020404" IntDate = iconv(CharDate, "D") Ans = oconv(I...

Hi,
Is there any way to manipulate date variables in datastage.Like addding or dedcuting a integer to date variable.can any body help me

Regds
Tina

Yeah... Thats the one... -----Original Message----- From: Craig_Hulett@rsausa.com To: datastage-users@oliver.com Sent: 4/3/2002 11:40 AM Subject: RE: Routines versus Transforms Wow. As the official Worm Can Opener of this whole discussion thread, this has been a great source of information and enlig...

Wow. As the official Worm Can Opener of this whole discussion thread, this has been a great source of information and enlightenment for everyone on the list, IMHO. Plus its great to see things improving in new releases of the product (thanks, Dave) to address the very issues brought to light here. G...

Warren, I have already submitted an enhancement request (ECASE ID 4710) for this functionality with Ascential. Ascential confirmed that parameters are not supported in the ExecuteCommand or NotificationActivity stages. Looking at the available knowledge base on Ascentials web-site it looks like ther...

We have been having trouble using DataStage job parameters in an EXEC COMMAND stage. We defined a stage with the following attributes: Command: /bin/touch Parameters: #ProjPath#/test.tag The #ProjPath# DataStage parameter was set to /tmp. Heres whats logged for the stage: ExecTest..JobControl (@CExe...

Hi there, Im using DBMSCODE link variable cause I need to Abort the job at any kind of warning from RDBMS (Oracle). Everything goes well, but the performances is killed by this operation. My job is really simple. I read an oracle table and I write to another oracle table using a transformer just to ...

OK. I modified the Routine/Transform to return the date in external format (oconv(date(),D) and increased the number of invocations (10 columns instead of 3 - my original test) and ran for 1000000 rows. The results were 3:22 for function (4950 rows/sec) and 5:05 (3278 rows/sec). The example is inten...

I have no experience in setting up Exchange. I dont know if it supports SMTP "out of the box" or if there is some non-default configuration. In our situation, it was already configured to accept SMTP requests, although only to internal addresses (a deliberate security setting). I suspect that there ...

For what its worth, in the upcoming release of DataStage due to be released very shortly, I have made some modifications to the call stack invocation mechanism that largely eliminates a good portion of the difference you are seeing. Previously, in order to support nested levels of called routines, w...

When we implemented the SMTP email for our use of datastage, all i needed were the appropriate DLLs and MS OutLook or Exchange ( were running NT ). Once all was in place, a simple test proved whether or not the email worked. -----Original Message----- From: Pritsas, Loukas [mailto:lpritsas@kpmg.gr] ...

This is a topic for an orphaned message.

No problems... Just be aware that you dont run out of memory (if read cache is enabled) while reading and that u dont do a create file or ovrwrite existing file in all the programs where u write to the hash file. Regards, YN --- Sameh Bishara wrote: > > Hi all, > > I want to ask is there any problem...

Were trying to update 100,000 rows with the Sybase OC stage in one transaction. Halfway through this process, the job fails with a message reporting the server has Run out of locks. We would have expected the database to escalate the page locks to a table lock given the number of transactions. There...