DSXchange

Unknown is the sql type. It can also be varchar, it can also be char. The point that ArndW and umamahes are trying to make is that you need to first check for a valid format. If you find a valid format then change it to timestamp, else you can do something with it. You can possible flag it, reject i...

I need to purge job log via command not in Director! Welcome Aboard, Care to elaborate on that? If you do a command line purge it will remove the default purge settings. And if you forget to run the command again, your log file will grow without any check. Hence ArndW's suggestion of setting with D...

Sample data would help

Care to share the error message with us ?

I highly doubt its the 2.2 Gigs limit issue here ArndW. As you noted, the job would abort and atleast spit out a message in the log file. None of that is happening. I think your analysis about "buffered write" might be it. Lets see what the OP comes back with.

I missed that part in the OP's next to last reply. Sowwiee Then this is strange behaviour. I would request the OP to examine the log and see whats actually going on when it comes to that particular job. When it requests for a "job reset". Go into that individual job and see whats causing the abort t...

I think most of us who are working consultants would not be able to use DSXchange if a license number is required . Merci merci

Also make it a practice to close the designer or atleast all the jobs if no work is done on them. If only a few jobs get locked, you can go to DataStage director and release the locks individually using "Clean Up Resources" under tools.

You can mark your post as "Resolved" if your questions are answered.

Choose the option of "Reset and then Run" inside your job activity for each job. This way if the job requires resetting, the job will be reset first and then run.

When you say its not working, what do you mean? Is it not executing at all, are you getting syntax error. Look into your log file. Plus looking into your stored proc. code, it does a direct insert. Your design will be simple. Something like TeraData API ------->Seq. File/Transformer You will place y...

When you say "Failed to return any values", you mean that the none of the source records had a hit on the hashed file? Hashed files have size limitations. 2.2 GB is the limit. But this barrier can be overcome by making it a 64 bit hashed file. Search the forum for more information on "how to". Make ...

Welcome Aboard,
Start a new post. Specify a link to this post in your post for reference. What you are doing is hijacking a post and is not apprciated.

Thats what I was thinking as well. The forum could be named as "Spam Catchers", a general alert can be made about the forum. Something to that effect.

What is the length that you are specifiying for that field? Also make it char and not varchar.