DSXchange

Jenny, you could simply use the filter command option in the sequential stage and cat the files using a wildcard, this will read any / all files that match the mask you specify. Of course the matching files must be of the same column layout. ----- Original Message ----- From: To: Sent: Thursday, May...

>>> david@barham.hm 05/17/2003 8:20:28 AM >>> Scott, No, that will not change the user that DataStage jobs will run under. If you connect to Director and run a job directly, it will run under the user that you connected to Director with. If you schedule a job it will run under the user that you have...

Thank s David, I guess the easiest way will be to create a rule in Outlook which saves the messages to a specific place, and then let DataStage do its magic! -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: Monday, May 19, 2003 12:58 PM To: datastage-users@oliver.com Subj...

I was actually thinking of the files that an SMTP server would write which are just text files. If there is other mail to the same address that is needed by Outlook, then a rule could forward it perhaps to an SMTP server on say your DataStage server. You might be able to create a custom action or ap...

Hi David Yes, I could do that. However, Im not sure if DataStage can read the mail file (Express/Outlook), and where in the mail file would I look to determine that this mail is a delivery notification? -----Original Message----- From: David Barham [mailto:david@barham.hm] Sent: Monday, May 19, 2003...

Hi guys please I want to know how can I send mail while having errors or warning in my director.............how can create the action of sending the mail ????????/ thanks >>> david@barham.hm Monday, May 19, 2003 13:58 >>> I was actually thinking of the files that an SMTP server would write which are...

Could you arrange for the SMTP server to deposit mail to a specified address in a directory and have DataStage check that directory periodically? Even the Windows SMTP server should be able to do this. -----Original Message----- From: Mark Ewart-Phipps [mailto:mark@centerfieldsoftware.co.za] Sent: M...

Hi DataStage can send email, but can it read email? I have an application that sends out email with a delivery notification. When the email system responds with the delivery notification, is there some way DataStage can read this notification? If not, what have you used to pick up the notification i...

David@barham.hm wrote: >If you connect to Director and run a job directly, it will run under the >user that you connected to Director with. >If you schedule a job it will run under the user that you have recorded in >DataStage Administrator as the user for scheduled jobs. True. This sometimes leads ...

Scott, No, that will not change the user that DataStage jobs will run under. If you connect to Director and run a job directly, it will run under the user that you connected to Director with. If you schedule a job it will run under the user that you have recorded in DataStage Administrator as the us...

You can call multiple procedures sequentially in the Before-tab. CALL MYPROC1(); CALL MYPROC2(); Eric -----Opprinnelig melding----- Fra: Katarzyna Lewicka [mailto:katarzyna.lewicka@cgey.com] Sendt: fr 16.05.2003 14:04 Til: datastage-users Kopi: Emne: pl/sql call from oci Before processing the sql in...

Before processing the sql in my oci stage, I would like to call a pl/sql procedure (this procedure will insert data in the table I use in my stage).

Can I do it in the SQL-Before tab in my oci? Can I call more than one procedures at once?


Thanks

Kasia

Not really enough information given here. For example, in what stage type are you setting the property? Assuming this is chosen from a drop-down list, what other options are available; in particular is there a "generate warning if command fails" option? What version of DataStage are you running? Is ...

And what about using a sequential file stage, with an overwrite action on your first link and an append on the second one. Another way is to merge your files using the ExecSH (or its equvalent in windows) routine and the appropriate merge unix command. Kasia Fromjash7@sears.com Todatastage-users@oli...

Hi All, In one of our jobs we are calling a Windows .BAT script which in turn fires a SQLLDR command to load data into a table. In the properties of the stage, We select Abort if command fails. This is required to track the failures of sqlldr job. But the issue is if out of 1000 records, even one of...