DSXchange

Yes containers do achieve their full potential in the 5.1 release of DataStage. At present in existing versions of DataStage you have a "local container" The 5.1 release of DataStage adds "reusable, and shared containers" not to mention some major architectural improvements to both the usage and dep...

Thanks to all for the responses on my last post. My final question for today relates to date logic in lookups. Is there a way to lookup a record by effective date in a hashed lookup? Ive tried writing in date formulas to no avail. Given the following records: 1 ABC 1/1 3/31 2 ABC Co. 4/1 I want to m...

Jason, As others have responded, that functionality is available in DataStage version 5.1. There are two types of containers, the type you are familiar with already, and the new reusable containers. These containers are built through DataStage (as they are already), but you have the option to have t...

Jason, Im pretty sure the functionality you desire is delivered in DataStage 5.1 (not prior to, though) Containers in 4.2.1 and earlier mainly group stages in a job for presentation purposes (un-clutters the job design for a complex jobs) Do you know your Ascential SE or Account Rep? The SE should b...

Is there a way to define a common series of stages in DataStage? For example, I have two customer mappings, one for insert and one for update. In both cases, I need to do a significant number of lookups in order to fully build the customer record either for insert (keyed lookups) or for update (for ...

Hi all, im working with Datastage 4.1.1 on NT and i have problems with Extract Pack 2.0.2 and Load Pack. When i try to connect to SAP from both plug-in, the SAPgui starts and, connecting to SAP/BW environment, show the execution of SAPLRFC1 program in debug mode! On the same workstation where Datast...

Have you check with support regarding this fonts issue Kent ----- Original Message ----- From: "Alexandre Stoulov" To: Sent: Wednesday, October 10, 2001 7:27 PM Subject: MetaStage 2.2 problem > Hi, All! > > When I import Business objects universe that contains Russian names of > classes, objects and...

Peter, Make sure when you run the dsjob command line make sure that your password is secure by setting the filename with the appropriate permission. Kent ----- Original Message ----- From: "Riccardo Tani" To: Sent: Wednesday, October 10, 2001 6:10 PM Subject: Re: Passing Parameters from UNIX shell s...

This is a topic for an orphaned message.

Simon, That error message normally indicate that your path to execute the perl script is not configure properly. If Perl is configured right, you should be able to type perl script.pl in a command prompt and have the script run. If not, you need to reinstall perl and check the path statement to make...

Hi, All! When I import Business objects universe that contains Russian names of classes, objects and so on everything is all right in "Metabroker decode" window, "Meta Data Selection" window and Russian characters are displayed correctly. But after import in "Category browser", "Class browser" and o...

Hi Peter, if you are using "dsjob" command line, you can add "-file" option and specifies the username, password and server into a file: dsjob -file .......... If you need more info check the "Datastage Server Job Developers Guide". I think it can help you. Regards, Riccardo ----- Original Message -...

Hello all, I am trying to use the before job subroutine ExecDOS to run a perl script to tidy up an input file prior to processing it. I get the following error message: pabx.BeforeJob (ExecDOS): Error when executing command: perl C:perlscriptsPABX_to_csv.pl *** Output from command was: *** perl is n...

In version 3, Ascential changed the way bind variables are labelled for lookups and deletes. In version 2.3 and earlier, the bind variables were numbered relative to the key columns. In version 3, they are numbered relative to all columns. Unfortunately, the changes were not fully implemented necess...

Hi, Thanks for the fast reply.The stage ORAOCI8 ver 3.0 Regds Tina. On Wed, 10 Oct 2001 David Barham wrote : > You havent mentioned what sort of stage you are using > to access the view? > Is it ORAOCI8? > > If it is be aware that by default, DataStage 4.1 comes > with ORAOCI8 version > 2.3, where a...