DSXchange

Alex: This is the ROUTINE that I use to send mails, using DSSendMail function. You have to contact to your notes administrator to determine the value to set for: xFrom and xServer. Parameteres pmL1..pmL20 are each line that I want to include in the note. This routine receives the following parameter...

TWlzdGVycywNCmlzIHRoZXJlIGEgd2F5LCBpbiBkYXRhc3RhZ2UsIHRvIHNlbmQgYW4gZW1haWwg
d2hlbiBzb21lIGNvbmRpdGlvbiBvY2N1cnM/DQpUa3MsDQpBbGV4DQo=

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

Parameter Manager for DataStage (http://www.datastagexchange.com/PM) is a great (and affordable) tool for managing your parameters. Since you're starting from a position of having no parameters, you're at the ideal place to contemplate getting this tool. It means that you can have consistent paramet...

Wow. What many people do is create global parameter files. These are parameters which you use frequently and do not change, such as username,passwd,Source_Db,Target_DB, Archive_Dir,Staging_dir etc. If you are on unix, you can echo those global variables when you pass parameters to your jobs and easi...

Here's a simplified view of using parameters... Look for a Yellow Box-like Icon on your job window that says Job Parameters. The 2nd tab is a Parameter tab. All you do is enter all the parameters you need to read in a source file and/or write to an output file then on the Sequential File stage (or w...

I have been using DataStage for over a year now, but haven't messed with using parameters much at all. I am currently using DataStage Version 6.0, on a server. I make many changes, manually, every month. From where files get FTP'd to (stored in a different location each month), to simply changing wh...

I believe the following will allow you to connect to Postgres. No promises, but it sure looked like it would do the job. http://www.commandprompt.com/entry.lxp?lxpe=296 Thanks, Lester Lester F. Callif | Manager | BearingPoint, Inc. | Centennial, Colorado Mobile 303.596.8422 | Fax 707.988.0160 | Amst...

Hi, you can use ODBC access regards Rui Soares Senior Consultant .................................... Novabase Rui.Soares@Novabase.pt Tlm : +351 96 3470840 -----Original Message----- From: Nuno Pimenta, Eng. Sent: sexta-feira, 13 de Fevereiro de 2004 15:52 To: datastage-users@oliver.com Subject: Acc...

Hi all,

DataStage can accessing to a postgres DB? How?

Thanks in advance,

Nuno

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

Hi, When we try to created or remove any job, we get the follow error : Error calling subroutine: DSR_WHEREUSED (Action=3); check DataStage is set up correctly in project PROJDS_KISS_PRD (Subroutine failed to complete successfully (30107)) Any idea what could be ? regards Rui Soares Senior Consultan...

When setting up an ODBC stage to import Lotus Notes data using Datastage, I'm able to load the views and field names in my ODBC stage, but I am unable to query the data with the 'view data' button. It gives me an 'SQLSTATE=IM005 ... SQL_HANDLE_DBC failed' error. I'm using DataStage V7 on a Windows 2...

VGhrIHUgYWwNCg0KCS0tLS0tTWVuc2FnZW0gb3JpZ2luYWwtLS0tLSANCglEZTogQ3JhaWcgSHVs ZXR0IFttYWlsdG86Q3JhaWcuSHVsZXR0QGNvbWNhc3QubmV0XSANCglFbnZpYWRhOiBxdWkgMTIv MDIvMjAwNCAxMToxMSANCglQYXJhOiAnRGF0YVN0YWdlIFVzZXJzIERpc2N1c3Npb24gTGlzdCcg DQoJQ2M6IA0KCUFzc3VudG86IFJFOiAiZXhwb3J0IiBqb2IgbG9nDQoJDQoJDQoNCglPc...

TWlzdGVycywNCmlzIGl0IHBvc3NpYmxlIHRvICJleHBvcnQiIHRoZSBqb2IgbG9nIGluIERpcmVj dG9yLCB0byBzZWUgaXQgaW4gYW5vdGhlciBlbnZpcm9ubWVudD8NClRoYW5rcywNCkFsZXgNCg== _______________________________________________ datastage-users mailing list datastage-users@oliver.com http://www.oliver.com/mailman/listinfo/dat...

or you write your own DataStage-Job, which does it. or you write a Shellscript in UNIX or a *.bat on Windows and you use the dsjob-Programm. As you see, there are many ways, and for sure there are still more. Wolfgang -----Original Message----- From: Craig Hulett [mailto:Craig.Hulett@comcast.net] Se...

Or there are three or four "DSGetLogxxx" functions you can use as well. -craig -----Original Message----- From: datastage-users-bounces@oliver.com [mailto:datastage-users-bounces@oliver.com] On Behalf Of tom.peter.nielsen@nordea.com Sent: Thursday, February 12, 2004 7:01 AM To: datastage-u...