DSXchange

Is it possible to RESET a call job( I am using UtilityRunJob) from Transformer stage? Or Can i use Job control code to check the job status and if necessary RESET before running the Job.
Can any one please provide the basic code.

Thanks in advance.

I have a job where using transformer update a table and after the update need to send a notification to other server using FTP with a table name. This FTP should go when ever the update is successful on Table. How do we achieve this, i tried using Link Output variable validating Update Link SQLSTATE...

when i try to test the routine.. provided input path and filename -- did not not get back any result.

I could able to get couple of examples like the code ReadMySeqFile(InFile) EQUATE Delimiter to ',' Ans = '' OPENSEQ InFile TO InFilePtr ELSE CALL DSLogFatal('Cannot open file "':InFile:'".','') Finished = 0 READSEQ InRecord FROM InFilePtr ELSE Finished = 1 LOOP UNTIL Finished Ans := Delimi...

I need to read a sequention file to get the values and use those values as job parameters to get the data from table in same job also pass the same values to next job as a job parameters.

Any help appreciated!

Thanks for the info,
But the solution to use Update or Insert option will hit the data base for each and every record, and i guess sometimes for each record multiple times.. so, i believe it is extensive DB call process. Please advise me if i am wrong.

no we are not using slowly-changing-dimension.

Hi,
I have a job where i get input in flat file, i need to check the input data againest target DB2 table based on key values, if input row exists in DB2 table validate all the columns data, if any difference - update it in DB2 table, if row not exists insert as a new row.

Thanks in advance!

Thanks Chuck,
RowMerger is fine , i am trying to avoid to enter all the column names in transform stage and in RowMerger stage.

Thanks

I have 50 columns reading from a table , I need to write one row data into a one single column data into a output file. Is there a way with out using Row Merger.

Thanks in advance

Hi,

I have a date filed defined as a decimal in source table as 20050607 format, I need to convert the above date to destination table as Date column type format as 2005-06-07 (CCYY-MM-DD).

any help appreciated!.

T