DSXchange

Can any provide some details, what is MetaSage? how a company can use it,
what are the benifits etc etc

thanks in advance

Rahim Ladha
e-mail : rahimladha@hotmail.com


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Iconv(number, "MD0-") will do it. The "MD" conversion (see BASIC Reference Guide) also handles other forms of negative number, such as appended "CR" or "DB", or notation. -----Original Message----- From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt] Sent: Thursday, 23 August 2001 20:43 To: LIST-DataStag...

Try CURRENT_DATE (add the underscore). That works (at least in version 4.2.1) Rich -----Original Message----- Date: Thu, 23 Aug 2001 10:42:24 +1200 To: datastage-users@oliver.com From: Paul Ko Subject: Datastage/390 is not unable to use CURRENT DATE in the lookup sta ge Message-ID: Hello, I am just ...

Here are a few different ways. I hope one might help. >RTN=`dsjob -run -jobstatus Project JobName` Finished waiting for job Status code = 1 >echo $RTN Waiting for job... Job Status : (1) > Note: If job fails because of bad parameter or the like RTN will be blank. --- Or --- dsjob -run -jobstatus -pa...

External Routines and for that matter most other stages do not really handle Cobol groups. They work on a column per column / field per field basis. You have to work around the Group issue. One way is to concatenate all the various 05 level fields into 1 variable (e.g. a stage variable) using the st...

I Phil, I worked with a Sun E1000 with 8 processors. The only problem I have had (DS 4.0.1), was about the DSWaitForJob function (in a job control environment). If I tried to launch more than 4 jobs in parallel, DSWaitForJob function didnt work fine. In other words the execution didnt wait the end o...

Hello, I am trying to write a batch file. In this file, I will first submit a datastage job using datastage command line similar to this: ~dsjob.exe [bunch of parameters] -run -jobstatus projectname jobname Depends on the status of this job, I will decide what to do next in the batch file, such as i...

We (Miller Brewing) are using Datastage on the mainframe, accessing DB2, and also have Metastage installed. Were working through the many quirks/bugs that the OS/390 version of Datastage has. I myself cant speak to Metastage. Weve got it. Plan is to use it, but we havent done much with it yet. Rich ...

Michael, Follow these guidelines: If all rows will be inserts then make sure the sql action is insert rows without clearing. If this is set to update or insert or vice versa will cause a major performance hit. I would also set the array and transaction size to about 1000. This is usually a good star...

Try something like Iconv(input,"ML0M") I havent tested this, but if it isnt quite right, check ou the help on Iconv -----Original Message----- From: Nuno Pimenta [mailto:nuno.pimenta@tmn.pt] Sent: Thursday, 23 August 2001 8:43 PM To: LIST-DataStage (E-mail) Subject: Format a negative number I have a...

I have a source system that gives me a negative value like: 22122-

There is in DataStage, any function/format to convert this value in -22122?

Thanks in Advance,

NP

Is anyone out there running DS on an E10000 machine? A client has an E10000 64 cpu machine of which 12cpu will be assigned to the ETL environment, 24 cpu to the DW and various others.

Just wanted to know if there were any issues that should be considered.

Phil.

1) Try using parallel inserts. 2) Increase the rows per transaction count. 3) Try using direct insert (8i supports). With this ORAOCI is as good as ORABULK (SQL*LOADER) Regds Vivek > -----Original Message----- > From: Michael Feckler [SMTP:mfeckler@onel.com] > Sent: Thursday, August 23, 2001 12:45 A...

Hello, I am just wondering has anybody encountered a situation where you have to use the DB2 CURRENT DATE function to compare against dates. I have created a RELATIONAL STAGE in the Datastage Designer and I am trying to add two conditions in the WHERE tab to limit selection to those records that hav...

thanks! Wendy Voon Consultant Black Diamond T e c h n o l o g i e s Level 3, 1 Southbank Boulevard, Southbank, Victoria 3006 E-mail: wendy.voon@team.telstra.com Telephone: (03) 8696 - 5023 > -----Original Message----- > From: len.greenwood@ascentialsoftware.com > [SMTP:len.greenwood@ascentialsoftwar...