DSXchange

hi everyone, Is it possible to share a job/routines across different projects? We have maintenance jobs and routines that are used by different jobs across different projects. The actual situation is that we have a copy present in each project. But when we want to modify a job we need to reflect the...

Worked like a charm, Tony. Thank you. Kate Tony Curcio cc: Subject: Re: Concatenating text fields 07/11/2002 10:03 AM Please respond to datastage-use rs You should be able to code it as follows: ADDR_LN1 : (If IsNull(ADDR_LN2) then "" else ADDR_LN2) : CITY : STATE : ZIP ---Tony kamoore@regence.com w...

Yes, its true. Everybody would like to received this information. And if we can download this information, it will be more easy. Ive propose to Ascential, to delivery this information by is partners, or in future information like this, it could be enclosed in upgrade version. best regards Rui Soares...

In an effort to stem the flood of me too messages on this subject, perhaps Ascential can make these documents available for download from their website? Perhaps in a public ftp area? I cant imagine anyone on this list who wouldnt (or maybe I should say "shouldnt" ) be interesting in them if they kne...

You should be able to code it as follows: ADDR_LN1 : (If IsNull(ADDR_LN2) then "" else ADDR_LN2) : CITY : STATE : ZIP ---Tony kamoore@regence.com wrote:HI All -- I am new at using DataStage and hope that someone has an easy answer for this. I am creating flat files that will be used to feed a vendor...

HI All -- I am new at using DataStage and hope that someone has an easy answer for this. I am creating flat files that will be used to feed a vendor product. On one of them, the last field is a text INFO field defined as VarChar (255). Into that field, I need to load address information as follows: ...

Please add my name to the list too. Thanks, Kate "Angela McKinney" To: "

I read in a previous email that Ken Bland put together some excellent documents on ETL methodology and Best Practices. Could I get a copy of those? Ive signed up for the last 2 Best Practices classes and they have both been cancelled because of lack of interest. Im scheduled for the next one in Irvi...

I would appreciate this information also, Regards, Sebastien Panchout Panalpina Management AG > > > > > -----Original Message----- > > > From: pavan.marpaka@ascentialsoftware.com > > > [mailto:pavan.marpaka@ascentialsoftware.com] > > > Sent: Wednesday, July 10, 2002 12:43 PM > > > To: datastage-user...

Hi I would be interested in that also. Thank you. Alex ----- Original Message ----- From: To: Sent: Wednesday, July 10, 2002 6:42 PM Subject: RE: More info on DataStage Best Practices > Ken Bland put together some excellent documents on ETL methodology and Best > Practices. I can send them over. > >...

Pavan, Please include me in this. Thanks, Andy. -----Original Message----- From: pavan.marpaka@ascentialsoftware.com [mailto:pavan.marpaka@ascentialsoftware.com] Sent: 10 July 2002 17:43 To: datastage-users@oliver.com Subject: RE: More info on DataStage Best Practices Ken Bland put together some exc...

I would appreciate this information also, Regards, Luc -----Original Message----- From: Allan Kruse [mailto:aKr@PLATON.dk] Sent: Thursday, July 11, 2002 1:40 PM To: datastage-users@oliver.com Subject: RE: More info on DataStage Best Practices I would appreciate this information also, Regards, Allan ...

Riccardo, If the output is a file it works fine. And if there are more records the problem continue. I think the problem is in the "Rows Per Transaction". > -----Original Message----- > From: Riccardo Tani [mailto:riccardo.tani@datamat.it] > Sent: quinta-feira, 11 de Julho de 2002 10:40 > To: datast...

I would appreciate this information also, Regards, Allan Kruse -----Original Message----- From: pavan.marpaka@ascentialsoftware.com [mailto:pavan.marpaka@ascentialsoftware.com] Sent: Wednesday, July 10, 2002 6:43 PM To: datastage-users@oliver.com Subject: RE: More info on DataStage Best Practices Ke...

Hi, I have installed DS4.0 on Linux Red Hat 6.1 and all work fine. Riccardo ----- Original Message ----- From: "Etienne Dodu" To: Sent: Thursday, July 11, 2002 9:57 AM Subject: Datastage with linux > Does one of you run Datastage on a linux server ? > > Please just tell me what version of Linux and ...