DSXchange

Thank you Craig. Yes. It works. Asked too soon. For some reason,in our install, I had to compile more than once to get changes in job sequence working. This is what I got in the log when I ran first time : CL_FILE_CHECK..JobControl (DSWaitForFile): Timed out after 00:02:59 while checking file '#$Ext...

Logic,
There is no exception handling or email notification in the sequence. Its a simple single line of job flow with only four job activities. Each job activity triggers the next if it 'Executed OK'.

Thanks.

Hi,
Can we set the file name in the 'Wait for file activity' in job sequence as a parameter. When I tried the parameter wasn't parsed to the actual file name.
Or writing a routine and send the parameterized file name to DSWaitForFile function in the only option?

Thanks.

After bumping into the same problem more than once, figured out that this is related to Ecase 57785 - A known issue where jobs would not work if the Column-Generated SQL Query is longer than 1024 bytes. Work around is, obviously, to copy the column-generated SQL and stick it in the User defined tab....

The job is the last one in the sequence. The sequence ends there and there are no triggers/links coming out of the last job.
What else I should look for?

Thanks.

Hi,
You could sort the data in descending order of period and then use stage variables to increment the RETLQTY.

Hi, I am trying to make my job sequences restartable when one of the jobs has aborted. The add checkpoints property is turned on for the job sequence. The property is turned on in the administrator too. When a job in the sequence has aborted the the logs in the sequence says the job status aborted b...

Oops.. sorry for double posting. Didn't realise i did that. Got to get used to how to post properly . My bad.

edward_m,
The number of columns in the link should be equal to the number of bind variables used. Guessing its bcoz you used :3 twice.
The advice given to you by others was to put the delete SQL in another stage. Not in before or after SQL in the same stage.

edward_m,
The number of columns in the link should be equal to the number of bind variables used. Guessing its bcoz you used :3 twice.
The advice given to you by others was to put the delete SQL in another stage. Not in before or after SQL in the same stage.

Arn73, The following post might help you to proceed. http://www.dsxchange.com/viewtopic.php?t=96215&highlight= It appear to be slightly different. I have the output file where the columns are the second part of the input file key. Also, the number of columns in the output is fixed. arn73, The p...

ray.wurlod wrote:Is the first Aggregator stage doing anything you couldn't do with a GROUP BY clause in the SELECT statement?

The source OCI stage and the first aggregator together do a vertical pivot. I had used CASE expression to shift the column value and then sum the rows in the aggregator to pivot.

This is my job design Hashlookup | SourceOCI9i--> Agg--> IPC--> Xfm--> Agg--> IPC--> Xfm--> TargetOCI9i When I thought i was going to increase some performance by increasing the buffer size in the IPC stage properties from 128 to 256, the second aggregator stage started aborting. The logged error me...

More precisely, Oconv(DATE(),"D/YMD[4,2,2]"):" ":Oconv(TIME(),"MTS"). If you don't need the exact time part just append " 00:00:00" to the date part, as in Craig's solution.

From SQL server 7.0 online books: timestamp (T-SQL) A database-wide unique number. The storage size is 8 bytes. Remarks A table can have only one timestamp column. The value in the timestamp column is updated every time a row containing a timestamp column is inserted or updated.The value of a timest...