DSXchange

Not if you want the flexibility. TO_DATE in Oracle is like IConv in DataStage and gets you an 'internal' date that can be directly compared to another DATE field without issue. Once you start comparing strings you can cause yourself all kinds of grief. While there are ways you can 'cheat' and just p...

What is it today with two allegedly different people asking the same question? Abhi - are you by any chance associated with the person making this post? As to your questions: a) The repository hasn't been Universe for some time now. b) The repository is now the DataStage Engine, which does bear a st...

Or you could parameterize that entire portion of the query: AND DATE_FIELD = #P_DATE_CLAUSE# Default the value to TRUNC(SYSDATE-1) so that 'normal' runs compute yesterdays date from the current system date. Override the value if need be by passing in a fixed date: TO_DATE('12/01/2006','MM/DD/YYYY') ...

splayer wrote:Yes, it did because in the director it show the complete list of all unzipped files. However, I don't see the files in the directory.

I'll bet they're all in the Project.

You can certainly do it via a number of methods, but why not use TRUNC(SYSDATE-1) in your query instead if it always needs to be 'yesterday'?

Not in the Oracle stage, which was the specific question I was answering.

This is getting crazy. Are you and beaditya the same person? You both seem to be working on the exact same problem, same table, same PK violation, same confusion - same everything. Can the two of you get together and start a single new thread where your remaining issue is clearly defined now that a...

This is getting crazy. Are you and sshettar the same person? You both seem to be working on the exact same problem, same table, same PK violation, same confusion - same everything. Can the two of you get together and start a single new thread where your remaining issue is clearly defined now that a...

Yes... but I personally would not touch them with a 10 foot pole in any job I was concerned about the performance of.

It does a wee bit more than that... why not include a complete description of the solution you are proposing?

Unless you write your own job control code, of course - then you can do anything you want... within your ability.

Check this thread but skip the first three posts.

Ernie posted some information on testing web services. Or have a chat with any resources you have at your company who do that for a living.

You can't! Which part of 'must abort to restart' was unclear?

Doesn't matter what you want, the master sequence must abort to allow the checkpoint restarting to function.

Or an answer to my rather simple question.

parvathi wrote:what actually display column will do and its importance

To actually answer your question - It controls the initial width of the column in the data grid when you View Data... nothing more, nothing less.