DSXchange

Hi,
I am trying to use below syntax is sequence its not liking it any idea why

if DSJobInvocationId = 'AM' then ('AM', 'NA') else if DSJobInvocationId = 'AP' then ('AP','JN') else ('EN', 'EW', 'EM')

i get warnings while doing it
Data string '04/24/2012 04:20:36' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the value for tag %yyyy has fewer characters than expected.

Hi,
I am using current_timestamp in transformer which gives ouput 2012-05-05 08:05:37
user want it to be 05/05/2012 08:05:37 . Any idea who should i do it in transformer.

Thanks

Is "COUNTRY_CODE" a result from a lookup in earlier stages ?

No its mapped from db2 table to transformer

Are you using COUNTRY_CODE in a stage variable or constraint expression?

stage variable

Hi,
i was getting column null error so i did NullToValue(to_transf.COUNTRY_CODE,'WW') and now i am getting

Transform,0: Fatal Error: Null value on the accessor interfacing to field "COUNTRY_CODE"

Thanks

Doing below in transformer its not liking it

IF to_transf.COUNTRYCODE IN("US","CA") AND to_transf.COUNTRY_CODE IN("US,"CA") THEN '2'
ELSE '3'

There are more then 4 files but i only want to load below four files
#$DATA_DIR#am.txt||#$DATA_DIR#eu.txt ||#$DATA_DIR#ap.txt||
#$DATA_DIR#thirdparty.txt

ok how can i do
#$DATA_DIR#am.txt||#$DATA_DIR#eu.txt ||#$DATA_DIR#ap.txt||
#$DATA_DIR#thirdparty.txt

its not file1,2 and 3
it has names like

#$DATA_DIR#am.txt
#$DATA_DIR#eu.txt
#$DATA_DIR#ap.txt
#$DATA_DIR#thirdparty.txt

so what will be file pattern in this case

If i change

Read method = File Pattern

and i have four files as #$DATA_DIR#file1.txt,#$DATA_DIR#file2.txt,#$DATA_DIR#file3.txt,#$DATA_DIR#file4.txt

what will be file pattern ?

Hi,
How can i append 4 .txt files in a db2 table all four files have same columns.

Thanks

Well i tried Trim(to_transf.STATUS) <> 'Agent' too its not working

Hi,
I am trying to remove records from incoming stream in transformer
doing below code as i don't want Agent as output and its not working

(to_transf.STATUS= 'Agent')<>0

I guess this is what you guys suggesting

step 1) load db query to dataset or faltfile
step 2) Used grep or wc in Execute Command Activity
step 3) Used Nested Condition to see is file return count

Now here i my confusion should step 4 be Wait for file activity ?

jwiles wrote:You can use the built-in scheduler in Director

Lets say i schedule the job every 15 minutes from 7-10 pm
and it ran on 8 pm i just want to run it one time once it find the flag just
run one time between 7-10 how can i do that