DSXchange

my problem is file won't be there if first job processed '0' records file won't create this some other thing No, you will find that unless you are doing something super special - when a job runs that writes to a sequential file, it will always create the file. If the job 'processes 0 records' that ...

You should be able to use the Wait For File stage for something like that, if I'm following you. Set the Timeout Length to zero for a one time check. Your problem will be the file will always exist, I would think, as the file will be created in a job but will be empty if nothing is written to it. Y...

Hi, I need to set is file is there then trigger otherwise exit, output of first job is input for 2nd job, so, if no records are processed in 1st job then 2nd job will abort we should restrict triggering of 2nd job. Is it possible by using of wait for file activity........anybody tell me how we can u...

Basically you have to get the metadata to match. One is using string, the other is using ustring in the record schema. You could try changing the data type in the table definition so that it matches ... Thanks ray yes i am converting the datatype of lookup table from nonunicodedata to unicodedata b...

HI,

I have source is unicodedata but lookup table has nonunicodedata while doing lookup it's rejecting. pls tell me how i can do lookup in this case

Thanks in advance
regards,
Bollineni.

, DROPTABLE='No', GENDROPDDL='Yes', DROPDDL='DROP TABLE USERSQL='UPDATE sptdr1.ITEM_PUBL_EVNT SET STAT_C=\'2\' WHERE STAT_C=\'U\';', CONTBEFORESQL='YES', CONTAFTERSQL='YES', GENSQL='No', DSTxnSize=0, DSSQLType={dummy=4}, DSSQLPrecision={dummy=1}, DSSchema='record ( dummy:int32; )' } is not a valid p...