DSXchange

Hi, Its working fine when i tried to load this column of the table with summ value. Please let me know how to use APT_DISABLE_COMBINATION environment variable . the stage is a transformer but i dint move the column from tthe table to output of transformer. then where do i get the need to use null ha...

Hi
Why do we get the following warning, when i tried to move data from a table to a squential file.

APT_CombinedOperatorController,0: Field 'LAST_UPDATE_DATE' from input dataset '0' is NULL. Record dropped.


thanks,

Hi, Using the Query this way solves the problem: UPDATE LAND_REGISTRY SET (Trim(Land_registry_id)= TRIM(ORCHESTRATE.Land_registry_id)) WHERE (NVL(Trim(Paon),'N/A') = NVL(TRIM(ORCHESTRATE.Paon),'N/A') AND ) AS far as i know you cannot compare two NULLs. The where clause will always return falls and t...

Actually no necessary.... as we are updating the fiels... let me correct it.. UPDATE LAND_REGISTRY SET (Trim(Land_registry_id)= TRIM(ORCHESTRATE.Land_registry_id)) WHERE (Trim(Paon) = TRIM(ORCHESTRATE.Paon) AND Trim(SAON) = TRIM(ORCHESTRATE.Saon) AND Trim(STREET)= TRIM(ORCHESTRATE.Street) ) Just a c...

Am i not clear enough :?: Hi, I have a source which has nullable fields . and these nullable fields are being used to update a record in the table. Like paon,saon,street etc.. these are nullable and the query used for update is: UPDATE () UPDATE LAND_REGISTRY SET (Trim(STREET)= TRIM(ORCHESTRATE.Stre...

Hi, I have a source which has nullable fields . and these nullable fields are being used to update a record in the table. Like paon,saon,street etc.. these are nullable and the query used for update is: UPDATE () UPDATE LAND_REGISTRY SET (Trim(STREET)= TRIM(ORCHESTRATE.Street)) WHERE (Trim(Paon) = T...

The keys are same but not working its giving the same warning.. Whats "APT_DISABLE_SORT environment variable" how can i use this.. :?: The sort and join keys should be the same and in the same order. If it still gives the warning, then try with APT_DISABLE_SORT environment variable. This m...

But it gives a warning of STG_JOIN_6: When checking operator: User inserted sort "STG_SORT_5" does not fulfill the sort requirements of the downstream operator "APT_JoinSubOperator in STG_JOIN_6" It is better to use external Sort stage to sort both the left and right link data. I...

Hi,


Is it necessary to put a sort stage before join stage,

If i am not wrong Join stage does sorting as well.

please correct me if i am wrong

thanks,

I have given this way: IsValid('date',StringToDate(INP_02.S_deed_date,"%mm/%dd/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_date,"%m/%dd/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_date,"%mm/%d/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_dat...

I have given this way IsValid('date',StringToDate(INP_02.S_deed_date,"%mm/%dd/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_date,"%m/%dd/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_date,"%mm/%d/%yyyy")) or IsValid('date',StringToDate(INP_02.S_deed_date...

I have put the settings of:

In my PC:

control pannel<enter>

regional and language options<enter>

customiz<enter>

Date<enter>

Short date format<enter>


as MM/DD/YYYY.

this is making the Datastage sequential file to read in DD/MM/YYYY instead of D/M/YYYY.

Hi, Since i am gettin the dates as d/m/yyyy its not matching with the mask dd/mm/yyyy.... so i have picked up the d and padded it with 0 so that it matches dd and the same way for month as well. Thanks for the help its working. No. Does 'yes' mean it is working for you now? If so, please mark the th...

yes must be because 1/1/2006 dint match with mm/dd/yyyy

right?

chulett wrote:Get rid of the slashes. ...

chulett wrote:Because, as noted, the mask in the supplied example does not match your input format. ...

i have given the mask as %mm/%dd/%yyyy