DSXchange

This is exactly why I asked you to post your sql. by the way, the reference table is from a SQL Select statement like . SELECT RA_HCUSTOMERS.CUSTOMER_ID, RA_HCUSTOMERS.CUSTOMER_NUMBER, RA_ADDRESSES_MORG.ADDRESS_ID FROM RA_HCUSTOMERS, RA_ADDRESSES_MORG WHERE RA_ADDRESSES_MORG.PARTY_ID (+) = RA_HCUSTO...

PeterPol wrote:But they (IBM) have told me that I can use external dll's in Designer without using the original source.....

Did they not also tell you how to do this?

You could also find any post by kcbland register at his site and download their free utilities. One of which does this timestamp difference.

Post your Oracle reference SQL. Is it generated or user defined?

ray.wurlod wrote:Last time I looked (7.5.1), "DOS format" was not available for record delimiter when running on UNIX platform. Otherwise I would have cited that as the appropriate technique.

Wasn't that what I quoted from the Developer's Guide?

I observed that as well and didn't feel it was relevant. Is not the General forum where (amongst other things) Sequence job questions are 'supposed' to go? Maybe we need a 'Sequence' job type choice...

Roy, feel free to snip all the chit chat when you move this - where ever it ends up.

Nothing parallel about this question.

(does Roy even care where we say to move them? I would guess he just uses his own good judgement [I do Both])

^M is a <CR> and indicates DOS style record terminators.

Yes. You can. Go to DS Administrator, select your project and click on the "Properties" button. In first tab "General", you can specify the purge settings you want. Both of you making this suggestion fail to note that it is only applied to new jobs created after the 'global' change. It doesn't auto...

DSJobStartDate would, perhaps, be a better choice.

An Exact match search for "check that 'gdb' and 'sed' are installed and on your PATH" gets me 8 hits, suggest you go through them, see if any help.

I don't want to use the oracle sysdate date because our database server have a dummy date. I don't even want to know what that means. You've basically got it, just need the to_date: SELECT ROWID, TO_CHAR(DATA_LOAD, 'YYYY-MM-DD HH24:MI:SS') FROM Table_Employee where data_load > TO_DATE('...

How are you getting the filenames now? If it is some flavor of automagic, won't it simply pick up with the last file it failed on?

I'm just curious... are you doing this as a learning exercise? Is that just a made up example or the actual SP you are trying to run?

I'm wondering why you wouldn't simply encapsulate the 'functionality' of that SP directly into your job?

The hash file is a lookup of itself. I don't know about anyone else, but I'd appreciate a clarification as to what this statement means. The 'trim' would help get past the classic 'lookup doesn't work' problem - the keys don't match because of extraneous whitespace in one or both values. People loa...