DSXchange

Hi Guys, When it comes to control jobs that have a number of levels (i.e. one controlling job calls another and so on), Ive seen a couple of times that DataStage comes back with an error message indicating that it could not attach to a specific job - it fails to create a handle on the job. What woul...

CompileAll is not supposed to show the categories of jobs. This should be included in the next version of the product.

Hi all Im trying to import a stored procedure into DataStage 4.2.1 from sql 2000 and get the following error: Parameter @RETURN_VALUE in stored procedure HWAR_DW.DATASTAGE.NHStrunc_Tmpi_Stock_Dimension_Wrk;1 is defined as type 5, which is not supported in DataStage. Definition not imported! The defi...

Hi, verify if Datastage group on your server has "Log on locally" rights in the User Manager panel. I hope this will help you Riccardo ----- Original Message ----- From: To: Sent: Monday, April 08, 2002 8:59 AM Subject: RE: User security > Hi, > > You could start by making sure the following permiss...

Hi, You could start by making sure the following permissions are set for each user. - Read permission to the whole Datastage Directory structure (ie. C:Ascential...), - Read & Write permission to the projects directory structure (ie. C:AscentialDataStageProjects...), - Read permission on C:WINNT and...

Thank-you everyone, All of the suggestions given were excellent, and we went with the Stage Variable option, which we were trying to use in the first place, but were not using it in the right way. YN on 05/04/2002 06:06:43 PM Please respond to datastage-users@oliver.com To: datastage-users@oliver.co...

Hi all, Having some problem with restricting access to DataStage on NT. Have created groups to have Developer access to the DS projects. However, having errors everytime when trying to sign in to any of the created projects. Seems only administrator works. (Embedded image moved to file: pic19329.pcx...

This is a topic for an orphaned message.

Nicholas, Groups are added to the on-disk copy of a hashed file as it is loaded, so there is lower chance of overflow than in static hashed files (simplifying assumption - the static hashed file is not created with lots and lots of groups). However, there is never a guarantee that the group that is ...

Use a transform in SDK called RowProcCompareWithPreviousValue. -----Original Message----- From: Julie.Jarrett@ing.com.au To: datastage-users@oliver.com Sent: 4/5/2002 2:09 AM Subject: Storing the last record What is the easiest way of reading an input file, and keeping the last record info to compar...

Thank You Tina On Thu, 04 Apr 2002 lester.callif@ascentialsoftware.com wrote : >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...

Hi Julie, I guess u r talking about keeping the previous record... You can create stage variables to store the input record columns. Make these stage variables lower down in the stage variable list, preferably at the end (stage variables are initialised from the top to the bottom in that order). Cre...

What is the easiest way of reading an input file,
and keeping the last record info to compare with the latest input record, so there is always an old record to compare with.?

Thanks
Julie

Hi Gopal, depending on which DataStage version you have you can group within DataStage without Aggregator and without Aggregator Stage. With ODBC-Stage for example you write in the derivation column the field-name and write the group column yes for group-fields and no in group-column for calculating...

At 04:07 PM 4/4/02 -0700, you wrote: >Sorry to add fuel to the fire, but I have to toss my $0.02 into this >thread... Ill call your $0.02 with my $0.02. (:-). Thanks to everyone. I have taken several of the posts regarding this thread and annotated them with my wisdom. Thanks for listening. A discus...