DSXchange

you could always create header, trailer, and detail in a seperate file and concat to a new file name in an after job sequence if you need counts for any create an aggregation

Thanks for your response. I am on Windows not Unix, but your response should work either way. I was hoping there is a way to rebuild the hash file rather than fix it. The fixtool sometimes deletes records if it can't fix them. I'm not sure how I could tell if I lost some records from the file. I mig...

I ran out of disk space and corrupted my DS_JOBOBJECTS file. Is there a way to rebuild it?

Having trouble converting - '2007-08-13 02:59:13.730829 PM' to an Oracle 12 Hour Timestamp Have tried to_date('yyyy-mm-dd hh:mi:ss.ff6am' (among others) can't find any documentation

had a phantom running you have to cancel all processes running against the file. You may have to go into administrator (or uv) do a list.readu to determine user id and processes and end processes and release user.

If I do a lookup to a hashed file and my output order is such that I write to the same hashed file before using the data looked up is the original data from the lookup still available to me or do I have to either save it to a staged variable or change the re-write of the hashed file to occur after I...

I have a dssendmail with an attachment that I am having a problem with -- the path of the attach contains 2 \n's -- attach:g;\tst\sdw\nww\nwwvndrxxx.txt the jobs gets to the first \n and treats it as a line feed is there any way around this.

You could always do an Iconv and the Status() to check if it was a valid date to convert conversly if it is valid you could use an Oconv and concatenate a dummy timestamp to the end of it.

This has been discussed before. Please do a search using the 2017 and you will find the answer to your question. A search for the answer should always be done before posting a question.

Is there any rule to set an optimal read/write cache the default is 128mb but I seem to get an increase in speed by increasing these. Is there a limit after which I will take a performance hit??

From NT If you have admin you can do a LIST.READU

Why use a before/after subroutine of cat a,b > c when you can (provided formats are the same) use a link collector to do the same work in the job.

If you pass the value to a teradata api filling in on stage tab teradata director(server) UserId and password for logging in to teradata. give it the table name and user defined sql to select the record using (passed field(field type) and a select from where field = :(using field name) it should be ok

sorry should have been a reply

If you pass the value to a teradata api filling in on stage tab teradata director(server) UserId and password for logging in to teradata. give it the table name and user defined sql to select the record using (passed field(field type) and a select from where field = :(using field name) it should be ok