DSXchange

I am trying to set up a parallel test project that contains workfiles and Oracle tables. I would like to export an entire project to another project (on the same server) and have it use a different set of files without changing file/table names. By using account, workfiles are easy. Does anyone have...

Jenny, Set the date column in the TARGET DB2 stage to CHAR instead of timestamp or date. Your date format is correct. -----Original Message----- From: jash7@sears.com [mailto:jash7@sears.com] Sent: Tuesday, October 01, 2002 11:15 AM To: datastage-users@oliver.com Subject: Troubles converting a Times...

Use FieldName[1,10] when you map the column example updatedate[1,10] in the derivation Sakthi -----Original Message----- From: jash7@sears.com [mailto:jash7@sears.com] Sent: Tuesday, October 01, 2002 11:15 AM To: datastage-users@oliver.com Subject: Troubles converting a Timestamp to a Date I am tryi...

I am trying to tranfer a SQL Server Timestamp to a DB2 date. Example: 2000-02-05 13:50:10.140 to just 200-02-05 Does anyone know how to do this in DataStage? I also tried converting it in SQL before brining it into datastage, but this creates a string date which DB2 doesnt like. Thank you, Jenny

Thanks guys, Regu -----Original Message----- From: Kenneth Bland [mailto:kcbland_2000@yahoo.com] Sent: 01 October 2002 15:41 To: datastage-users@oliver.com Subject: RE: Constraining when a character exist in a string Use INDEX instead of COUNT. COUNT will scan the entire string to, whereas INDEX can...

Use INDEX instead of COUNT. COUNT will scan the entire string to, whereas INDEX can stop on the first occurrence. INDEX returns the position where a substring is located in another string. If it doesnt find it the return value is 0. You can indicate which occurrence you want to find, in your case th...

Index -----Original Message----- From: Regu.Saliah@astrazeneca.com [mailto:Regu.Saliah@astrazeneca.com] Sent: Tuesday, 1 October 2002 11:39 PM To: datastage-users@oliver.com Subject: Constraining when a character exist in a string Hi Guys, I need to apply a constraint to a transform that will only a...

Hi Regu, try to use DCount(string, delimiter) function. This function counts a delimiter (that could be also a string) in a string. Hope this will help you Riccardo ----- Original Message ----- From: To: Sent: Tuesday, October 01, 2002 3:38 PM Subject: Constraining when a character exist in a string...

Hi Guys, I need to apply a constraint to a transform that will only allow rows where one of the input fields doesnt contain a particular character anywhere in the field. I would be surprise if there isnt a function in DS that will look for a given character in an incoming string, but so far I cant f...

Hello Nuno, set in your dsenv the right NLS settings for oracle. I use: NLS_LANG=American_America.WE8ISO8859P1; export NLS_LANG Rregards, Udo Nuno Pimenta 01.10.02 12:34 Bitte antworten an datastage-users An: "@DataStage (E-mail)" Kopie: Thema: Dot and Comma Hi all, I have an Oracle8i table with two...

Hi all, I have an Oracle8i table with two columns, where the . is used like a decimal separator in Oracle. For example TAB: COL1 COL2 1.0 1.1 But when i see the data in Designer 5.2 the result is: COL1 COL2 1,0 1,1 There is any way to tell to DataStage 5.2, that the decimal separator is the dot and ...

All platforms, certainly in 5.2. Job properties (General tab) has a check box called "Allow Multiple Instance". Stewarts note yesterday covers how this has been enhanced in 6.x. -----Original Message----- From: Rui Soares [mailto:rui.soares@novabase.pt] Sent: Monday, 30 September 2002 8:11 PM To: da...

Hi The Parallel processing is available in each platform ? What is required ? Rui Soares Rui Miguel Soares NOVABASE - Business Intelligence Mail : Rui.Soares@Novabase.PT Tel (NB) : 351 21 383 65 92 Tlm : 351 96 347 08 40 Fax : 351 213 836 309 -----Original Message----- From: Wurlod, Ray (BSG) [mailt...

Hi Rachna, To expand on Rays explanation, in 6.x you now have a NEW Parallel Job Canvas. This enables you to developed Parallel Jobs with complete control over the level of parallelism and how you wish to partition your data to utilise the available processes, giving you unlimited scalability (depen...

Theyre going to need a four dimensional Designer canvas soon! -----Original Message----- From: stewart.hanna@ascentialsoftware.com [mailto:stewart.hanna@ascentialsoftware.com] Sent: Monday, 30 September 2002 3:29 PM To: datastage-users@oliver.com Subject: RE: Parallel processing in DS 6x Hi Rachna, ...