DSXchange

input value val=xxxxxxxxxAAAAAAAxxxxxBBBBBBBBBBxxxxxxxx
trim(val,'x')
got a result as
AAAAAAAxBBBBBBBBBB.

i have server edition 7.2 with following string functions

syntax Trim(%string%,[%stripchar%],[%option%])
TrimB(%string%)
TrimF(%string%)

i think you want to check the date format or if the date is valid at execution, i mean to say while you are propogating input data to output.

in tranformer you can check if date is valid, if not you can call an inbuilt routine by Ardent Software, Inc. of sdk UtilityAbortToLog.

USER-DEFINED ERRORS :The lists should contain both database-specific errors expressed as the integer portion only as well as any user-defined errors that can be returned by the procedure example in your case ORA-20001, so just specify 20001. Now you can use this value for Fatal errors or Warnings. F...

hello, i am not aware of parallel Extender, but hope their will be something similar for server edition, stream records and reference..

so you use your child table in stream records and parent table in reference.

hello, as replied by George it works fine, also by changing data-type of date in OCI stage to timestamp, and without applying any format specification it will work.

Array size : Specifies number of rows to be transfered in one call between datastage server and oracle server before they are written. setting large number use more memory on the client machine, this minimizes round trips and maximizes performance by executing fewer statement. transaction size:speci...

hello i have tried with same case as yours and it works for hash file as well for seq file when i use below conditon input seq file varchar length (40), 2006-11-13-00.52.50.932000 transformer: DSLink36.date1[1,4]:DSLink36.date1[6,2]:DSLink36.date1[9,2] output hash file integer length(10): 20061113 i...

May be below code meet your requirement, name of routine DETERMINEDAY, with input parameter Arg1 in format 2007-05 or 2007-12. ---------------------------------------------------------------- output format : TEST #1 ******* Arg1 = 2007-05 Test completed. Result = 01/06/2007 -------------------------...

hello i am not aware how job sequencer or Routine_Activity works in datastage, but i think below code will enable you to check the file size, and then do further processing. name of routine: file1 -----------------------code of routine file1--------------------------------- stat='' if Arg1=@null or ...