DSXchange

Nothing specific. You have to code/design it. One way would be to read the sequential file and pass the appropriate parameter value via a small routine. This routine can be called while specifying the value of the parameter in the job activity in a sequence job. Or you can code your custom Job Contr...

What is the date format?

There is a matrix chart for supported platforms on IBM's website. You can check there.

Does your code work when run from command line? I see a bunch of problems already. scanf() is to read from stdin. But you are reading from variables so you need sscanf(). Similarly you are writing back to a variable and hence you will use sprintf() instead of printf(). As for the error, how are you ...

Datasets and flat files are copies of the source. So in case of a failure, no need to go to the source again. These data replicas are as presistent as any table. A staging table, technically, is just another database file on another server.

Are you using any stage variables of type int or decimal? If yes, what is the Initial value that you have specified?

Easiest in the Manager. Create a new one, move jobs there by selecting all jobs from a particular folder. Once the move is complete, delete the previous one.

The job is clearly screaming out that it cannot open the file. Please double check the path again. Usually there is a character shift here and there. Its case sensitive too you know.

O yea, left out the `ed from experienced. O well, potayto potaato.

Now thats what you call, experience

Just a way to get your detailed explanation

Is anyone updating the table at the same time your running your job? Get in touch with your DBA, run your job and ask your DBA to monitor whats going on at the database level. He/She will be able to tell you whats going on.

Nick's code will not work if your input is a string. You need a recursive mechanism to check for ascii values if you want to go down that path.
Do you have NLS installed? If you view these characters at the OS level, how do they show up?

Does the file 't_WSW_WSStatsCreation_InputStat_20070421030859.dat' exist in /dsProjects/data/ISLP/Temp_Files? If yes then do you have read permissions on it?

I say get rid of the link collector and load your feed to flat files and in an after job subroutine cat all the files at the OS level. Or if you insist on using the link collector, then make sure that all input links are executed at the same time or else it will time out.