DSXchange

To which job's parameter. It cannot be the same job as parameters cannot be set once the job execution starts. You can store that value in a text file and then read that text file and set that value as a parameter. If your doing it from command line you can cat that files contents into a variable an...

I job might have already started but the status still shows that its not running. Might be a delay in updating the RT_STATUSnnn file. Try clearing the status from the director, clearing the &PH& folder will also help in quicker response times.

Why are they there? Which jobs created them? Are they still required? The only safe way to delete Data Sets and File Sets is to use either the orchadmin utility or the graphical Data Set Management utility in the Manager client. DO NOT attempt to delete them using rm commands. Except the orchadmin ...

Thats why i asked, is this the only culprit job or other jobs with a transformer acting up too.

In the ODBC Enterprise Stage User Guide,you will find the differences in the first few pages.

At the end of each job, have an after-job subroutine, gather the row count for your target link going into the table. Or maybe even inside the job itself after that particular link finishes, populate the link count and the table name into a delimited file. Do the same in all 50 jobs. The mode of wri...

Try

Note the space before the first set of 00.

That error message is from the odbc stage. I think you need to put ORDER BY clause in the bottom half and not the selections tab. Cant remember whats it called, and dont have access to DS at the moment. As per your second query, do you have the dsn name, table name all properly set for the link goin...

Internal format will work only if its defined as Date in the target database. If its timestamp then internal format wont work. Try Ray's suggestion, which is the same as Ken pointed out. If that doesnt work that means you have to supply timestamp.

First of all make sure its in the correct format (YYYY-MM-DD HH:MM:SS.nnnnnn). Even if you dont have the franctional seconds part, its ok. DB2 will add that during insert. Make sure you have a single space between the date part and time part of the timestamp. If all of that is in place, then try cha...

You can now mark the post as resolved.

Well i think your problem is right there. Contact those guys and ask them when is the network traffic the least. Schedule a job to load the table into a text file. Then read the squential file instead of the table directly. This way you dont have to change your schedule and you can select data when ...

Ok i get it now. Click on the odbc stage, from the dropdown on the outputs tab, choose the second link and add all the info for the second link again. It has nothing defined and hence your problems.

More like monitor the activities from the database. DS will just show that the clock is running and nothing is being passed. Also try clearing the &PH& folder. It might help.

Quote the sequence name.