DSXchange

I am using numeric

I am trying to have a sequence.I am write the maximum sequence number from oracle in a sequenctial file. I am using a execute command to cat this file.this is the message in th elog. Seq_preapp..JobControl (@Execute_Command_6): Executed: cat /home/cvid/max_seq.txt Reply=0 Output from command ====> &...

can you please ealborate on "need to set up the routine definition in that particular project" .I searched the forum and documentation but could not find anything to guide me.

i created a transform routine using dssetuserstatus.The routine works fine in other projects.I can see the routines listed in the but in one particular project when i try to use it in a stage variable ,none of the routines are getting listed when i rt click edit derivation ->...->DsRoutine.Is there ...

thanks very much

StringToTimestamp(Right('0':Field(DSLink8.Eff_date,'/',1),2):'/':Right('0':Field(DSLink8.Eff_date,'/',2),2):'/':Field(DSLink8.Eff_date,'/',3) :' 00:00:00',"%mm/%dd/%yyyy %hh:%nn:%ss") this expression works but just waiting for someone to jump in with a elegant solution.Thanks for all the p...

My version is 7.5.1.A

I tried the suggestions. -> For StringToTimestamp('2/3/2009',"%(d,s)/%(m,s)/%yyyy") , I got the below warning. Transformer_7,1: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%(d,s)/%(m,s)/%yyyy" for conversion "timestamp=timestamp_from_string[%yyyy-...

My job is seq file -> tx -> or db table. DSLink8.Eff_date looks like this 2/3/2009.I am trying to use stringtotimestamp function in the transformer.My time part in the timestamp can be default.I tried various combination as the sainath suggested but still i get the same warning. I am on 7.5.1a Thanks

I am trying to using this function StringToTimestamp(DSLink8.Eff_date,%yyyy-%mm-%dd %hh:%nn:%ss) DSLink8.Eff_date this is a string.I dont mind if the timepart is default. Transformer_7,2: Conversion error calling conversion routine timestamp_from_string data may have been lost I searched red the doc...

thanks for your quick response.can you please elaborate about the first stage you have (oracle reference) what is that to do? also in the lookup stage I dont find any option for sparse lookup?

thanks for your quick response.can you please elaborate about the first stage you have (oracle reference) what is that to do? also in the lookup stage I dont find any option for sparse lookup?

thanks for your quick response.can you please elaborate about the first stage you have (oracle reference) what is that to do? also in the lookup stage I dont find any option for sparse lookup?

I searched the forum for oracle sequences for surrogate key generator. My requirement is that I use oracle sequence .nextval to insert into oracle table.Also use these sequence numbers for later use. I came across so many posts about sparse lookup and getting max sequence number from oracle ,keymana...

Thanks everyone for spending time on this,
The problem is resolved now, It seemed the problem with the way Webservice was configured. Onc ewe changed the encoding style, It started working.
-efxuser