DSXchange

Its not do-able. I would love to be proven wrong. But its not possible. You tell me, what date is "09-05-2006"? Is it "9th of May, 2006" or "5th of September, 2006".

I guess we both are saying the same thing "half glass empty, half glass full"
I was referring to the signed decimal fields. As per ebcdic format files, that might require binary transfer.

I beg to differ. The signed decimal fields from mainframe have their last byte the "sign deciding byte". It might look like junk but its actually not. I have done this before. The file is NDM'd in ascii format so that the ftp does the right switch between mainframe and unix file formats. As for the ...

What is your source? Is it a flat file or a database?

You will have to request for a consistent format. This is going to be a challenge as per programming. For example, how can you tell which part is day and which part is month in "01/01/2004". It could be either DD/MM/YYYY or MM/DD/YYYY. You will have to either ask for a consistent date format per dat...

Brad, do you really have to go against the database. dsjob -lprojects run in all the environments, wont work for you?

What are all the possible formats? Can you provide a list. ICONV with Date option should work for most of them. Thats why I requested for a list of all formats so that the odd one out can be factored in.

Is it really showing two digits or the display of that particular column is set to 8 instead of 10?

For the first, do an exact search on key words "floating point decimal is not fully supported".
And for the second one on "A sequential operator cannot preserve the partitioning of the parallel data set on input port 0"

That command is to be run from OS command prompt and not from the Administrator.

O ok. Always love your "to the point" answers :D
There has to be an explanation for this then. Thats the best that I could come up with.

If the job got deleted then its RT_LOG should have disappeared too. If your wondering whether you can get it back, then the answer is,
"only from a backup", else its gone.

Have you tried searching on error messages. I did a quick search and both your error returned results.

RT_LOG will be suffixed by a three digit number. Use that number to find what job it is (use the below query in the Administrator) and then go clear that jobs log from the director.
where nnn= your job number

Did you try to get your script running from command line first? If it does not work outside datastage, it will certainly not from within datastage. Get some scripting help if you have to, a lot of resources present on the web. Once it works from command prompt, call it from datastage. It will work t...