DSXchange

Hi,

I am using Double quotes

Hi All,
Can any one help me on this..

Hi All, I am using one sybase database table 'XXX'as my source ,and it contains one column like 'enddate'. and the values are like for this column in database are : 31 Dec 3999 21Aug3999 etc.. In my source sybase stage ,when i tried to add user defined qry like select enddate from XXX where enddate ...

Hi All, In my jobs i am converting julian format to date format by using below conditions: DateToString(StringToDate(Left( XXX,8), "%yyyy%mm%dd"), "%yyyy-%mm-%dd") this code is working fine when my source column 'XXX' is varchar But it is not working,if my source column is 'integ...

Hi Shivaranjani,

Try this may be it solves ur problem:

If IsNull(INP_1.Value) Then ""else(If Trim(INP_1.Value) =1 0r Trim(INP_1.Value) ='' then 0 else 1)


Cheers,

Thanks ArndW/All,

This is solved my problem...

Thanks a lot

cheers,

Hi,

I am mapping this 'XXX'field to one of my out put field in a .ds file.

and the derivation i am using like:

If Len(DSLink139.XXX <9 Then "ZZZ" Else DSLink139.XXX[7,3]

this is wrking fine in the records,but some of the records are getting dropped..

hi,

Thanks for the replys ,but i am not using any constraint in my transformer..

still i am getting the same issue.

Yes ,I am sure that I am not using the field anywhere?

Hi, I am getting issue in one of my job,when i tried to run the job the some of the records are getting dropped from transformer stage before target stage. message i am getting in log is: Transformer_143,0: Field 'XXX' from input dataset '0' is NULL. Record dropped. This message still getting even t...

hi Mavrec/sas

Thanks for the reply,but both my input and output columns are varchar.

So how to proceed in this case?

Hi All,

Could any one help me to solve below request:

I have a input column in my input table like 'XXX'.

I need to map this to an output column as per below reqrmnt:

if length of column XXX < 9 then need output like 'AAA'

Else out put like (7-9)of the xxx COLUMN VALUE.


Tx in advance

Hey,

Thanks balaji....

Its fine now..

Hi All, I am looking for some simple conversion solution. My source table is Syabase database table,in that i have a column 'Price' for this price column,table has values like: 91.569999999999993, 95.792249999999996, 93.677160000000001, 93.459000000000003 And the datatype of the column PRICE in data...

Hi All, Can any one help me to resolve below FatalErrors,getting in my job: node_node1: Player 4 terminated unexpectedly.-----(FATAL) main_program: Unexpected termination by Unix signal 11(SIGSEGV)-----(FATAL) Lookup_Underlying,0: sendWriteSignal() failed on node dvslcwd08 ds = 7 conspart = 0 Broken...