DSXchange

Hi, fewer jobs <> more easy maintanance and tends to make the jobs more complex. to answer your question yes you can do it but not as strait forward as clicking a few check boxes. you'll need to customly force this via adding dummy constraints and or using basic routines. if you really want such com...

Hi,
I guess the dropped it from the stage/s since when working with NLS once read it is already converted to UTF8 (already at the seq file stage) and if it doesn't modify convert anything in the merger/splitter stages there is no real need for them to have NLS in them.

IHTH,

Hi,
Are you refering to IPC?
I never heared of IRC (am I missing something? )

Hi,
It might help to state the expression you use and the exact error you get so we might give a more helpfull reply.

Well, I thought you might have already did it (I know Amos). Have you checked records around the record that comes in the error code? like slice -100 +100 records in a constraint and see if it fails? Use a transformer with @INROWNUM or another identifier. usually when it consistantly fails in a cert...

Hi, I never had 2 many problems with NLS Fixed Width files. Then again I never worked with row Merger/Splitter on them. Having that said: Check the files are fixed width. The stages involved writes exactly what the read with no conversion or interpretation so the NLS should not be an issue with the ...

Hi, If you precount the number of rows in your source data you can run a multipe instance or in a loop a job that passs P_MIN_VAL P_MAX_VAL then use them in the where part to each time read only 1 portion of the data. you'll probably need to add somelogic around this, but that's the general idea. IH...

Hi, Never had that one yet but this is what comes to mind: I would go about this in the following mannor: 1. build the file and onlly populate 1 row in it. 2. use ANALYZE.FILE in the uv command line; in case it's a Directory rather then acount file set the voc entry first with: SET.FILE <logical nam...

By the way,
how about:

read the value in the Xfm write the original value to the file in one link and ion another link calculate and update the value.

IHTH

Hi,
Yes, the only way to enshure no changes while you update would be to lock the record/s at hand, just check with your DBA if this might be achieved via you Isolation level (I think it can), if not you'll need to issue a lock statement.

IHTH,

Hi,
actually env is for unix set is for dos.

Hi and Welcome aboard , Do you have different NLS in the same column in different rows? In this case you need NLS that supports all possible languages. I think you need the DB to support all NLS you need anyway. If you ment in different columns on the same row, DS has per column NLS but what about y...

Hi,
Good to know Vincent Thanks(asbout the dsiff/change capture).
Iguess that warnlimit thru sequence jobs is another one for the wish list.

ahem,
Ray did say efective version 6 does it exists in previous versions?

Hi, instead debating on is it wise to run after routine for this rather then use a seuence and run it after the job finishes.... at the begining of the routine lock 1 of the 64 built in semaphores so the routine will never run in parallel if it suites you: i.e: Lock 1 < routine code > ... ... ... Un...