DSXchange

Is this syntax correct or not (what about spaces, quotes and double qotes) what about the output and the systemReturnCode if Status = DSJS.RUNOK Then * Job Finished normal run with no warnings. CALL DSExecute(UNIX, echo "Job Finished normal run with no warnings." > /dwh/apps/SMSTesting.txt, ,0) End ...

Exactly like specified. Best way is to write: If (cond) then command command End Else If (cond) then command command End Else If (Cond) then Command Command End Else Commands End End End Klaus -----Original Message----- From: Sameh Bishara [mailto:SBishara@Mobinil.com] Sent: Thursday, March 07, 2002...

Isnt there a way to write a

if (cond) then (command) elseif(cond)then (command) ...etc


Thanks and Best Regards,

Sameh S. Bishara

Hi Pierre, May I know your DS relese and the installation plataform?? Best Rgds Giovanni Boccia Sales Engineer Direzione Industria e Servizi Datamat - Enabling Your Future ----- Original Message ----- From: "Folot, Pierre-Andre" To: Sent: Wednesday, March 06, 2002 9:53 PM Subject: RE: Abnormal stage...

Hey David,

Thanx your respond. But Im unable to find Pivot Stage how to use? I have
search Documentation also. But Its not avalable to my system and Even I
have browsed also. Can you pls let me know How to use? Thanx in Advance.

Ravi

Hi Guys and Ladies

Are anybody using TerraData? We are proposing to one of our customers, and I would like to have from a technical perspective the ease of use, and your company name.

Thanks in Advance

Regards

Yzelle De Wet

Can someone please advise on how to set up odbc.ini and dsenv so as to be
able to use the Informix CLI stage from a UNIX platform. The manual is not
really clear.



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

Hey Kim,

So Is there any other solution to do this? Bcos I am taking here only one
lookup. So upto your openion here, i have to take same lookup table name
and create 12 Lookup stages? But here also performance is slow right?

Thanx in advance...

Ravi

The TIMESTAMP.TO.DATE transform is intended for this very purpose. It takes a timestamp as its argument and returns the internal format date as its result. It invokes the Timestamp routine to perform its work. Note that, as supplied, this does not handle timestamps with millisecond extenstions, but ...

Obtain the name of the table using DSGetParamInfo() function. Open the table using the Open statement (if its a hashed file or UniVerse table), then use ReadU and Write and Close statements to work with the table. If the table is in another database, use BCI functions such as SQLConnect (), SQLPrepa...

Just compare field1 [1,10] with field2 [1,10] >>> Scott.Burnett@noswa.co.uk 02/04/02 10:57AM >>> Hi How can you compare 2 dates in datastage. 2 source tables (ODBC oracle) - 1 field in each is a timestamp, want to compare 2 timestamp fields and only input matching records to target target (ODBC orac...

Heres what I have for this particular job: --------------------------------------------------- DataStage Job 252 Phantom 7851 Job Aborted after 1 errors logged. Program "DSD.WriteLog": Line 121, Abort. Attempting to Cleanup after ABORT raised in stage SbModifSubscriberPrepTrAddress Job Aborted after...

This is a topic for an orphaned message.

Did you try looking in the files in &PH& to see if there are any clues there? -----Original Message----- From: Folot, Pierre-Andre [mailto:Pierre-Andre.Folot@microcell.ca] Sent: Thursday, 7 March 2002 6:14 AM To: datastage-users@oliver.com Subject: Abnormal stage termination Hi, When running one of ...

Hi, When running one of our jobs, I receive the following error: "Abnormal termination of stage SbModifSubscriberPrepTrAddress.RemoveRowsWithInvalidData detected" I ran the job an innumerable number of times and it always returns this error, even after recompiling the job, saving to an other name, r...