DSXchange

Oops, Accidentally sent to Ray instead of the entire DataStage users. Hope this helps. Pavan -----Original Message----- From: Pavan Marpaka To: Ray Wurlod Sent: 3/4/2003 2:03 AM Subject: RE: MetaStage issue.... You have to have appropriate privelages to be able to setup SMTP defaults. Try logging us...

Dear Xiong, Thats a good catch, I hadnt thought of that because I always log on as Administrator. Generally speaking, you always want to have the Adminstrator role in MetaStage when you can get it. Many important functions are not available to people with the Developer role, and the User role is ext...

Hi, Walter After upgrading my metastage role as administrator, I can do publication request now. Also, the Directory Option appears under the Tools->Option. Hence I know there is actually no Directory Option under Tools->Option against Developer user. It is supposed to be configured by administrator...

In response to Xiong Lis question, below, selecting Tools > Options from the MetaStage Explorer menu produces the Options Dialog box, on which you select and expand Directory Options, and then select Email Setup. Walter Crockett MetaStage technical writer ------------------------------ Date: Tue, 04...

This is a topic for an orphaned message.

We have been using Metastage 6.0 a little while now. I do not think you need to set up any additional email ids other than users of MetaStage. ZK -----Original Message----- From: Xiong Li [mailto:Xiong.Li@team.telstraclear.co.nz] Sent: Monday, March 03, 2003 9:23 PM To: datastage-users@oliver.com Su...

I simplified my job to really find the actual problem and now I have only one link. The link is user-defined and I always receive the "Invalid property value" during validation Nothing seems to be wrong with the properties of the object. When I switch to Generated query the job validates OK. I also ...

This is a topic for an orphaned message.

Siva_Hotmail wrote: > Hi All, > > What are the new features available in Data Stage Version 6. > > Thanks > Siva >From the readme: Whats New In This Release ========================== DataStage 6.0r3 sees the introduction of the DataStage XE Parallel Extender which provides a new scalable, parallel ...

Hi Guys I am currently experiencing an error that I dont completely understand and cannot find any information on the error. The error is: ARCBOOKINGS3..INDEX_LOOKUP.OLD_REC: ds_ipcgetnext() - timeout waiting for mutex Do you know what could be causing this error? Mark Ewart-Phipps Centerfield Softw...

Hi Kesia, I think you can follow almost two alternatives... First one: You can use the OCI stage as your reference table and into the output tab properties change your columns definition with only one key field (Part_nbr).. This is a "singleton lookup": for each input record you get only the velue o...

Hi All,

What are the new features available in Data Stage Version 6.

Thanks
Siva

Niranjan, Not sure if this is the most efficient method (anyone?) but this will work if you are always wanting a hyphen between the first and last names: Ereplace(Iconv(Ereplace(InString,"-"," "),"MCT")," ","-") It replaces the hyphen with a space, does the Iconv and then puts the hyphen back. Howev...

Hi, I need some help to overcome a conversion problem. The following conversion X = Iconv("JOHN-SMITH", "MCT") leads to X = "John-smith" whereas the following is required X="John-Smith" Can I use any other masked character conversion codes to get the right conversion. Any suggestions to resolve it w...

You have several alternatives. You could generate the key id from an Oracle sequence and acquire it at your select from QM_EngBomOfMaterials as in, SELECT distinct PART_NBR,LINE,COMP_PART_NBR, NEWKEYVALUE.nextval as ITEM_SEQ_ID FROM #QM_TABLENAME01# you can generate a key value (look at the key mana...