DSXchange

For the second, you need to transform the SQL Server timestamp to conform to what Oracle is expecting, that or use your own sql with a matching 'date format picture'.

Compare that to the heretical action of quoting the entire original post just to add your advice.

Could you not do your grants and import in another environment where that is less of an issue, development for example?

No to both. I've found the best answer is to always parameterize things like that and make sure that - outside of production - all of the emails come to the developer(s). Or the QA folks.

Fixed width recods and char fields cannot be trimmed like that. Why not use varchar?

Well, even if it doesn't happen, you should be fine using a 9i client to access a 10g database, we do that here as we also have 9i databases to support.

You can't cat the header onto the end of the data, you need to cat the data onto the end of the header. Either that or cat them both, in the proper order, to a new file. I'd suggest the latter.

You're fine. Will you be upgrading the client version of Oracle on the DataStage server as well?

Left that for you to post, Ken.

You schedule the job using the Director and can simply 'Add to Schedule', over and over, at five minute intervals. Not ideal, but would work as long as your job never takes more than five minutes to run!

So... you are just asking if there is a 'tertial' version of this to_date function? to_date(trunc(sysdate,'Q')) I have no clue, but if it was me I'd take this question to my Oracle DBA. I also couldn't find an official name for a 'four month period' or one-third of a year, but it doe...

Something like memory leak issues would need to be taken to IBM for resolution, I would think. See if it is a known issue on that platform and if perhaps a patch is available.

Right now, what does get created when you have no input?

sinhasaurabh014 wrote:Thanks!! Does that mean all the field/columns defines as a key has to be there in the where clause

Actually, the anwer is 'yes'.

If all you want are the data rows, can you not just define that metadata in the stage and anything that doesn't match - header,trailer - will automatically be 'ignored' by the stage, yes?