DSXchange

In truth i should check database NLS configuration Yes, you should. Good to know when any characterset conversions are involved. Now the new question is : what if i change the project default (by Administrator) ? Should i expect other kind of errors on other jobs ? Hard to say, but I could see that...

Yes, a very very remote chance but a chance none-the-less. Still, I wouldn't let that dissuade you from using it for CDD as you are doing as that is the typical use for it here as a search would reveal.

Why not read the Installation Guide? You don't seriously expect people to type all of the steps into this forum for you, do you?

Then OKCUA4[7,len(OKCUA4)] Else

Or something similar with Right().

What is the status it actually returns?

Bummer, that would have been too easy I guess. For grins, what are the Oracle data types for the four columns you are selecting? Also, what version is the Oracle database and what client version are you using to connect to it? All four digits, please, like 9.2.0.5 for example.

CLEAR.FILE is damaging if jobs are running, checking for anything 2+ days old there should be perfectly safe unless your jobs run for days, that is.

Sure, many ways. There are KeyMgmt routines in the sdk branch, you can use @INROWNUM added to a max() starting point, reference the db sequence object directly in your sql, etc etc.

A common problem with approaches like this are quotes get stripped and that looks to be what's going on here. Either escape them or put the awk statement in a .bat file and execute the batch file.

Ok. Nothing about that needs to be 'custom' but let's see... first suggestion would be to add the alias you defined to all columns and see if that helps:

a.COD_PORTFOLIO,
a.COD_IMSI,

Etc. All field names in the query.

ps. Nothing is obvious from the other side of the glass.

Yes, something like your find command running in cron is pretty typical. And other than your job logs, which auto-purge should handle, there really isn't any other directory needing housekeeping.

The error:

DS_FocusGroup wrote:Command failed to execute - Missing field separator '"{if (NF==3) print $0}"' is not recognized as an internal or external command, operable program or batch file.

What do you think the answer is? I'm wagering you'll get it right.

OpenSeq would be BASIC and thus a 'Server' routine, a parallel routine would need to be in C++. Depending on exactly what is in your file, a simple cat may work to 'read' the file.