DSXchange

If you can access unix from your windows os via samba or some other software then you can do this easily by writing a shell script. Something like this has been achieved over here at dsxchange. Try to search for a relative script.

Database issue. You need to ask your DBA to increase the temp space. You sql query is requiring more temp space than is available.

What are you doing in your transformer?
Are you calling some kind of routines ?

What exact version of datastage are you on? I know if the parameters are defined as environment variables for any version lower than 7.5, you cannot view data, you need to put the fully qualified path of the file or the DSN, username and password for a database stage.

I Know Craig,what you are talking about. At times,i have been that 'kind hearted soul'

After all the suggestions you got, what derivation are you finally using now for your conversion?
Concatenate 00:00:00 at the end of it with a preceding space. See if it spits back the same error.

vsi wrote:Hi, Kris
source datatype is: varchar, Target datatype: date

Thanks

Ok, now i am confused. The OP says the target type is 'date', Craig you say its timestamp. What is it???

there are rules for post deletion - you can only delete your post if there are no replies to it. Once someone replies - even with a request to delete the post - you can no longer delete it. So that means, once a duplicate post is identified, do not reply to it if it needs to be deleted, even replyi...

This in-evitable cycle has been going around for years. Never the less, companies still fall prey to it. I guess its the corporate industry tactics, thats what keeps the money rolling

Me agree with you Kim. Me thinks you should get in touch with vsi and get more info on this IBM SOFTWARE GROUP.

Need more info. What exactly do you want. Do you need the log files of all the jobs in a particular project, or you need particular info from log files for all the jobs? Plus you sure you want to collect the log files of all the jobs in a single sequential file. That file is going to be huge if you ...

IF your source is a database, i would suggest doing the aggregation at the database level. Will be a bit faster.
If not, then for sorting, do the sorting at the unix level, again will be a bit faster.
IMHO.
Regards,

See if this ICONV works. DOnt have access to DataStage so cannot test it at the moment. Try it

Try not using the sub routine at all and see what happens to the job. Did you try to debug it?

Once done with the Clear.File for the job.. make sure you have the job log set to auto-purge from now on.