DSXchange

How about stage variable
variablesum, variable key

where variablesum becomes variablesum:filed:variablekey when field value is 1 or remains variablesum
and the variablekey becomes variablekey+1 when field value is 1 and remains variablekey when field value is 0..........

Simple rule for updattion; Update by fileds A, B , C... for example INSERT INTO A_TBL (A_NUMBER,A_START_DATE,A_END_DATE,A_PATIENT_ID)VALUES (:1, TO_DATE(:2, 'MMDDYYYY'), TO_DATE(:3, 'MMDDYYYY'), :4,); UPDATE A_TBL SET A_NUMBER=:1, A_START_DATE=TO_DATE(:2, 'MMDDYYYY'), A_END_DATE=TO_DATE(:3, 'MMDDYYY...

Nothing else other than ODBC

ask your dba to unlock the table, table lock could be for various resons like roll back when you abort a process or so on...

Why are you bringing in the null records in key coulms, just filter them in transformer or at your source level?
whats your source?

or if your input is flat file and 0 rows means no file? write routen to check file validation and call this routene in sequencer before kicking of the rest of the jobs...
if file is not present the seqencer is finishes and goes to next seuencer.......................................

Folk; I am doing the production support and going through one of the routines returned some one Part of it is CMD = "ls -a ":TmpFilePath:TmpFilePrefix:"*":TmpMarkerFileExtension Call DSExecute ('UNIX',CMD, SrchRslts,ErrorCD) SrchRslts = Oconv(SrchRslts,"G":DelCnt-1:&quo...

Folks;
On my production box, I have just previlages at unix level to log files direcory and scripts file directory, I do not have access to Designer or Dictor to check the periodical speed at which my data is being loaded,
is there any way Could I check from unix level

thanks

I think the proble is hear LodProviderAddr.ILIAD.ProviderAddr.lnkProviders_in: ds_seqopen() - Error in filter command "/usr/bin/sort -u /etldata/cpdr/CPDR_DEV1/common/data/work/ILIADProviderAddress.dat" - sort: Warning: A newline character was added to the end of file Could any experts hel...

I gave the file neme in the file name text box and sort -u in the filter command text box, I am doing it right?????

Hi all; I browsed trough forum and with different post input here is what I am doing sort -u Which i suppose will take care of duplicates by entire record but i am encountering strange problem which I think at unix level the error I am getting is LodProviderAddr.ILIAD.ProviderAddr.lnkProviders_in: d...

Hi all; I browsed trough forum and with different post input here is what I am doing sort -u Which i suppose will take care of duplicates by entire record but i am encountering strange problem which I think at unix level the error I am getting is LodProviderAddr.ILIAD.ProviderAddr.lnkProviders_in: d...

I had recitified the case sensitivity and my command now is

sort - u

but this time different kind of warning

LodProviderAddr.RIMS.ProviderAddr.lnkProviders_in: ds_seqopen() - Error in filter command "/usr/bin/sort - u" -
sort: Warning: A newli


any help on this for me...


Thanks

Thanks ray,
Yes I realaised my mistake aboute case, it was too late, I apolazise
coming to second point
- k option, if I want the sort to be performed on the enire record uniqueness, is sort -u is enough or still -k is required,
thanks in advance

I just did that by putting Sort - U in text box for in General tab, filter command: now the job is throwing warnings Warning 1: LodProviderAddr.NICE.ProviderAddr.lnkProviders_in: ds_seqopen() - Error in filter command "Sort - U" - LodProviderAddr.NICE.ProviderAddr.lnkProviders_in: ds_seqop...