DSXchange

Good Morning, Question: We are formatting input transaction from a Landing Oracle table (via an OCI connection) to an sequential file output. We utilize a single transformer. Our average record is approx. 500 bytes and we have 55 fields. Our throughput without any formatting transforms is approx. 33...

How much are they paying? -----Original Message----- From: sridhar [mailto:sridhardoss@vsnl.com] Sent: Tuesday, November 05, 2002 12:47 AM To: datastage-users@oliver.com Subject: looking for Datastage proffs for HCl Technologies in singapore We have an urgent reqt for Ardent Data Stage. With 2 + yrs...

Sridhar, can we have more details about this positions. Thanks...zk -----Original Message----- From: sridhar [mailto:sridhardoss@vsnl.com] Sent: Tuesday, November 05, 2002 12:47 AM To: datastage-users@oliver.com Subject: looking for Datastage proffs for HCl Technologies in singapore We have an urgen...

We have an urgent reqt for Ardent Data Stage. With 2 + yrs of experience.There are 6 positions and they would be all be working onsite at Singapore,long term



thanks
sridhar doss
niche consulting

There are two BASIC statements, SELECT and SSELECT, and there are two RetrieVe query verbs, also SELECT and SSELECT, and there is also SQL which may suit you better if you are familiar with SQL. The difference between SELECT and SSELECT, in both contexts, is that SSELECT sorts the key values, while ...

You need to SSELECT with a BY clause. Cmd = "SSELECT hashfile BY field1 BY-DSND field2" execute Cmd capturing Output loop while readnext id statements repeat Claudioveiga@aol.com wrote:Hi all, I want to use a Select command to read the hash keys and then classify these keys in another order before u...

Hi all,

I want to use a Select command to read the hash keys and then classify these
keys in another order before using the command read ...next. Does anyone know
how is the best way to do that?

Thanks in advance

I will be out of the office starting 11/01/2002 and will not return until 11/04/2002.

I will respond to your message when I return.

In general, no. The only way would be to have the Oracle procedure invoke the operating system shell which in turn could use the dsjob executable. But DataStage is not meant to work in this "on demand" way; for example, if your procedure is invoked a second time before the first invocation of the Da...

Is there a way to start a DataStage Job by using an Oracle procedure? Thanks Lisa The sender of this electronic message intends that this e-mail be used exclusively by the individual or entity to which it is intended to be addressed. This message may contain information that is privileged and confid...

Thank you all for your help I ended up writing the routine as follows: split( delimiters, name ) * delimiters will be " ~`!@#$%^&*()_-+={}[|:;,.?/]+" : " * replacement values " " cleanName = Convert( delimiters, replaceWith, name ) cleanName = Trim( cleanName, " " ) Thanks Alejandro -----Original Me...

Hi Simon, Thanks for your response...can we take it one step further and ask how to get the UtilityExecSQL available on the drop down list and also the syntax to run an Oracle command from SQLPlus... thanks, Doris Simon Fryett wrote: > Hi, > > there a couple of ways you could achieve this: > > 1. Us...

DataStage has a separate CRC32() function from the checksum() function. It should be in the 5.1 release. -----Original Message----- From: Galemmo,Nicholas,GLENDALE,IS [mailto:nicholas.galemmo@us.nestle.com] Sent: Thursday, October 31, 2002 3:42 PM To: datastage-users@oliver.com Subject: RE: Checksum...

Here are two other suggestions; One is another routine written out in long hand; ***** Split(InputString,DelimChars) MyNames = InputString DelimCount = Len(DelimChars) For i = 1 to DelimCount MyNames = Ereplace(MyNames,DelimChars[i,1],,) ;! converts delim chars to a comma Next i MyNames = Trim(MyNam...

I will be out of the office starting 11/01/2002 and will not return until 11/04/2002.

I will respond to your message when I return.